E-DAB 02: Data, Proper Data Sets, Excel Tables, Logical Tests, More

This video #2 in our class teaches about Data, Data Types, Proper Data Sets, Excel Tables, Soring, Filtering and Logical Tests.
This class : Data Analysis & Business Intelligence Made Easy with Excel Power Tools - Excel Data Analysis Basics = E-DAB Class – Sponsored by YouTube and taught by Mike Girvin, Highline College Instructor, Microsoft Excel MVP and founder of the excelisfun channel at YouTube. This is a free educational resource for people how want to learn about the Basics of Data Analysis and Business Intelligence using Microsoft Power Tools such as, PivotTables, Power Query, Power Pivot, Power BI Desktop and more.
Topics:
1. (00:12) Introduction
2. (01:14) What is Excel? What about the Data in the Cells?
3. (08:30) What is Data, Raw Data?
4. (10:01) Understanding the Difference Between Data & Information.
5. (10:45) Define Proper Data Set.
6. (in pdf notes) Why Proper Data Sets are Mandatory.
7. (14:25) Tables are not Charts
8. (14:50) Use Excel Tables For Dynamic Data. Learn about Excel Table Feature.
9. (20:00) Data Types in Proper Data Sets in Various Tools
10. (24:00) How to Sort Data.
11. (26:07) Filtering & Extracting Data.
12. (28:47) Understand & Use AND Logical Tests and OR Logical Tests
13. (34:35) Summary

Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

[excelisfun]

Topics:
1. (00:12) Introduction
2. (01:14) What is Excel? What about the Data in the Cells?
3. (08:30) What is Data, Raw Data?
4. (10:01) Understanding the Difference Between Data & Information.
5. (10:45) Define Proper Data Set.
6. (in pdf notes) Why Proper Data Sets are Mandatory.
7. (14:25) Tables are not Charts
8. (14:50) Use Excel Tables For Dynamic Data. Learn about Excel Table Feature.
9. (20:00) Data Types in Proper Data Sets in Various Tools
10. (24:00) How to Sort Data.
11. (26:07) Filtering & Extracting Data.
12. (28:47) Understand & Use AND Logical Tests and OR Logical Tests
13. (34:35) Summary

[LeilaGharani]

Thank you Mike for a wonderful video on Excel data analysis basics.

[Barbiegirl]

This is comprehensive enough, you still provided the resources to use in order to follow up with everything you did👏🏾

[A.Nahedd]

words cannot qualify nor quantify your effort

[karakaromdocumentries]

i have jumped from just being a lay man to a professional data analyst just watching these new course. thanks E-DAB IS FANTASTIC and thank you Mike Girvin for your contribution AND it was an epic video.

[wayneedmondson]

Hi Mike.. great start to E-DAB! For newcomers to data analysis in tables, you might want to mention CTRL+SHIFT+L for toggling Autofilter on/off to quickly and easily re-set filters. Also, worth mentioning that sorting permanently re-orders the data in your table, so create a key column to sort if returning to the original order is required. The first time you taught me these concepts.. it was gold! Looking forward to more. Thumbs up!

[michiegan]

Thank you Mike for breaking down the excel logics and anything about it from the start, your many videos have helped me in my work countless times and now that I am planning to shift into a data analyst profession I will surely be referring to your many videos. I greatly appreciate you and your team's work. Thank you again!

[excelisfun]

Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

[beautyandbeyond]

one of the great point in your work, that you are always considering the new joiners to it, they don't need to search for previous information been given in older videos, not like others we are tired looking for one information connected to the recent class, just to push people to watch their older video... which is ok to watch that old video but will lead to distraction and disconnecting the focus....thank you!

[MOHAMEDABDOU]

You are the best. All my heartfelt gratitude to you for this course and all your videos.

[geekyprogrammer]

your videos are way better than Coursera and Udemy!!

[faustopf-.]

You are that unusual kind of person that just make the world better. Thanks a lot for these free series!

[JanBolhuis]

And another great video explaining the basics of data analysis. Thank you!

[etaylor]

This is the best training I have ever recived. It beats my MSc in Finance by far. God bless you Mike!

[ameensams]

Every time I watch your videos, I can't stop praying to God to keep doing amazing things in your life just as you do in the life of many. What you ditch out here is just simply amazing.

[moniquemishelle]

Awesome video. This is the best explanation I've seen on data analysis.

[alialbayati]

My number one Excel channel.
Thank a lot Mike.

[siddharthaj]

By far the best excel course I've attended. Thanks a ton Mike!

[thaooan]

Thank you so much for creating this class. Many thanks. 🌻

[Nedwin]

This is probably one of the best excel courses on the internet! Thank you!