The Art Science of Excel Modeling is an in-depth exploration of how to plan, design, and maintain robust, efficient business-operational models with Excel. Ideal for consultants, financial analysts, auditors, accountants, managers, and technical professionals seeking to elevate their Excel modeling acumen, tap into greater design creativity, and reap the benefits of great Excel models that can drive cost savings, process efficiencies, and improved business decision making. Kicking off with a bigger-picture, philosophical view of spreadsheet design principles, we aim to stimulate critical thinking skills and inspire confidence as you navigate an increasingly competitive job market. In our “real world based” demonstrations, we will explore creative solutions to routine business problems in the business, finance, and accounting world. We will also offer practical guidance for newer challenges arising from the ever-increasing volumes of “big” data that seem to be “pushing the boundaries” that Excel is naturally equipped to handle.
Overview
COURSE DIFFICULTY
COURSE DURATION
9h 23m
Skills Learned
After completing this online training course, students will be able to:
Create advanced formulas and functions for complex calculations
Design financial models and forecasting tools
Design dimensional data models for analytics
Transform and analyze data to generate insights
Excel Power Users, Business Analysts
None
01. Step By Step Approach to Decision Modeling with Excel (Why "Art Science" when it comes to Excel?)
02. Step By Step Approach to Decision Modeling with Excel (Art Science of Excel Modeling in 9 Steps)
03. Thinking Like Excel (Cell Referencing Essentials)
04. Thinking Like Excel (Notation Styles)
05. Advanced Formula Mastery (VLOOKUP)
06. Advanced Formula Mastery (INDEX and MATCH)
07. The Anatomy of an Excel Model
08. Upgrading to the Modern Excel Table (Essential Techniques)
09. Upgrading to the Modern Excel Table (Excel Table and Data Models)
10. Upgrading to the Modern Excel Table (Review)
11. Next Level Excel and Database Systems (Overview)
12. Next Level Excel and Database Systems (Talking to Databases)
13. Next Level Excel and Database Systems (Automating with Databases)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create advanced formulas and functions for complex calculations
Design financial models and forecasting tools
Design dimensional data models for analytics
Transform and analyze data to generate insights
WHO SHOULD ATTEND
Excel Power Users, Business Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Step By Step Approach to Decision Modeling with Excel (Why "Art Science" when it comes to Excel?)
02. Step By Step Approach to Decision Modeling with Excel (Art Science of Excel Modeling in 9 Steps)
03. Thinking Like Excel (Cell Referencing Essentials)
04. Thinking Like Excel (Notation Styles)
05. Advanced Formula Mastery (VLOOKUP)
06. Advanced Formula Mastery (INDEX and MATCH)
07. The Anatomy of an Excel Model
08. Upgrading to the Modern Excel Table (Essential Techniques)
09. Upgrading to the Modern Excel Table (Excel Table and Data Models)
10. Upgrading to the Modern Excel Table (Review)
11. Next Level Excel and Database Systems (Overview)
12. Next Level Excel and Database Systems (Talking to Databases)
13. Next Level Excel and Database Systems (Automating with Databases)
