Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organised with checklists. This course is advanced level, so will be helpful for those who have some experience of Microsoft Excel.
Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.
If you pass the exam successfully then you will be awarded a Advanced Microsoft Excel 2016 Training Certificate.
Learners who successfully complete the course will be awarded a Certificate in Microsoft Excel 2016 Advanced Training by CPD and iAP.
Learners who successfully complete the course will be awarded a Certificate in Microsoft Excel 2016 Advanced Training by CPD and iAP.
Microsoft Excel 2016 - Beginner | |||
Getting Started with Microsoft Excel | |||
Data Entering | |||
Creating Formulas and Functions | |||
Formatting | |||
Worksheet Views, Multiple Worksheets and Workbooks | |||
IF, VLOOKUP, and Power Functions, Security & Sharing | |||
Data Management, Data Analysis Tools | |||
PivotTables & Macros | |||
Exercise Files: Microsoft Excel 2016 | |||
Microsoft Excel 2016 - Advance Formulas & Functions | |||
Introduction to Excel 2016 Advance Formula and Functions | |||
Values and Formulas | |||
Operations in Formulas | |||
IF, AND, OR and NOT Functions | |||
VLOOKUP and HLOOKUP | |||
Tabulating Data and Multiple Criteria | |||
Median, Mode and Ranking Data | |||
Date, Time and Functions | |||
Array Formulas and Frequency Functions | |||
OFFSET and INDIRECT Function | |||
Different TEXT & Information Functions | |||
Exercise Files | |||
Microsoft Excel 2016 - Advance Formating and Techniques | |||
Introduction to Excel Advance Formatting & Techniques | |||
Adjust Fonts, Font Sizes & Font Colours | |||
Adjust Cells and Tools | |||
Work with Formulas & Tables | |||
Adjust Row, Columns and Sheets | |||
Different Formatting Styles and Set up Data for Outlines | |||
Formatting Picture Styles | |||
Formatting Techniques – Restore Missing Data in a Column | |||
Exercise Files | |||
Mock Exam | |||
Mock Exam: Advanced Microsoft Excel 2016 Training – Online | |||
Final Exam | |||
Exam: Advanced Microsoft Excel 2016 Training – Online |