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.
Learn How To Become a Competent Everyday User of ExcelOur 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.
There are no reviews yet. Be the first one to write one.
What other students have said about us
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