Microsoft Excel

Basic Level

1
Introduction to Spreadsheets
2
Understanding Microsoft Excel
3
Excel Workbook Windows
4
Basic Spreadsheet Skills
5
Excel Help System
6
Opening and Closing Workbooks
7
Understanding Workbook File Formats
8
Creating New Workbooks
9
Selecting Cells
10
Auto Sum and Auto Fill Function
11
Cell Referencing and Request
12
Formatting Cells
13
Formatting Numbers
14
Placing Cell Alignment
15
Cell, Rows and Columns
16
Understanding Worksheets
17
Editing, Copying and Moving Cells
18
Page Layouts in Excel
19
Proofing Workbooks
20
Basic Options, Ribbons and Toolbar

Intermediate to Advance Level

1
Introduction to Excel Spreadsheet Intermediate Level
2
Defining Names in Excel
3
Sorting Data
4
Using Excel Tables
5
Filtering Data in Excel
6
Understand Charts
7
Chart Design Options and Tools
8
Chart Format Tools
9
Combo Charts
10
Functions within Excel
11
Understanding Date Function
12
Logical Functions
13
Financial Functions
14
Find and Replace
15
Headers and Footers
16
Adding Comments
17
Conditional Formatting
18
Using Text to Columns
19
The Paste Special Function
20
Data Validation
21
Subtotals and Grouping
22
Consolidating Data
23
Vlookups
24
HLookups
25
Using Statistical Functions
26
Database Functions
27
Hyperlinks in Excel
28
Linking Data
29
Understanding Pivot Tables
30
Using Pivot Charts
31
Workbook Properties
32
Protecting and Sharing Worksheets
33
Custom Number Formats in Excel

Be the first to add a review.

Please, login to leave a review
Microsoft Excel Course training in fremont CA
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV

Working hours

Monday9:30 am - 6.00 pm
Tuesday9:30 am - 6.00 pm
Wednesday9:30 am - 6.00 pm
Thursday9:30 am - 6.00 pm
Friday9:30 am - 5.00 pm
SaturdayClosed
SundayClosed

Pin It on Pinterest