Microsoft Excel for Beginner training centre in Bangladesh

New
EMI EASY PAY

Microsoft Excel for Beginner

Introduction

Microsoft Excel is one of the most widely used software in the workplaces on Regular Basis. The course “Microsoft Excel for Beginners” is focused on building strong foundations of Excel for the Professionals & Students. This application provides an outstanding combination of functions and tools for working with quantitative data analyzing, reporting and decision making. Wherever you grow your career even as a Scientist or Doctor, someday you will need Microsoft Excel!!!

How Participant will be Benefited

Get the most out of Microsoft Excel faster and easier than ever and be the Excel Guru of your work place. In this Course, maximize your productivity with the basic versions of Microsoft Excel’s best tools and shortcuts. The course simplifies powerful features including Create & Manage Workbooks & Worksheets, Manage Data Cells & Range, Create & Formatting Tables, Perform Operation with Formula’s & Function’s, Create Basic Chart & Objects etc.

Methodology

Hands on Training with Practical using of different tools with real life example

Contents of Training:

DAY 01
* Section 01 : Create & Manage Worksheets & Workbooks

1) Create worksheets and workbooks
a) Create a workbook
b) Add a worksheet to an existing workbook
c) Copy and move a worksheet
d) Navigate one sheet to another sheet
e) Select all sheets
f) Import data from a delimited text file

2) Navigate in worksheets and workbooks
a) Search for data within a workbook
b) Navigate to a named cell, range, or workbook element
c) Insert and remove hyperlinks

3) Format worksheets and workbooks
a) Change worksheet tab color
b) Rename a worksheet
c) Change worksheet order
d) Modify page setup
e) Insert and delete columns or rows
f) Change workbook themes
g) Adjust row height and column width
h) Insert headers and footers

4) Customize options and views for worksheets and Workbooks
a) Hide or unhide worksheets
b) Hide or unhide columns and rows
c) Customize the Quick Access Toolbar
d) Change workbook views , Change window views
e) Modify document properties
f) Change magnification by using zoom tools
g) Display formulas

5) Configure worksheets and workbooks for distribution
a) Set a print area
b) Save workbooks in alternative file formats
c) Print all or part of a workbook
d) Set print scaling
e) Display repeating row and column titles on multi page worksheets
f) Inspect a workbook for hidden properties or personal information
g) Inspect a workbook for accessibility issues
h) Inspect a workbook for compatibility issues

* Section 02: Manage Data Cells & Ranges

6) Insert data in cells and ranges
a) Replace data, Cut, copy, or paste data
b) Paste data by using special paste options
c) Fill cells by using Auto Fill
d) Insert and delete cells

7) Format cells and ranges
a) Merge cells
b) Modify cell alignment and indentation
c) Format cells by using Format Painter
d) Wrap text within cells
e) Apply number formats
f) Apply cell formats
g) Apply cell styles

8) Summarize and organize data
a) Insert Sparkline's
b) Outline data , Insert subtotals
c) Apply conditional formatting

DAY 02
* Section 03 : Create Tables

9) Create & manage Tables
a) Create an Excel table from a cell range
b) Convert a table to a cell range
c) Add or remove table rows and columns

10) Manage table styles and options
a) Apply styles to tables
b) Configure table style options
c) Insert total rows
d) Filter records
e) Sort data by multiple columns
f) Change sort order
g) Remove duplicate records

* Section 04: Perform operations with Formulas & Functions

11) Summarize data by using functions
a) Using the SUM function
b) Using MIN and MAX functions
c) Using the COUNT function
d) Using the AVERAGE function

12) Conditional operations by using functions
a) Using the IF function
b) Using the SUMIF /SUMIFS function
c) Using the AVERAGEIF / IFS function
d) Using the COUNTIF / IFS function

13) Format and modify text by using functions
a) Using RIGHT, LEFT, and MID functions
b) Using UPPER, LOWER, and PROPER functions
c) Using the CONCATENATE function

* Section 05: Create Charts & Objects

14) Create Charts
a) Create a new chart
b) Add additional data series
c) Switch between rows and columns in source data
d) Analyze data by using Quick Analysis

15) Format graphic elements
a) Resize charts
b) Add and modify chart elements
c) Apply chart layouts and styles
d) Move charts to a chart sheet

16) Insert and format objects
a) Insert text boxes and shapes
b) Insert images
c) Modify object properties
d) Add alternative text to objects for accessibility

17) Q & A’s Session
a) Question & Answer Session
b) Any other topics requested by the Participants

Related Courses

Price 6,000 Tk + VAT
Muhammad Rabiul
  • 23 May - 11 Jun 2019

The course has designed to become familiar with an ...

IT
Md. Rabiul Islam
  • 23 May - 25 Jun 2019

This Data Science course will cover the whole data life ...

IT
Samiul Huq
  • 24 - 25 May 2019 (2 Days Long)

The course will take you from an Intermediate Level to a ...

IT
Md. Rabiul Islam
  • 13 Jun - 14 Jul 2019

In this course, you will learn exciting concepts and skills ...

IT
This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers. It will give you job, make you essential at your job and bring you tremendous career success.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.