Download a sample of this course for FREE
- No obligation
- No hassle
Microsoft Office Excel 2010: Advanced
Our Microsoft Office Excel 2010 Advanced courseware includes all the information that you need on advanced data analysis and reporting tools.
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.
Try Microsoft Office Excel 2010: Advanced Courseware for FreeSee how you can save time & money with pre-written, customizable courses.
For every hour of training delivery it takes 40 hours of prep work to have quality training materials. A two-day training class of 7.5 hours per day can easily take 600 hours of work. Velsoft courseware means this work is done for you and delivered in MS Word format files so that you can make any changes you like; right down to taking our logo off and replacing it with yours. Velsoft courseware gives you the confidence of walking into your training session knowing you are prepared to give a great class.
With Velsoft courseware you receive:
If you are interested in any of our eLearning titles, we can provide you with access to a free demo. Our web-based SoftSkills courses are effective and affordable; allowing business professionals to learn interesting and practical information related to their jobs. Trying out this interactive and customizable eLearning course will demonstrate to you the quality of our product, and the advantages it will bring to your organizational training goals.Try for Free
Microsoft Office Excel 2010: AdvancedEasily load this course into your LMS. Download Test File