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.