Microsoft Excel Essentials



Our Microsoft Excel Essentials program is designed for students who wish to advance their computer skills by learning to work with Microsoft Excel. The course is aimed at those who have no or limited experience with Excel.

Course facilitators are knowledgeable in all levels of Excel and use the software on a daily basis.


What is Included?

  • Hands-on training by our patient, experienced facilitators
  • Easy to read printed courseware for future reference
  • Facilitator support for 30 days following attendance at a course
  • Option to return for refresher training (up to 6 months after course) if course is running and training places are available

What Will I Receive?

Upon successful completion of the course, participants will be issued with a Certificate of Completion.


Target Audience

For those who have limited or no experience using Excel, and wish to learn its essential functions and features.

Included Topics

Navigating Excel

  • Basic Excel concepts and uses
  • Ribbon, Status Bar and Quick Access toolbar
  • Create and Save a Workbook
  • Insert, Delete, Copy and Move Worksheets
  • Naming and colouring worksheets tabs

Editing and Formatting in Excel

  • Insert or Delete Cells/Rows/Columns
  • Use AutoComplete and AutoFill
  • Cut, Copy, and Paste text
  • Wrap, Merge and Centre Text
  • Number and text formatting and alignment
  • Borders and Shading

Basic Excel formulas

  • Use Math Operators
  • AutoSum
  • Relative and Absolute references
  • Copying formulas

Work with Rows and Columns

  • Set Row Height and Column Width
  • Hide and Unhide Rows and Columns
  • Freeze Panes

Useful Functions

  • Find and Replace Data
  • Sort Data
  • Create and Use Comments

Print Worksheets

  • Page Orientation
  • Set and Clear Print Area
  • Set Margins
  • Print Scaling
  • Headers and Footers
  • Print to PDF

Basic Charts

  • Create, Format, and Move Charts
  • Print Charts

Use Help

  • Online Help
  • Smart Lookup
  • Tell Me



The Excel Essentials program is one day in duration.

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 our computers. Please speak to our friendly staff regarding onsite delivery.


How to Enrol

For a dedicated course, contact our office. Dates will be scheduled at the time of booking.



© Total Management and Training 2018 - RTO #31178

web design by precedence