<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / Excel / Art and Science of Excel Modeling

Art and Science of Excel Modeling

Design, maintain robust business models. Ideal for consultants, analysts, auditors, managers. Enhance creativity, cost-saving, process improvement, informed decision-making with awesome Excel models.

Free Community Plan View Pricing Plans
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

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.

Course Outline ( Free Preview)

Art & Science of Excel Modeling - What you need to get started

Module 01A - Step By Step Approach to Decision Modeling with Excel (Why "Art Science" when it comes to Excel?)

Module 01B - Step By Step Approach to Decision Modeling with Excel (Art Science of Excel Modeling in 9 Steps)

Module 02A - Thinking Like Excel (Cell Referencing Essentials) 36 min.

Module 02B - Thinking Like Excel (Notation Styles) 20 min.

Module 03A - Advanced Formula Mastery (VLOOKUP) 54 min.

Module 03B - Advanced Formula Mastery (INDEX and MATCH) 78 min.

Module 04 - The Anatomy of an Excel Model 97 min.

Module 05A - Upgrading to the Modern Excel Table (Essential Techniques) 39 min.

Module 05B - Upgrading to the Modern Excel Table (Excel Table and Data Models) 23 min.

Module 05C - Upgrading to the Modern Excel Table (Review) 4 min.

Module 06A - Next Level Excel and Database Systems (Overview) 10 min.

Module 06B - Next Level Excel and Database Systems (Talking to Databases) 53 min.

Module 06C - Next Level Excel and Database Systems (Automating with Databases) 21 min.

This course includes:

  • 8+ hours of training
  • 14 Modules
  • * Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing