Microsoft Excel Training Courses

Apply now for our Microsoft Excel Course

Get started with Excel
Insert lesson titles in a bulleted list.
Features New in Excel
Advanced Formulas
Visualizing Your Data

Enroll Now for a Microsoft Excel Course

Course Details

Instructor Led Learning

Duration: 3 Days

Registration Open Now!

Online Learning

Duration: 365 Days

Registration Open Now!

Earning as much as : R158 000 p.a

Microsoft Excel Course overview

Part 1:
In this Introduction to Microsoft Excel training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets.

Part 2:
This Intermediate Microsoft Excel training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles

Part 3:
This Advanced Microsoft Excel training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Is this course for you?

Microsoft Excel is the standard spreadsheet application for both business and personal use. Microsoft Excel features graphing tools, calculations, pivot tables and more. Whether you’re new or already an advanced user, MasterGrade IT’s Excel courses for Microsoft Excel will teach you all you need to know – from basic to advanced features – to become an excel power user.

From formatting to design, this short Excel training course will allow you to create a range of documents for use in both the business and personal realm.

Available Microsoft Excel Exams and Certification Paths

Start off with Microsoft Excel exams:

Other Microsoft Office Course:

Job Opportunities

Job Title:Office Administrator

Responsibilities: 
The Microsoft Excel will you build a spreedsheets that helps your business. You will be responsible for the working on spreedsheets for business equipment, such as status and business maintains. Responsibility for staff login.

3 Steps to Master Microsoft Excel

Step 1

Take A Course

Step 2

Write An Exam

Step 3

Get Certified
Start your Microsoft Excel Course

What you will learn

Microsoft Excel Training Course

Lesson 1:Microsoft Excel Part 1:

Lesson 2:Microsoft Excel Part 2:

Lesson 3:Microsoft Excel Part 3:

Full course outline

Microsoft Excel Part 1 (Basic)

Lesson 1: Creating a Microsoft Excel Workbook

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Use Excel Help

Lesson 2: The Ribbon

  • The Ribbon
  • Tabs
  • Groups
  • Commands

Lesson 3: The Backstage View (The File Menu)

  • Introduction to the Backstage View
  • Opening a Document
  • New Documents and Word Templates
  • Configuring Documents to Print
  • Adding Values to Document Properties
  • Working with Autosaved Versions of Documents

Lesson 4: The Quick Access Toolbar

  • Adding Common Commands
  • Adding Additional Commands wtih the Customize Dialog Box
  • Adding Ribbon Commands and Groups

Lesson 5: Entering Data in Microsoft Excel Worksheets

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Define the Page Layout
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle

Lesson 6: Formatting Microsoft Excel Worksheets

  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group

Lesson 7: Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas
  • Using Date Functions
  • Using the NOW and TODAY Functions

Lesson 8: Working with Rows and Columns

  • Insert lesson titles in a bulleted list
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes

Lesson 9: Editing Worksheets

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments

Lesson 10: Finalizing Microsoft Excel Worksheets

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers

Lesson 11: Microsoft Excel Features that Were New in 2013

  • One Workbook Per Window Feature
  • Using Flash Fill

Lesson 12: Features New in

  • Tell Me
  • Smart Lookup

Microsoft Excel Part 2 (Intermediate)

Lesson 1: Advanced Formulas

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming Multiple Single Cells Quickly
  • Using Formulas That Span Multiple Worksheets
  • Using the IF Function
  • Using AND/OR Functions
  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions
  • Using the PMT Function
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCATENATE Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • The UPPER Function
  • The LOWER function
  • The TRIM Function
  • Using the LEFT, RIGHT, and MID Functions
  • The MID Function

Lesson 2: Working with Lists

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List

Lesson 3: Working with Illustrations

  • Using Shapes
  • Working with SmartArt

Lesson 4: Visualizing Your Data

  • Creating a Custom Chart Template
  • Inserting Charts
  • Add and Format Objects
  • Insert a Text Box
  • Create a Custom Chart Template
  • Create a Trend Line

Lesson 5: Working with Tables

  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Define Titles

Lesson 6: Advanced Formatting

  • Applying Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

Lesson 7: Microsoft Excel Features that Were New in 2013

  • New Functions in Excel 2013
  • Using New Chart Tools
  • Using the Quick Analysis Tool
  • Using the Chart Recommendation Feature

Lesson 8: Features New in Excel

  • New Charts
  • Treemap
  • Sunburst
  • Histogram
  • Waterfall
  • Box and Whisker
  • Pareto

Microsoft Excel Part 3 (Advanced)

Lesson 1: Using Pivot Tables

  • Creating Pivot Tables
  • Inserting Slicers
  • Working with Pivot Tables
  • Inserting Pivot Charts
  • More Pivot Table Functionality

Lesson 2: Auditing Worksheets

  • Tracing Precedents
  • Tracing Dependents
  • Showing Formulas

Lesson 3: Data Tools

  • Converting Text to Columns
  • Linking to External Data
  • Controlling Calculation Options
  • Data Validation
  • Consolidating Data
  • Goal Seek

Lesson 4: Working with Others

  • Protecting Worksheets and Workbooks
  • Tracking Changes
  • Marking a Workbook as Final

Lesson 5: Recording and Using Macros

  • Recording Macros
  • Running Macros
  • Editing Macros
  • Adding Macros to the Quick Access Toolbar

Lesson 6: Random Useful Items

  • Sparkline
  • Preparing a Workbook for Internationalization and Accessibility
  • Importing and Exporting Files
  • Merge Workbooks
  • Using the PMT Function
  • Creating Scenarios
  • Utilize the Watch Window
  • Consolidate Data
  • Enable Iterative Calculations
  • What-If Analyses
  • Use the Scenario Manager
  • Use Financial Functions

Lesson 7: Microsoft Excel Features that Were New in 2013

  • Using Slicers to Filter Data
  • Creating a PivotTable Timeline
  • Creating a Standalone PivotChart
  • Workspaces in Excel 2013

Lesson 8: Features New in Excel

  • PivotTable Updates
  • Ink Equations
  • Multi-Select Option in Slicers
  • Quick Shape Formatting
  • Sharing with SharePoint or OneDrive
Interested? Register here

Contact Us

Please fill in the form below

We can also assist you in French

Get in touch

Call us on 087 726 8817 (Mon-Fri 08:00am to 17:00pm) or complete the contact form:



It does not matter where you are located MasterGrade IT has the perfect solution for you.

Cape Town Address:
2nd Floor
Boland Bank Building
18 Lower-Burg Street
Cape Town, 8001
Johannesburg Address:
18 Davies Road
Bryanston Sandton
2191

Phone: +27 21 4193213

Email: solutions@mastergradeit.co.za

Official Website: www.mastergradeit.co.za