• No products in the cart.

Microsoft Office 2013 Excel Advanced - Complete Video Course

4.6( 7 REVIEWS )


This Microsoft Office 2013 Excel Advanced – Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze, and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course.

Benefits you will get?

  • Affordable, engaging & premium-quality e-learning study materials
  • Assessment through Tests and Quizzes and instant result
  • Internationally recognized accredited qualification
  • Access to course content on mobile, tablet or desktop from anywhere anytime
  • Personalized learning – Learn at your own pace, time and place
  • A vast array of fascinating subjects
  • Regularly updated contents
  • Dedicated support team working 24/7


  • Anyone with any academic background can enroll into this course.
  • A device with an active internet connection


We assess our learners through quizzes or multiple choice test. This test will be assessed automatically and immediately to give you an instant result.


The PDF copy of Certificate of Completion can be claimed at the free of cost. If you need a hardcopy of this certificate, you have to pay an additional payment. The time for PDF certificate turnaround is 24 hours, and for the hardcopy, it is 3-7 working days.

Course Curriculum

Automating Worksheet Functionality
Update Workbook Properties FREE 00:07:00
Create and Edit a Macro 00:15:00
Apply Conditional Formatting 00:09:00
Add Data Validation Criteria 00:10:00
Auditing Worksheets
Trace Cells 00:05:00
Troubleshoot Invalid Data and Formula Errors 00:12:00
Watch and Evaluate Formulas 00:10:00
Create a Data List Outline 00:09:00
Analyzing and Presenting Data
Create Sparklines 00:13:00
Create Scenarios 00:12:00
Perform a What If Analysis 00:19:00
Perform a Statistical Analysis with the Analysis ToolPak 00:06:00
Create Interactive Data with Power View 00:10:00
Working With Multiple Workbooks
Consolidate Data 00:10:00
Link Cells in Different Workbooks 00:10:00
Merge Workbooks 00:08:00
Exporting Excel Data
Export Excel Data 00:06:00
Import a Delimited Text File 00:09:00
Integrate Excel Data with the Web 00:11:00
Create a Web Query 00:08:00
Mock Exam
Mock Exam- Microsoft Office 2013 Excel Advanced – Complete Video Course 00:20:00
Final Exam
Final Exam- Microsoft Office 2013 Excel Advanced – Complete Video Course 00:20:00

Course Reviews


7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.




    30 DAYS MONEY BACK Guarantee

    Buy For Your team

    Get your team access to john’s top 1540+ courses anytime anywhere

    try john academy for business

    Our Course Awarding Bodies




    Have you any inquiry?

    • By submitting your information, you agree to the terms and conditions stated in our Privacy Policy

    © 2021 John Academy All Rights Reserved.