The best Microsoft Excel 2016 Course online for
R199 R99 per month!
When you subscribe you will not only get access to Microsoft Excel 2016 but you will also have access to all our Office courses including Microsoft Word 2016, Microsoft Powerpoint 2016 and Microsoft Outlook 2016, all for only R99 per month.
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
Creating Formulas and Functions
Adjusting Worksheet Layout and Data
Adjusting Worksheet Views
Multiple Worksheets and Workbooks
IF, VLOOKUP, and Power Functions
Security and Sharing
Data Management Features
Data Analysis Tools
Introduction to Macros
Pricing and Subscription Options
Companies we have trained over the years
How it works?
In this short video lesson we will demonstrate step-by-step how easy it is to start and how our online courses work. If you are not sure if this is for you please watch this lesson.
Click on the play button to start the short video tutorial.
Sometimes to best explain a feature or function we have to create a file with data presented in a specific format.
In this tutorial, we will show you how to download and use the exercise files for our online courses. Click on the play button to start.