Excel & Power BI Data Analysis Complete Class in One Video - 365 MECS 04
Download Excel Zipped Folder with all files:
Course taught by Excel MVP and Highline College Professor, Mike Girvin.
Topics in video:
1. (00:00) Introduction
2. (03:52) What is Data Analysis?
3. (04:37) Sorting and Filtering. Example 1 & 2
4. (13:24) FlashFill. Example 3.
5. (15:58) Standard PivotTable with Summarize Values By and Show Values As calculations. Example 4.
6. (20:25) Power Query to import, clean, transform and refresh data and load to Excel Worksheet. Complete Introduction to Power Query. Example 5.
7. (34:07) First look at Power Query’s Functional Language: M Code
8. (55:05) Power Query to Import and combine 12 tables into one table and load directly to a PivotTable Report & Excel Chart Visualization. Example 6.
9. (01:10:18) Excel Line Chart Visualization based on PivotTable
10. (01:14:04) Data Modeling for Examples 7, 8 & 9
11. (01:17:51) XLOOKUP function, PivotTable and Excel Charts to bu
4 views
5598
1992
1 month ago 00:05:17 1
10 самых влиятельных персон российского искусства. The 10 most influential figures of Russian art.
1 month ago 00:03:58 1
The Shira Choir x The Kiffness - Im Hashem Lo Yivneh Bayis (Psalm 127 DANCE REMIX)
1 month ago 00:16:16 1
🔥INCROYABLE : TRUMP & POUTINE UNIS POUR DÉFENDRE LES VALEURS FONDAMENTALES FACE AUX DÉRIVES MODERNES
2 months ago 00:00:00 1
La matinale 31/10 : P-DIDDY, ASE, Delon, les révélations exclusives de Karl Zéro !
2 months ago 00:03:26 11
ABASI CONCEPTS // MICRO-AGGRESSOR
2 months ago 00:05:55 1
Spirit of Camp and Knife
2 months ago 00:00:37 1
La spiruline: Top produit ! #spiruline #complementsalimentaires
2 months ago 00:01:18 35
Arcturus Nova - Ambient Soundscape Kontakt Instrument
2 months ago 00:00:00 1
Golden Axe II [Sega] | Прохождение (Играем-вспоминаем) + 1 год с дебютного прохождения
2 months ago 00:40:35 1
ЗВЕЗДА ТРЕТЬЕГО РЕЙХА! Марика Рекк. Актриса немецкого кино.
2 months ago 00:00:26 9
Rowing on a Rowing Machine: Strength and Cardio Training on TYTAX
2 months ago 00:03:12 1
Saathiya - Yudhra | Siddhant Chaturvedi, Malavika Mohanan | Vishal Mishra, Pratibha B, Javed A | SEL
2 months ago 00:44:02 1
Basstardos / The Black Room Sessions - Full Concert - LIVE