Excel 2019 Intro to Data Analysis Tutorial
Vložit
- čas přidán 5. 08. 2024
- Excel 2019 Intro to Data Analysis Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/34Q5s3D
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:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Preparing Data for Tables 1:22
Removing Blank Rows and Duplicates 3:35
Using Flash Fill to Apply Table Styles 7:52
Applying Table Styles 10:40
Auto Sorting and Filtering in Tables 13:55
Applying a Custom AutoFilter in Excel Tables 18:08
Adjusting Table Style Formats and Options 21:36
Applying Total Rows 24:13
Adding New Data and Turning Off Table Styles 27:04
Applying Conditional Formats 29:53
Editing and Turning Off Conditional Formats 33:38
IF Functions 36:01
SUMIF Functions 40:47
COUNTIF Functions 44:54
AVERAGEIF Functions 48:27
Creating Charts 51:58
Editing and Reformatting Charts 55:54
Creating Sparklines 1:00:20
Creating Win-Loss Sparklines 1:03:25
Creating Pivot Tables Using the Recommended Pivot Tables Button 1:05:19
Creating Pivot Tables from Scratch 1:08:25
Editing Summary Function and Format of Pivot Table Value Fields 1:11:53
Filtering, Sorting, and Editing Pivot Table Fields 1:15:02
Grouping Column Labels in Pivot Tables 1:19:17
Creating Slicers 1:22:09
Refreshing Pivot Table Data 1:24:45
Creating and Updating Pivot Charts 1:26:29
Conclusion 1:31:27
#Excel #Data #Analysis #Microsoft #Training
(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
This is an amazing tutorial that I have ever watch, may the good lord be with you. I would need more from you. Thanks.
Wow, thank you!
Thanks!
This tutorial is amazing. I can't wait for the intermediate and advanced versions
Glad you like it!
@@LearnitTraining whens next one coming out?
Thank you for this! keep up the great work !
Thanks, will do!
FINISHED PRACTICING
Great!
This was great!
Thanks for watching!
great job and video MANY THANKS
You are welcome!
Great tutorial as always, thanks!!!
Glad you liked it!
@@LearnitTraining can this tutorial help you how to analyse large data sets, data validation and locate trends>
Thank you.
You're welcome!
Excellent tutorial
Thank you! Cheers!
FINISHED WATCHING
Thanks!
I'm confused. When I open the exercise file I have 2 columns before the "Commision Paid" column. Did you merge them under "Phone"?
nice work
Thank you! Cheers!
Thanks for the tutorials. You did a great job. I will like to know the version of Microsoft Excel you are using.
Thank you for the kind words! This is Excel 2019
Awsome
Thank you!
I would really appreciate tutorials for the MacOS versions of these Microsoft Office programs
Hi Shalom! The MacOS versions are currently being recorded!
@@LearnitTraining
I'm eagerly waiting for them.
Thank you 😊
I am a high school teacher, I will love and appreciate you if I can know the type of screen recorder app you make use of for this great tutorial. Thanks
Hello! We use Camtasia for screen recording. Hope that helps!
@@LearnitTrainingSure, thanks for the sincerity...
My bad 😞 internet very slow
No problem! We hope you learned alot!
Please explain in hindi
Hi Avadhesh! We are hoping our CC AI will be adding Hindi soon!
I don’t want to be rude, but you speak way too fast. Otherwise you’re fab!
Hi M.! You can slow the video down in the player options for a more suitable speed.
@@LearnitTraining okay, I’ll consider it.
@@m.4765 Honestly, it's a sick youtube feature. Other times I find that creators actually speak too slowly, & in those instances 1.25x speed increase is a legit life-hack.
@@chrysanth267 true!
Haa haa haa haa 🤪🤪🤪🤪🤪🤪🤪🤪🤪🤪🤪🤪
🤪🤪🤪🤪