Description
Microsoft Excel Course: Level 2 and 3 – Intermediate & Advanced Classes
Classes are available every Monday, Wednesday and Saturdays.
2 full day classes or 4 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
Syllabus
Level 2 – 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 – 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