Advanced Data Analysis & Reconciliation

Online Course • dbrownconsulting

About the CPD course

This is a blended course (online + Classroom) in Advanced Data Analysis & 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.

CPD Provider

dbrownconsulting

View Profile

Send an enquiry

Full Name*

Email Address*

Contact Number*

Industry*

Your Enquiry*

By submitting this form, you consent to CPD sending you email regarding your application.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

dbrownconsulting

dbrownconsulting (DBC) provides Data focused courses to help organisations make sense of their data leading to better and more profitable business decisions. We offer courses in Financial Modeling, Power BI, Office 365, Data Visualisation & Analytics and Financial Analysis. Since 2006, we have trained over 10,000 participants working in over 300 organisations worldwide. Our Classroom courses are Blended, combining a rigorous online video based Pre-work, intensive Case Study based classroom sessions and an online post training support portal.