Report Automation in Modern Excel

This is a blended course (online + Classroom) in Advanced Data Analysis &amp, Reconciliation using Excel Functions, Pivot Tables, the Solver tool, Power Query and the new Dynamic Arrays and Rich Data Types in Excel. The Course will take you through a robust methodology for automating all your dashboards or reports. This methodology, once implemented, will save you a significant amount of time by being fully autonomous with no Excel input requirements from you, just dump your new data (transactions) into a designated folder and all your reports update like magic. This is not a Beginner Excel course it assumes that students have a basic understanding of Excel.&nbsp,

This is a highly intensive course in financial modelling. It covers the entire Advanced Financial Modeler Syllabus of the Financial Modelling Institute (FMI) using our unique training methodology trusted by thousands of participants. This course will get you from zero knowledge to knowing how to build 3 statement models for any business or industry. It also includes a very detailed online Pre-course in Excel. Use this course to prepare and achieve the (AFM) designation issued by FMI.

This course will showcase the tools in Office 365 that facilitates a collaborative workforce. Office 365 has emerged as the leading cloud based solution for equipping a workforce with anytime, anywhere access to a full set of productivity tools. You will learn the essentials skills to using the main Office 365 tools efficiently. You will also learn the effective use of inbuilt Artificial intelligence engines in all Office 365 Products (Excel, Word, PowerPoint, Teams, Yammer, Outlook and more) that eliminate hours of work time spent creating presentations, reports, or communicating with peers and clients.

This course will introduce all the Power BI technologies including Power Query, DAX, Data Modelling (Power Pivot), M. We go through a methodology for automating all your reporting needs and teach you how to create beautiful reports and dashboards giving you 360-degree view of your business.