Excel 2021 Intro to Data Analysis Tutorial
Excel 2021 Intro to Data Analysis Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u
Exercise Files: https://www.learnitanytime.com..../p/exercise-files-ex
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/privat....e-group-classes-work
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.
