Description
Microsoft Excel Course: Level 1, 2 and 3 – Introduction, Intermediate & Advanced Classes
Classes are available every Monday, Wednesday and Saturdays.
3 full day classes or 6 half days
Class Times: 9:00 am to 5:30 pm -or- 9:00 am to 1 pm -or- 1:30 pm to 5:30 pm
Break: 11:50 am for 20 minutes
Lunch: 1:00 pm to 1:30 pm
Break: 3:30 pm to 20 minutes
Topics Covered
Level 1 – Microsoft Excel Introduction
Creating Worksheets
Moving Around in a Worksheet using shortcut keys
Aligning Data in the Worksheet
Erase Part of Worksheet
Entering Formulas in the Cells
Addition, Subtraction, Multiplication And Division
Automatic Summation
Center Across Many Columns
Borders And Shading
Gridlines
Making Changes In The Worksheet
Changing Column Width
Inserting & Deleting Rows & Columns
Moving & Copying Ranges
Copying Formulas
Formatting numbers for commas, dollar sign, decimal places, etc.
Fonts
Headers and Footers
Freezing And Un-Freezing Headings
Margins
Landscape and Portrait
Multiple Worksheets
Level 2 – Microsoft Excel Intermediate
Naming Worksheets
Linking Worksheet Data
Creating Different Types of Charts, Column, Line, Pie and so on.
Labeling Charts, Adding Legends
Formatting Charts
Adding Arrows and Text to a Chart
Embedding a Chart in A Worksheet
Creating and Using Templates
Creating a Database
Sorting and Alphabetizing
Searching a Database
Automatic Record Numbering
Finding Records in a Database
Hiding and Un-Hiding Columns
Create and Run Macros
Edit Macros
Create and Apply Filters
Level 3 – Microsoft Excel Advanced
Transpose
Autoformat, Page Break
Add and Edit Comments
Loan Payment Function
If Statement
Defined Names, Circular Reference
Average function
Absolute Cell Addresses
Password Protect Files
Symbols
Create, Edit, Apply Style
Pivot Tables
Index, Match, Sumproduct Functions
Vlookup and Lookup
Protecting Cell Data
Dropdown Menu