| 1. Creating a data model.mp4 | 48.2 MB | ||
| 1. Creating a data model.srt | 6.3 KB | ||
| 1. Introduction.mp4 | 1.5 MB | ||
| 1. Introduction.srt | 614.4 B | ||
| 1. What are Macros.mp4 | 4.2 MB | ||
| 1. What are Macros.srt | 1.5 KB | ||
| 1. What is Power Query.mp4 | 13.7 MB | ||
| 1. What is Power Query.srt | 3.3 KB | ||
| 1.1 PrepPP.xlsx | 13.9 MB | ||
| 10. Sorting data with Macros.mp4 | 39.1 MB | ||
| 10. Sorting data with Macros.srt | 4.8 KB | ||
| 11. Filtering data with Macros.mp4 | 51 MB | ||
| 11. Filtering data with Macros.srt | 6.6 KB | ||
| 12. Protecting cells and sheets with macros.mp4 | 54.3 MB | ||
| 12. Protecting cells and sheets with macros.srt | 7.5 KB | ||
| 13. Debugging Macros Part 1.mp4 | 67.7 MB | ||
| 13. Debugging Macros Part 1.srt | 8.2 KB | ||
| 14. Debugging Macros Part 2.mp4 | 117.2 MB | ||
| 14. Debugging Macros Part 2.srt | 13.6 KB | ||
| 15. Debugging Macros Part 3.mp4 | 80.5 MB | ||
| 15. Debugging Macros Part 3.srt | 9.4 KB | ||
| 16. Creating Macros Manually.mp4 | 85.7 MB | ||
| 16. Creating Macros Manually.srt | 12.7 KB | ||
| 2. Building data relationships.mp4 | 41.1 MB | ||
| 2. Building data relationships.srt | 6.8 KB | ||
| 2. Please Read.html | 102.4 B | ||
| 2. Setup Microsoft 365.mp4 | 23.2 MB | ||
| 2. Setup Microsoft 365.mp4.jpg?042148 | 141.1 KB | ||
| 2. Setup Microsoft 365.srt | 4.1 KB | ||
| 2. What is VBA.mp4 | 2.8 MB | ||
| 2. What is VBA.srt | 1 KB | ||
| 2.1 AddData.xlsx | 14.8 MB | ||
| 3. Activating Macros and VBA Tools.mp4 | 8.6 MB | ||
| 3. Activating Macros and VBA Tools.srt | 2.4 KB | ||
| 3. Connecting to data source.mp4 | 31.3 MB | ||
| 3. Connecting to data source.srt | 5 KB | ||
| 3. Create lookups with DAX.mp4 | 40 MB | ||
| 3. Create lookups with DAX.srt | 7.1 KB | ||
| 3. Getting Started with Microsoft 365.mp4 | 22.4 MB | ||
| 3. Getting Started with Microsoft 365.srt | 5.1 KB | ||
| 3.1 Lookups.xlsx | 14.8 MB | ||
| 4. Creating Pivot Tables.mp4 | 50.8 MB | ||
| 4. Creating Pivot Tables.srt | 8.9 KB | ||
| 4. Exploring VBA Tools.mp4 | 58.9 MB | ||
| 4. Exploring VBA Tools.srt | 8.2 KB | ||
| 4. Preparing your query.mp4 | 45.8 MB | ||
| 4. Preparing your query.srt | 4.9 KB | ||
| 4. What is Power Pivot.mp4 | 2.9 MB | ||
| 4. What is Power Pivot.srt | 1 KB | ||
| 4.1 Pivot.xlsx | 15.4 MB | ||
| 4.1 Prep.xlsx | 14.8 MB | ||
| 5. Analyse data with Pivot Charts.mp4 | 52.5 MB | ||
| 5. Analyse data with Pivot Charts.srt | 8.1 KB | ||
| 5. Cleaning data.mp4 | 73.7 MB | ||
| 5. Cleaning data.srt | 8.8 KB | ||
| 5. Creating a basic macro.mp4 | 49.7 MB | ||
| 5. Creating a basic macro.srt | 11.8 KB | ||
| 5. Office versions of Power Pivot.mp4 | 6.9 MB | ||
| 5. Office versions of Power Pivot.srt | 1.4 KB | ||
| 5.1 Charts.xlsx | 17.3 MB | ||
| 5.1 Cleansing.xlsx | 14.8 MB | ||
| 6. Enhancing your query.mp4 | 79 MB | ||
| 6. Enhancing your query.srt | 10.1 KB | ||
| 6. How to enable Power Pivot in Excel.mp4 | 7.3 MB | ||
| 6. How to enable Power Pivot in Excel.srt | 1.7 KB | ||
| 6. Refreshing data source.mp4 | 49.2 MB | ||
| 6. Refreshing data source.srt | 7.1 KB | ||
| 6. Saving a worksheet with a macro.mp4 | 6.8 MB | ||
| 6. Saving a worksheet with a macro.srt | 2.1 KB | ||
| 6.1 Enhance.xlsx | 13.4 MB | ||
| 6.1 Refresh.xlsx | 17.3 MB | ||
| 7. Creating a second macro part 1.mp4 | 41.8 MB | ||
| 7. Creating a second macro part 1.srt | 6.9 KB | ||
| 7. Updating Queries.mp4 | 67 MB | ||
| 7. Updating Queries.srt | 9.5 KB | ||
| 7.1 Update.xlsx | 17.3 MB | ||
| 8. Creating a second macro part 2.mp4 | 39.7 MB | ||
| 8. Creating a second macro part 2.srt | 5.5 KB | ||
| 8. Creating new reports.mp4 | 43.8 MB | ||
| 8. Creating new reports.srt | 7.8 KB | ||
| 9. Deleting Macros.mp4 | 51.4 MB | ||
| 9. Deleting Macros.srt | 7.3 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| EV sales (King county).csv | 27.6 MB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 85 total files | |||
Excel Data Analyst - Excel/PowerQuery/PowerPivot/PivotCharts
https://CourseBoat.com
Published 06/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 36 lectures (3h 21m) | Size: 1.62 GB
Data Analysis with Microsoft Excel
What you'll learn
Analyse data with Excel
Transform and clean data with Power Query
Create models and perform data analysis with Power Pivot
Summarize data with Pivot Tables
Create data visualization with Pivot Charts
Create macros
Debug Macros
Sort data using excel macros
Filter data using excel macros
Manually create macros with VBA
Requirements
Basic knowledge of Excel advised.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.7 GB | freecoursewb | 1 month | 12 | 1 | |
| 2.7 GB | freecoursewb | 1 month | 18 | 1 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 month | 9 | 5 |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 month | 6 | 1 |
| 3.8 GB | freecoursewb | 1 month | 19 | 5 |
All Comments