A Microsoft Excel MVP, Microsoft Certified Trainer, Financial Modeler and Data Analyst with over 10 years work experience in Banking, Insurance and Business Development. Bernard is a certified Microsoft Excel Expert skilled in Business Analytics, Dashboards and building Financial models for Budgeting, Business Valuation, Scenario Planning and Investments.
He is founder of Finex Skills Hub www.finexskillshub.com and co-founder of Business Evolution Systems & Training Ltd www.best-gh.com (Approved Training Provider of the Financial Modeling Institute, Canada). The firm has successfully trained over 30 Advanced Financial Modelers in Ghana.
He runs the Finex Project, a pro bono student training outreach program for undergraduate students in Microsoft Excel, Office Tools and Financial Modelling.
Actual v Budget Dashboard with CUBEFUNCTIONS in Excel
The goal of this session is to show participants how to create a dynamic Actual v Budget Dashboard with CUBEFUNCTIONS. From just two tables of Actual v Budget data, trainees will make use of Power Query, Power Pivot and CUBEFUNCTIONS to convert the Data into a Dynamic Dashboard that can be sliced by Department, Account Type and Scenario.
Excel Virtually Global is an independent conference and is neither sponsored nor approved by Microsoft.