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. By the end of the course, learners will be able to draw insights from data beyond simple averages and totals, utilizing various Excel features for data analytics. The intended audience for this course includes Excel users with basic knowledge of Excel and familiarity with formulas, cell referencing, and simple functions like SUM and AVERAGE. The teaching method involves a full-length introductory video tutorial covering different topics related to data analysis in Excel.
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