Overview
Dive into data analysis with Excel 2021 in this comprehensive 58-minute tutorial. Learn to transform raw data into meaningful insights using powerful Excel features. Master table formatting, conditional functions, charting, and pivot tables. Explore advanced techniques like database functions, unique sorting, and filtering. Ideal for Excel users with basic knowledge seeking to enhance their data analysis skills. Gain hands-on experience with provided exercise files and discover how to effectively summarize, visualize, and draw conclusions from your data.
Syllabus
Start
Working with Tables
Conditional Formats
Using the IF Function
Database Functions
Unique, Sort, and Filter Functions
Charts and Sparklines
Working with Pivot Tables
Conclusion
Taught by
Learnit Training