Mastering Excel 2019 - Intermediate

Unlock the Power of Excel: Data Organization & Analysis

Become proficient in using Excel, the world’s most popular software for organizing and analyzing data. Mastering Excel equips you with one of the most practical and valuable skillsets in modern business. With advanced Excel skills, you can work wonders – from organizing lists and creating insightful reports to answering critical business questions like ROI, budget allocation, and expense tracking.

This course builds upon your existing Excel knowledge, teaching you how to efficiently manage data using charts and tables. Discover powerful reporting tools such as Pivot Tables, Pivot Charts, Slicers, and Timelines to gain deeper insights from your data.

This is our most requested training course! Whether you're dealing with small or large datasets, learning to use Excel effectively will transform how you manage information.

Led by Microsoft Certified Trainer Kathy Jones, this course takes your spreadsheets to the next level. You'll explore advanced topics to become more efficient in analyzing your data.

Topics Covered:

• Working with Named Ranges: Learn to define and utilize named ranges for easier data management.
• Inserting Functions: Master essential Excel functions to perform calculations and data manipulation.
• Advanced Sorting & Filtering Techniques: Refine your data analysis with sophisticated sorting and filtering methods.
• Inserting Tables: Organize data effectively using Excel Tables for enhanced functionality.
• Advanced Conditional Formatting: Highlight key data points and trends with advanced conditional formatting.
• Inserting Charts & Graphics: Create compelling visuals to communicate your data insights.
• Advanced Charting Tools: Explore a wider range of charting options for impactful data representation.
• Working with Pivot Tables, Pivot Charts, Slicers, and Timelines: Unlock the full potential of these powerful data analysis tools.

Enjoy over five hours of high-quality HD content in our "Uniquely Engaging"™ Bigger Brains Teacher-Learner style! Boost your data analysis skills and become an Excel expert.