Microsoft Excel Course

Step-by-Step Video Lessons from R99 per month

Join Now!


Microsoft Excel 2016 Online Course

Hi, my name is Frans and I am your Regional Account Manager for ATTI Online Learning in South Africa. My role is to look at simple, and effective ways to develop your Excel skills using our step-by-step online video tutorials.

If you are worried that you might be to old to learn about computers or fear that you might not be able to do this, then I want to reassure you that if you are serious about this we are commited to helping you learn.

We have trained thousands of people from all walks of life, every sector, every industry and every age group. We are very passionate about training and to me it is extremely satisfying to help a person grow and see them master a computer course like Microsoft Office.

Online courses require a much more self-motivated learning style than traditional classes and for some the first online learning experience can be a little intimidating, but once you get the hang of it, I promise you, you will do fine.

In this online course with the help of our video tutorials you will learn everything you need to know to be proficient in Microsoft Excel 2016.

Microsoft Excel is a spreadsheet application, which allows users to store, edit and manipulate data within a group of table-like structures known as a workbook. Since Microsoft Excel 2007 we have noticed a huge change in the interface with lots of added features with added productivity.

From Microsoft Excel 2010 to Microsoft Excel 2013 we have noticed nothing major in terms of the interface. Just a few new features and minor adjustments.

Microsoft Excel consists of basically a workbook that uses a collection of worksheets to organize data within a system or rows and columns split into cells. Users can enter data or numbers into these cells to create easy ways to calculate simple or complex formulas. Users can insert objects such as charts and graphs into their workbook to graphically represent their entered data in many unique ways.

With new chart types and improvements to PivotTables and business intelligence, Microsoft Excel 2016 makes it easier to work with large amounts of data and give it even more meaning. Unlock insights, and tell the story in your data by organizing it in spreadsheets (workbooks). View your data in context, and use the analytic capabilities of Microsoft Excel to make more informed decisions.


Microsoft Excel Target Audience:

This course is intended for delegates who want to learn the fundamental skills of working with Microsoft Excel 2016, such as creating, editing, and formatting documents, inserting and formatting tables and creating charts, creating formulas and functions and employing a variety of techniques for improving the appearance and accuracy of an Excel spreadsheet.

The course then moves on to cover some of the more advanced excel features such as IF, VLOOKUP, Power Function, Pivot Tables, Data Management and Analysis Tools as well as macros.

On successful completion of the course learners will receive an attendance certificate as well as a transcript on what was covered.

Learners can also assess their excel skills with the Microsoft Office Specialist Certification at approved Certiport Testing Centres all over the country. The Microsoft Office Specialist Certification is optional and the fees for the excel certification might differ between the testing centers.


Microsoft Excel Training Methodology

This excel online course is modular and each module consists of short video tutorials between 3 and 10 minutes long. In certain cases, some excel videos might exceed 10 minutes due to the nature of the lesson.

The facilitator will demonstrate on their screen step by step a feature or function during each excel tutorial and if necessary, have created sample exercise files that you can download, so that you can follow along and see if you can apply and understand what was covered in the video lesson.


Microsoft Excel Course Content

Getting Started with Excel

  • Introduction to Excel
  • Exploring the Ribbon and the backstage view
  • Add, remove and Customize the quick access toolbar
  • Exploring the spreadsheet layout
  • Explore and understand the formula bar
  • Explore and customize the status bar
  • Switch between worksheets and workbooks
  • Customize the mini toolbar using the right click menu
  • Creating new workbooks and using document templates
  • Smart Lookup, help and the Tell Me Assistant
  • Entering Data
  • Insert data and resize columns
  • Different ways of quickly inserting data by using Autofill
  • Working with dates and times
  • Step forward and back using the undo and redo function
  • Add and remove comments
  • Save and understand the different ways to save a spreadsheet

Creating Formulas and Functions

  • Working with different types of formulas
  • Copying and reusing a formula to save time
  • Calculating year-to-date totals and adding them to charts
  • Calculate percentage and understand Excel logic when it comes to formulas
  • Working with relative, absolute, and mixed references
  • Looking at different ways the AutoSum function can be used
  • Using other popular functions

Formatting

  • Format text and change fonts
  • Adjusting row heights and column widths
  • Aligning, wrapping, text angles and Merging cells
  • Add and customize borders
  • Explore different format options using numbers, dates and time
  • Using conditional formatting
  • Add rows and columns, using functions and changing table formatting
  • Using Shapes, Images and SmartArt

Adjusting Worksheet Layout and Data

  • Insert and remove columns or rows
  • Hide or unhide columns or rows
  • Moving, copying, and inserting data
  • Find and replace text or formatted data

Printing

  • Exploring the Page Layout tab and Page Layout view
  • Page break preview and printer settings
  • Working with Page Setup and printing controls

Charts

  • Inserting a chart using existing data
  • Creating different chart types
  • Changing the design and styles of charts
  • Format the layout, design and work with chart elements
  • Explore different types of charts

Adjusting Worksheet Views

  • Freeze, unfreeze a column or row
  • Splitting screens horizontally and vertically
  • Collapsing and expanding data views with outlining

Multiple Worksheets and Workbooks

  • Displaying multiple worksheets and workbooks
  • Renaming, inserting, and deleting sheets
  • Moving, copying, and grouping sheets
  • Using formulas between worksheets and workbooks
  • Formula notifications and locations

IF, VLOOKUP, and Power Functions

  • Using IF functions and relational operators
  • Getting approximate table data with the VLOOKUP function
  • Getting exact table data with the VLOOKUP function
  • Using the COUNTIF family of functions

Security and Sharing

  • Unlocking cells and protecting worksheets
  • Protecting workbooks
  • Assigning passwords to workbooks
  • Privileges and sharing options
  • Setting up and working with changes

Data Management Features

  • Sorting data in a column
  • Inserting subtotals in a sorted list
  • Adding filters to columns
  • Splitting data into multiple columns
  • Using Flash Fill to automatically fill cells
  • Removing duplicates from a worksheet
  • Using validation tools

Data Analysis Tools

  • Using Goal Seek to calculate changes needed
  • Using the solver to calculate values needed
  • Add and view scenarios
  • Create and edit a data table

Pivot Tables

  • Create and edit a Pivot Table
  • Customize a Pivot Table
  • Grouping dates in a Pivot Table
    Grouping by other factors
  • Using slicers to clarify and manipulate fields
  • Create and edit a Pivot Charts

Introduction to Macros

  • When can we use a macro?
  • Creating and assign a macro
  • Run and access macros

Pricing and Subscription Options

Pay as you go: Access to all our courses for R199 R99 per month!

The #1 Selling option for our eLearning Portal.
*50% off Special Promotion!

6 Months: Access to all our courses for R999 R499 once-off!

Save R95 when you pay 6 months upfront.
*50% off Special Promotion!

12 Months: Access to all our courses for R1999 R999 once-off!

Save R189 when you pay 12 months upfront.
*50% off Special Promotion!



Companies we have trained over the years