Overview
Our Microsoft Excel - Level 2 program is designed for students who wish to advance their computer skills by learning to work more in depth with Microsoft Excel.
The course is aimed at those who have basic experience with Excel.
Course facilitators are knowledgeable in all levels of Excel and use the software on a daily basis. You will receive hands-on training by our patient, experienced facilitators, and easy to ready printed courseware for future reference.
At the conclusion of the training, you will be issued with a Certificate of Completion.
Included Topics
Filling Data
- Filling series
- Custom Fill
- Flash Fill Extractions
Worksheet Techniques
- Moving, copying, renaming
- Hiding / unhiding worksheets
- Freezing / splitting worksheets
Page Setups
- Orientations / custom margins
- Print areas
Applying Borders
- Applying to cells, ranges
- Drawing, erasing, changing
Essential Functions
- IF, CHOOSE, LOOKUP
- MOD, TODAY, NOW, DATE, PMT
Complex Formulas
- Scoping, longhand, base, calculations
- Complex formulas
Defined Names
- Using, defining, applying, creating
- Using name manager
Number Formatting Techniques
- Understanding formatting
- Custom, padding, aligning
Conditional Formatting
- Formatting, clearing, redefining
- Data bars, colours, icon sets
- Sparklines
Goal Seeking
- Understanding goal seeking
- Using goal seeking
Quick Analysis Tools
- Formatting, charting, totals
- Sparklines, tables
Worksheet Tables
- Inserting, converting, removing
- Sorting, splitting, renaming, filtering
Chart Elements
- Titles, axes, labels, gridlines
- Trendlines, error bars, formatting
Chart Object Formatting
- Working with charts