Microsoft Excel - Level 2



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


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

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 delivery.



© Total Management and Training 2024 - RTO #31178

web design by precedence