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 gives information on the advanced functions of Excel, so if you have experience with Excel, you can build expert knowledge.
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 2013 Training Certificate.
1: Apply Conditional Formatting | |||
Apply Conditional Formatting | |||
2: Trace Cells | |||
Trace Cells | |||
3: Troubleshoot Invalid Data and Formula Errors | |||
Troubleshoot Invalid Data and Formula Errors | |||
4: Watch and Evaluate Formulas | |||
Watch and Evaluate Formulas | |||
5: Create a Data List Outline | |||
Create a Data List Outline | |||
6: Create Sparklines and Scenarios | |||
Create Sparklines and Scenarios | |||
7: Perform a Statistical Analysis with the Analysis ToolPak | |||
Perform a Statistical Analysis with the Analysis ToolPak | |||
8: Create Interactive Data with Power View | |||
Create Interactive Data with Power View | |||
9: Consolidate Data | |||
Consolidate Data | |||
10: Link Cells in Different Workbooks | |||
Link Cells in Different Workbooks | |||
11: erge Workbooks | |||
erge Workbooks | |||
12: Export and Import Excel Data | |||
Export and Import Excel Data | |||
13: Integrate Excel Data with the Web | |||
Integrate Excel Data with the Web | |||
14: Create a Web Query | |||
Create a Web Query | |||
Mock Exam | |||
Mock Exam: Microsoft Excel 2013 – Advanced | |||
Final Exam | |||
Exam: Microsoft Excel 2013 – Advanced |
Good Learning Experience
I have thoroughly enjoyed this course. The content of the course was very interesting and informative. Overall, it was a good learning experience.
excellent course
I really liked the topics and the way they were presented.
Perhaps, I would have not included the conditional formatting that is an intermediate feature and included some pivot tables and pivot charts.