Excel 2021 Intro to Data Analysis Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Exercise Files: https://www.learnitanytime.com/p/exercise-files-excel-2021-intro-to-data-analysis-tutorial

Who it's for: Excel users needing to analyze, summarize, and visualize their data. Basic knowledge of Excel (familiarity with formulas, cell referencing, simple functions like SUM and AVERAGE) is recommended.

What it is: Microsoft Excel is the perfect program for viewing and analyzing data.

What you'll learn: Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result. In this full-length introductory course, learn all about data analytics in Excel with tools like table formatting, conditional functions, charting, pivot tables, and much more.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Introduction 0:03
Working with Tables 3:51
Conditional Formats 15:46
Using the IF Function 24:33
Database Functions 30:41
Unique, Sort, and Filter Functions 35:27
Charts and Sparklines 38:35
Working with Pivot Tables 47:17
Conclusion 57:50

#excel #exceltutorial #exceltips #dataanalysis #dataanalytics #pivottable

(C) 2022 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.