The Advanced Microsoft Excel 2013 training is a one-day class that is designed for students to equip themselves with the necessary skill-set of using pivot tables, auditing and analyzing worksheet data, utilizing data tools, collaborating with others, and creating and managing macros.
Completion of the course equips the participants with the following skill set:
Module 1: Using Pivot Tables
In this module, participants learn how to work with pivot tables.
Lessons
Module 2: Audit Worksheets
In this module, participants learn how to audit worksheets.
Lessons
Module 3: Data Tools
In this module, participants learn about Data Tools in Microsoft Excel that are simple tools which make it easy to manipulate data.
Lessons
Module 4: Work with Others
In this module, participants learn how to use features that are useful when sharing and working with others.
Lessons
Module 5: Record and Use Macros
In this module, participants explore that while working with Excel, one may find certain operations being repeated frequently.
Lessons
Module 6: Random Useful Items
In this module, participants learn how to use some useful tricks and tools in Excel.
Lessons
Module 7: Microsoft Excel 2013 New Features
In this module, participants learn how to use some new features to help you efficiently and effectively create and edit workbooks.
Lessons
This course is beneficial for students who intermediate level of skills with Microsoft Excel 2013 or more experienced Excel users who are interested in learning advanced-level skills covered in this course on the 2013 interface.
Before attending this course, a candidate must have/be:
Name | Code | Fee |
---|
OR