Ementorhub

Skills you'll gain

Workflow Management

Process Optimization

Data Analysis Expressions (DAX)

Data Integrity

Automation

Data Validation

Predictive Modeling

Spreadsheet Software

Financial Forecasting

Data Modeling

Excel Formulas

Excel Macros

Microsoft Excel

Financial Modeling

Business Modeling

There are 7 modules in this course

Check for and prevent errors in spreadsheets; Create powerful automation in spreadsheets; Apply advanced formulas and conditional logic to help make informed business decisions; and Create spreadsheets that help forecast and model data. Once again, we have brought together a great teaching team that will be with you every step of the way. Nicky, Prashan and myself will guide you through each week. As we are exploring these more advanced topics, we are following Alex who is an Excel consultant called in by businesses that experience issues with their spreadsheets.

Conditional Logic

Automating Lookups

Formula Auditing and Protection

Data Modelling

Recording Macros

Final Assessment