Зміст курсу
Excel for Finance
Excel for Finance
2. Advanced Data Manipulation with Power Query
4. Dashboard Automation
5. Developing an Interactive Report
Excel FormulasСекція 5. Розділ 2
Курси /
Excel for Finance
Excel for Finance
0%
1. Introduction to Power Query
Prepare to discover the fundamentals of Power Query, including navigating the Get Data tab, establishing connections with databases and Excel workbooks, and effectively merging queries to streamline your data processing tasks.
2. Advanced Data Manipulation with Power Query
You will dive deeper into Power Query's capabilities by connecting and integrating data from CSV files and folders. This section will guide you through adding custom columns, merging data sources, handling errors gracefully, and efficiently grouping and unpivoting columns to prepare data for advanced analysis.
3. Power Pivot Handling
The section covers advanced data preparation, relationship building, and calculation methods using Power Pivot.
4. Dashboard Automation
Delve into creating a highly automated and interactive dashboard from start to finish. We explore advanced features such as pivot charts, KPI integration, and slicers to enhance functionality and user interaction.
5. Developing an Interactive Report
Discover advanced functions to create an interactive and automated report for calculating key financial metrics on a monthly basis.
