Excel Modeling 101: 10 Dos And Don'ts - Jobs and Recruitment on reed.co.uk, the UK's #1 job site

Excel Modeling 101: 10 Dos And Don'ts

£28.86

This course includes lifetime access so you can complete it at your own speed. This course is designed for those interested to learn more about Excel modeling, establish instant connection to multiple data sources rather than copy-paste and stack-up, build uniform formulas in Excel models to avoid errors and understand how Power Query can help prevent dragging processed data from table to table. Benefits of taking this course include: Unlimited and lifetime access to the course Learn the course at your own pace Course can be accessed on any platform 24/7 Customer support

SKU: 284101 Category:

Description

Business_Data analysis

Description

The course is presented in four parts.

First, brief introduction to what is Excel modeling and how to make an Excel model great:

  • Accuracy
  • Simplicity
  • Robustness

Second part brings a not-so-great Excel model as a business case, and introduces a financial report that is supposed to calculate the DSO – Days Sales Outstanding measure. By examination, this course demonstrates to the audience 10 Don’ts in Excel modeling, including:

  • Do not copy/paste data multiple files and stack them up
  • Do not leave comparable data in different columns
  • Do not process data “one at a time”

Third, we demonstrate how to correct the problems and bring up the list of the 10 Dos, including:

  • Connect or link to source data rather than copy and paste.
  • Keep comparable data in the same column
  • Keep related data processing in “one” table!

Last, the course culminates in summarizing the 10 Dos and Don’ts into 4 categories:

  • Data source
  • Data transformation
  • Formulas
  • Validation

Prerequisites and Advanced Preparation

  • Basic Excel and Power Query knowledge – Example: be able to open one Excel file and connect to external data files, etc.
  • Recommended prerequisite: Power Query – Part 1: Ultimate Data Transformation

Learning Objectives

  • Establish instant connection to multiple data sources rather than copy/paste and stack-up
  • Structure a table with related data in 1 column for easy pivoting
  • Build uniform formulas in Excel models to avoid errors
  • Recognize effective ways of keeping source data, entry data, and formulas all separate in models
  • Understand how Power Query can help prevent dragging processed data from table to table

Excel Modeling 101: 10 Dos And Don’ts will cover the following topics:

Section 1 – Introduction

  • Introduction
  • Wrong Model
  • Your Instructor
  • Comparison With Other Courses
  • What You Get From This Course
  • Downloadables – Exercises
  • Downloadables – Reports To Consolidate

Section 2 – Excel Modeling

  • What Is Excel Modeling
  • What Makes A Great Model
  • How To Calculate A Daily Sales Outstanding

Section 3 – The 10 Do’s And Don’ts

  • 1st Pair
  • 2nd Pair
  • 3rd Pair
  • 4th Pair
  • 5th Pair
  • 6th Pair
  • 7th Pair
  • 8th Pair
  • 9th Pair
  • 10th Pair

Section 4 – Takeaways

  • Takeaways
  • Next Course