Dive into data analysis with Excel 2021 in this comprehensive tutorial. Learn to leverage powerful features for analyzing, summarizing, and visualizing data, including table formatting, conditional functions, charting, and pivot tables. Explore advanced tools like database functions, unique sorting, and filtering to draw meaningful insights from your datasets. Ideal for Excel users with basic knowledge seeking to enhance their data analysis skills, this hour-long tutorial covers essential techniques to transform raw data into valuable business intelligence.
Excel 2021 - Intro to Data Analysis Tutorial
Overview
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
