Course details
One of the most powerful tools that Excel 2013 provides is the collection of PivotTables, PivotCharts, and PowerPivot. These tools allow you to dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In addition to these benefits, PowerPivot has the ability to handle huge amounts of… + Read More
Course details
One of the most powerful tools that Excel 2013 provides is the collection of PivotTables, PivotCharts, and PowerPivot. These tools allow you to dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In addition to these benefits, PowerPivot has the ability to handle huge amounts of data, quickly and easily. The course also shows how to create advanced chart elements, such as trend lines and dual axis. This course will help prepare learners for the Microsoft Certification Exam 77-421: Excel 2013 Expert which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.
- create a PivotTable in Excel 2013
- edit a PivotTable in Excel 2013
- decide how to create a PivotTable in Excel 2013
- create a PivotChart in Excel 2013
- decide how to create a PivotChart in Excel 2013
- use PowerPivot to create a PivotTable in Excel 2013
- decide how to use PowerPivot in Excel 2013
- use advanced chart features in Excel 2013
- choose advanced elements to apply to charts in Excel 2013
Updated on 13 November, 2015 - Read LessAbout New Horizons Jordan
As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. For 30 years, New Horizons has provided more than 30 million students with industry-leading technical training that delivers the most relevant and intuitive computer ctheirses and certifications. they’re now the world’s largest independent IT training company, and they continue to lead:
- 300 computer training centers in 70 countries (and counting)
- Largest Guaranteed-to-Run ctheirse schedule in the world
- Ranked in the top 5% of the industry for training quality and customer satisfaction
- Official training partner for technology leaders such as Microsoft, Cisco, CompTIA and VMware
- Microsoft’s largest training provider, delivering more than 40% of all authorized Microsoft training worldwide
- World’s largest Cisco-authorized training partner
See all New Horizons Jordan courses