Excel Intermediate

Unlock the power of Excel with our comprehensive Excel Intermediate course.

What you'll learn
Become Familiar with 3D References and Linking and how to use these.
A more in-depth look at Sorting and Filtering in different scenarios, as well as issues associated with these.
A comprehensive guide to Sparklines and Tables & Fixing incorrect / missing data.
Import and Organise your data for optimised space and performance.
How and when to use Conditional Formatting and Charts

Requirements
Microsoft 365 license will be required to download and use Excel for Mac or Windows.

Description
Excel Intermediate: Advanced Data Management & AnalysisTake your Excel skills to the next level with this comprehensive intermediate course, designed for users who have mastered the basics and are ready to unlock Excel's more powerful features. This regularly updated 3-hour course empowers you to handle complex data management tasks with confidence.Dive deep into advanced referencing techniques, including 3D references and workbook linking, enabling you to connect and analyze data across multiple worksheets and files effortlessly. Master sophisticated sorting and filtering methods, including multi-criteria filtering, color-based sorting, and the powerful capabilities of slicers for dynamic data visualization.Learn to enhance your dashboards with sparklines for quick trend analysis, and develop skills to clean and validate data effectively. The course covers essential data import techniques, including web queries, teaching you to gather and organize information from various sources seamlessly.Transform your spreadsheets with advanced conditional formatting rules and create professional-grade charts that bring your data to life. Each topic builds upon previous knowledge, incorporating real-world scenarios and practical exercises that reinforce learning.With new content added regularly, you'll stay current with Excel's evolving capabilities. This course bridges the gap between basic Excel usage and advanced data analysis, making you a more efficient and capable Excel user.Prerequisites: Basic Excel knowledge including familiarity with formulas, basic charts, and fundamental worksheet operations.

Who this course is for
Beginner Excel users looking to expand their skills and learn the capabilities of Excel.