MS EXCEL (Level 1) Beginner
Getting Started with Excel
Modifying a Worksheet
Move and Copy Data Between Cells
Fill Cells with Series of Data
Insert and Delete Cells, Columns, and Rows
Find, Replace, and Go To Cell Data
Performing Calculations
Create Basic Formulas (+ - * /)
Calculate with Functions (sum)
Copy Formulas and Functions
Create an Absolute Reference
Formatting a Worksheet
Change Font Size and Type
Add Borders and Colour to Cells
Change Column Width and Row Height
Create a Custom Number Format
Developing a Workbook
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Printing Workbook Contents
Create a Header and a Footer
Insert and Remove Page Breaks
Customizing Layout
Freeze and Unfreeze Rows and Columns
Hide and Unhide Rows and Columns
MS EXCEL (Level 2) Intermediate
Creating and Applying Templates
Create a Workbook from a Template
Creating and Modifying Charts
Create Basic Charts (column, line, bar,pie)
Working with Graphic Objects
Change the Order of Graphic Objects
Move, Copy, and Resize Graphic Objects
Sorting and Filtering Data
Create and Apply Advanced Filters
Calculate with Database Functions
Add Subtotals to a Worksheet
Using Functions
(DSum, DMin, DMax, DCount)
Creating a PivotTable
Adding Fields to the Pivot Table
Removing Fields from the Pivot Table
Working with a PivotTable
Creating Charts from a Pivot Table
Grouping results within a pivot table
Calculating within a Pivot Table
Analysing information within the pivot table
MS EXCEL (Level 3) Advance
Streamlining Workflow
Apply Conditional Formatting
Add Data Validation Criteria
Modify Excel's Default Settings
Auditing Worksheets
Locate Errors in Formulas
Locate Invalid Data and Formulas
Working with Multiple Workbooks
Create and format data across multiple workbooks
Perform calculations across multiple workbooks
Create Linked Cells in Different Worksheets
Create Linked Cells in Different Workbooks
Calculating with Advanced Formulas
Create and Apply a Name for a Range of Cells
Calculate Across Worksheets
Calculate with Date Functions(Today, Now, Day, Month, Year and working days)
Calculate with Statistical Functions (Average, Min, Max, Count)
Calculate with Lookup and Reference Functions(Hlookup, Vlookup, Transpose)
Calculate with Logical Functions (If, And, Or)