Skip to content

Microsoft Office Excel 2010: Advanced Online Course

To begin, participants will learn about Excel’s automatic grouping, outlining, and subtotaling features. Participants will also explore the Scenario Manager, data analysis tools, add-ins, one and two data input tables, goal seek, and Solver.

3 – 6 Hours
Advanced
For All Skill Levels
7 day money back guarantee.

Learn How To Become a Competent Everyday User of Excel

Our Microsoft Office Excel 2010: Advanced courseware includes all the information that you need on advanced data analysis and reporting tools. Learning Outcomes:
  • Section One focuses on data analysis tools, including automatic outlining, grouping, and subtotaling; the Scenario Manager; add-ins; goal seek; data tables; and Solver. It also includes a discussion on using hyperlinks in Excel.
  • Section Two focuses solely on PivotTables. Participants will move through all of the tasks associated with a PivotTable, right from creating the table, to using contextual tabs, to analyzing and managing data, to formatting the table for easy viewing. Information on classic PivotTable frames, Slicers, and PowerPivot is also included.
  • Section Three focuses on PivotCharts. Participants will build on their PivotTable knowledge to create a PivotChart, pivot data, use the contextual tabs, format it, and add slicers to it. The section will conclude with lessons on using PivotCharts in everyday contexts, like analyzing scenarios.
  • Section Four will begin by covering financial functions (PMT and FV), logical functions (IF, IFERROR, AND, OR, NOT, FALSE, and TRUE), and VLOOKUP. A discussion on custom AutoFill lists and linking, consolidating, and combining Excel data rounds out the section and wraps up the Microsoft Office Excel 2010: Advanced course.
Online Access: Study the course online with an internet connection, by any device including PC, MAC, tablet or Smart Phone. Certificate of completion: A certificate of completion will be provided, when you finish the course.

Course Features

  • Only 3 to 6 hours of study is required
  • Delivered 100% on-line 24/7
  • Study from home or at work, at your own pace, in your own time
  • Certificate of Completion

Need Help?

User Ratings

0
0.0 rating
0 out of 5 stars (based on 0 reviews)
Excellent0%
Very good0%
Average0%
Poor0%
Terrible0%

Related Courses

Course Reviews

There are no reviews yet. Be the first one to write one.

General Reviews

What other students have said about us

Vesna Kitanovska
Read More
I am going to realise that (after completing 13 Courses already) how much time I can save studying online. Is becoming a bit "addictive” but in a good way. I love it and every free time I am on to doing my exams or explore what other Courses is available out there to enroll later.
Debra Goodlander
Read More
I am an older manager and have ran into several of the examples you explained over the years with younger employees. Reading this has helped me realize where I may have gone wrong. I will be changing the way I handle all my employees. Thank you.
Philip Anthony Apps
Read More
The Courses have been very detailed and challenging. Different subjects and terminology well laid out and instructive. Key points well presented and course material written in a very informal patient way which keeps the note taking and reading interesting! overall thoroughly enjoyed this course and completing it!
Alicia L
Read More
I loved this course!! It's very informative and straight to the point. I appreciate the opportunity to be able to train for high demand jobs at a cost effective price. Thank you!!! God Bless.”
Previous
Next
0 +
different courses
0
Hours of Classes
0 +
Happy Clients

Empower Your Workplace with Over 300 of the Most Important Soft Skills

100% money back guarantee

Perfect for individuals and businesses to further their skills and Improve Culture

Log into Skill Builder Pro

Sign in to enjoy all our courses or