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's the Deal?

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

How to Redeem your Voucher

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

Questions?

Email us – info@alphaacademy.org

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://www.alphaacademy.org/course/excel-powerquery-and-powerpivot-masterclass/

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

Data Analysis Using Excel
https://www.alphaacademy.org/course/data-analysis-using-excel/

Excel Course: Dashboards Data Analysis & Heatmaps
https://www.alphaacademy.org/course/excel-course-dashboards-data-analysis-heatmaps/

The offer is valid for 12 months from the date of purchase Redeem your voucher via the following link – https://www.alphaacademy.org/redeem-voucher/ Enter your voucher code and complete the registration process as prompted If further assistance is needed, contact us - info@alphaacademy.org Please note, NO refunds apply once your Hyperli voucher has been purchased