Course details
Introduction
This advanced level is intended to help regular users of Excel become even more proficient by expanding their knowledge of Excel's data analysis tools, consolidation tools, advanced functions, and PivotTables. This course will cover a variety of organizing tools and What-If analysis tools that will help Excel users get the most out of their data. In addition, two key advanced spreadsheet tools (PivotTables and PivotCharts) will be discussed at length. Following that, advanced concepts dealing with Excel functions, AutoFill lists, and consolidating and combining data will also be covered. The new Slicer features and PowerPivot addon, two important tools for working with PivotTables and PivotCharts, are covered as well.
Course Content
- Section 1: Getting the Most from Your Data
- Section 2: Pivoting Data
- Section 3: Charting Pivoted Data
- Section 4: Advanced Excel Tasks
- Section 5: Macros, Visual Basic, and Excel Programming
Course Location
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Office Excel 2016 One EducationZAR 414
ZAR 6,234Duration: Upto 17 Hours - Excel Spreadsheet Diploma The Teachers TrainingZAR 230Duration: Upto 2 Hours
