Description
This Webinar Is For You If You Want To
This is a good fit if you want to:
- Understand the weaknesses of Excel as far as protecting the user goes
- Learn the 10 most common types of formula errors
- Have a checklist for debugging faulty work, whether it’s someone else’s, or yours
Sample Content
Details
In this 45-minute webinar, you will review best practices related to working in Excel spreadsheets and practice techniques in a live workbook.
- consistent formatting of assumptions inputs vs. formula-based outputs
- rapid file navigation techniques
- model checks techniques
- efficient and clear formula syntax
- how to perform quality control using Excel’s settings and using your own criteria
- how to isolate and de-bug mistakes
- how to save a formula mid-progress
- how to get 100% comfortable with an inherited file.
This is a hands on the keyboard Excel webinar. You will watch the video and follow along in Excel.
The video running time is 45 minutes.
Through the direct experience of REFM’s principals in commercial real estate transactions, and REFM’s ongoing consulting to industry practitioners across the U.S. for the last decade, we have developed and have continually refined “The REFM Way” of teaching financial modeling.
Corporate Training Clients
University Training Clients
To enhance your learning and help you to efficiently build a practical skill set, we:
- Always set the stage by providing the big picture first, and keep it at the fore with graphs and sparklines
- Speak in plain language and define industry terms on an ongoing basis
- Give you highly granular video chapter hyperlinks so you can find what you want quickly and easily.
Upon successful completion of this course, you will:
- Have gained an appreciation for how treacherous it is to work in Excel
- Have learned how to work rapidly and accurately
- Understand the steps you can take to do more careful, error-free work.
What You Get
Lifetime online access to:
- An easily-navigated 45-minute video tutorial with playback controls up to 2x speed. Videos have captions available and are playable on any device including PC, Mac, phones and tablets.
- Unlocked associated Excel file presented in the video.
Meet Your Instructor
Since 2009, top companies and educational institutions have trusted REFM to train thousands of their employees and students.
New to REFM training?
Clients Include
Clients Include
Amherst
ASB Capital Management
Barings
BentallGreenOak
BrightSpire
Brixmor
Brookfield
CapitalOne
CBRE Global Investors
CCRE
Centennial Bank
Citibank
ColonyNorthstar
Conrex
CPPIB
CRC Companies
CreditSuisse
Crescent Communities
Crow Holdings
DDG
DLA Piper
Greystar
GTIS Partners
Hodes Weill & Associates
Houlihan Lokey
Howard Hughes
Jamestown
JBG Smith
JPMorganChase
Kennedy Wilson
Link Logistics
LivCor
Lubert-Adler
Macys
Oxford Properties
Park Hill
Peterson Companies
PGIM
PN Hoffman
Prometheus
QuadReal
Related
Revantage
SEO
Skanska USA
Square Mile Capital
USAA Real Estate
Asset Living
CBRE Global Investors
Clark Enterprises
Comstock Homes
Conor Commercial
Crescent Communities
Federal City Property
Flournoy
Four Seasons
Grosvenor
GTIS Partners
Hines
Hoffman
Howard Hughes
HPET
Hunt Companies
Insight Property Group
Kettler
LaSalle Investment
MadisonMarquette
Markwood
Mesa Capital
Midway
Miller Valentine
Panoramic Interests
PEG Development
Renaissance Downtowns
Rockefeller Group
Skanska USA
Snavely Group
Trammell Crow Residential
Trion Properties
Vornado
Video Chapter Markers
- Introduction
- 5 truths about Excel
- Setting yourself up for speed
- Alt keys overview
- Show/hide ribbon
- Quick access toolbar
- Vertical navigation waypoints
- Copy/paste bumper column
- Expand/contract formula bar
- Traditional cell formatting conventions
- Custom formatting
- Finding all inputs at once
- Format painting
- Autofit column width
- Specify column width
- 5-part framework for cash flow projection formulas
- 10 most common types of formula errors
- Model auditing techniques
- Saving a partially-built formula
- Quality control checks.
