Art & Science of Excel Modeling

$95.00

What Will You Learn?

  • Basic spreadsheet design principles
  • How to demonstrate “real-world” creative solutions to routine business problems
  • How to plan, design and maintain business operational models with Excel

 

Description

The Art & Science of Excel Modeling course is an in-depth exploration of how to plan, design, and maintain robust, efficient business-operational models with Excel. This class is 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 improve 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.

Instructor

SZILVIA JUHASZSZILVIA JUHASZ

Excel Expert
Szilvia Juhasz is co-host at Excel TV, author, and management consultant. As the founder of Los Angeles-based XSzil Consulting, Szilvia likes to challenge traditional ‘spreadsheet-thinking’ with her Excel power user training programs and specialized business consulting services.

 

What to Know Before the Class

A basic understanding of working with Excel is helpful, but not necessary, for this course. The target audience is beginner Excel users.


Duration: 7:55:54
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.
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?)
06:03
Module 01B - Step By Step Approach to Decision Modeling with Excel (Art Science of Excel Modeling in 9 Steps)
45:49
Module 02A - Thinking Like Excel (Cell Referencing Essentials)
36:25
Module 02B - Thinking Like Excel (Notation Styles)
19:48
Module 03A - Advanced Formula Mastery (VLOOKUP)
54:04
Module 03B - Advanced Formula Mastery (INDEX and MATCH)
01:17:40
Module 04 - The Anatomy of an Excel Model
01:37:03
Module 05A - Upgrading to the Modern Excel Table (Essential Techniques)
38:43
Module 05B - Upgrading to the Modern Excel Table (Excel Table and Data Models)
22:55
Module 05C - Upgrading to the Modern Excel Table (Review)
03:45
Module 06A - Next Level Excel and Database Systems (Overview)
10:29
Module 06B - Next Level Excel and Database Systems (Talking to Databases)
52:36
Module 06C - Next Level Excel and Database Systems (Automating with Databases)
21:03
Class Survey

 

System Requirements

  • Windows, 7, 8 or 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 5 GB of free hard drive space
  • Microsoft Excel 2013 or higher