Training

Key areas covered on the course include:

• Understanding the MS Excel environment
• Formatting basics
  • Formatting, Borders
  • Alignment Tools
  • Format Painter
  • Number Formats
  • Styles and Themes
  • Styles and Themes
• Keyboard Shortcuts, Terminology, and Ninja Tips
• Performing calculations
  • SUM and AUTOSUM
  • AVERAGE, MIN and MAX
  • Absolute Cell References
  • Calculations across sheets
• Working with Data
  • Managing Rows and Columns
  • Find and Replace
  • Filtering & Sorting

Prerequisites

There are no formal prerequisites, but you should have some familiarity with computers and Windows 10. 

What is Microsoft Excel?

Microsoft Excel is a spreadsheet program originally developed by Microsoft in the late 1980s. The industry standard spreadsheet for businesses all over the world, Excel allows the collection, processing and manipulation of data in a tabular format. Excel forms part of the Microsoft Office suite of software.

What’s included in this course?

1 days’ worth of Instructor-led, practical and interactive training, a course pack including all presentation slides, and a certificate.

Learners taking this course are:

• Customer Care Reps
• Accountants
• Operations Analysts
• Financial Analysts
• Executive Assistants

What key skills will I gain in this course?

• Graphs
• Chart
• Sorting
• Microsoft Excel

 Do you offer In-house corporate training?

We offer corporate trainings for a minimum number of 6 participant at your preferred venue.