Overview
This course on Excel 2021 Intro to Data Analysis Tutorial aims to teach Excel users how to analyze, summarize, and visualize data using tools like table formatting, conditional functions, charting, pivot tables, and more. The course covers skills such as working with tables, conditional formatting, using the IF function, database functions, sorting and filtering data, creating charts and sparklines, and working with pivot tables. The teaching method includes a full-length introductory video tutorial. The course is intended for Excel users who have a basic knowledge of Excel and want to enhance their data analysis skills.
Syllabus
Start
Introduction
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