Overview
This course covers advanced Excel skills for beginners to experienced users, focusing on increasing efficiency and sharpening skills in Microsoft Excel. The course teaches users how to navigate the software, calculate data with formulas, sort and filter data, utilize Pivot Tables, work with functions like IF and Database functions, automate tasks with Macros, and more. The teaching method includes hands-on exercises and practical examples. The intended audience is everyday users looking to enhance their Excel proficiency.
Syllabus
Start
Introduction
Formatting Lists as Tables
Flash Fill
Custom Sorting
Subtotals
QA Tool
Data Charts
Sparklines
Introduction to Pivot Tables
Advanced Pivot Tables Options
Data Validation
Conditional Formats
Comments and Notes
Linking Data
Privacy and Protection
Conclusion
Taught by
Learnit Training