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 read 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
Make It Happen
Check our Training Calendar for scheduled course dates. Click 'Enrol Now' to download an enrolment form, fill in and email through to to book your place on the course.
Dedicated corporate classes may be scheduled, and these may be delivered onsite depending on availability of computers at the client’s premises, or in our training rooms using the laptops available at TMT. Please speak to our friendly staff regarding onsite dedicated delivery.