4 Online Courses - Advanced Excel Data Analysis and Modeling Masterclass

Unlock the power of data analysis and modelling with 4 online courses in Advanced Excel. Join the masterclass with Alpha Academy and enhance your skills.

What you Get

• 1 x Hyperli voucher code to redeem for the 4 Online Courses - Advanced Excel Data Analysis and Modeling Masterclass

How to Redeem

• Look over the fine print for information on how you can redeem your voucher

Questions?

Email us – [email protected]

Course Content

Excel Course: Dashboards Data Analysis & Heatmaps

• Analysis of Twitter Dataset and Designing Heatmaps
• Advanced Currency Converter using Dynamic Arrays
• Laundry Service Model and Invoicing Dashboard

Data Analysis Using Excel

• Excel data analysis – 1 to 9

Microsoft Excel: Build Models Using Advanced Formulas, VBA, Power Query

• Introduction
• Prepaid Expenses Models: Resources Download
• Accounting for Prepaid Expenses
• Excel Formulas Detailed: Introduction to three Excel Models
• Formula Based Prepaid Expenses Model
• Calculate Prepaid Expenses Amortisation from Exact Start Date
• Prepaid Expenses Summary with Power Query and Pivot Table
• Advanced VBA Prepaid Expenses Amortisation Model
• BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way
• Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic
• Thank you
• Resources

Excel PowerQuery and PowerPivot Masterclass

• Pivot table power query power pivot – 1 to 26

For full course content, click the links below:

Excel PowerQuery and PowerPivot Masterclass
https://hyperliprod.shop/course/excel-powerquery-and-powerpivot-masterclass/

Microsoft Excel: Build Models Using Advanced Formulas, VBA, Power Query
https://hyperliprod.shop/course/microsoft-excel-build-models-using-advanced-formulas-vba-power-query/

Data Analysis Using Excel
https://hyperliprod.shop/course/data-analysis-using-excel/

Excel Course: Dashboards Data Analysis & Heatmaps
https://hyperliprod.shop/course/excel-course-dashboards-data-analysis-heatmaps/