Get actionable insight from your data with Excel’s popular power tool.
Get more from Excel using the power of Pivot Tables
Pivot Tables are the perfect tool to analyze large amounts of data in Excel. The ability to summarize, visualize, and tabulate your data makes PivotTables an important tool for Excel users who need to store and report on data. Microsoft certified trainer Kathy Jones will show you how to create, format, and manipulate PivotTables and PivotCharts so you can easily get the results you need from your data.
Topics covered include: • Preparing data and creating Pivot Tables • Working with local and external data sources • Summarizing, organizing, filtering, and formatting Pivot Tables • Refreshing and Changing Pivot Table data • Creating Pivot Charts
Taught by Microsoft certified trainer Kathy Jones, Excel – Data Analysis with Pivot Tables will help intermediate and advanced users work more effectively with Excel Pivot Tables and Pivot Charts.
High-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Powering Productivity, One Brain at a Time!
Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject matter experts have real-world experience and create the most realistic and comprehensive training courses possible. Bigger Brains courses are built in a unique “Teacher/Learner” style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This Uniquely Engaging™ video-based format is more enjoyable and more effective than traditional eLearning formats.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
