Skip to content
Contact Visit forvismazars.com (opens in a new tab)
Register

Tips and tricks to work smarter in Excel

Excel techniques for faster, cleaner model work: formula tracing, Go To Special, the settings worth changing, quick charts and snapping objects to the grid.

Browse coursesView more resources

Webinar · Recording · Presented by Joshua Grimm · 12 September 2024

Excel tips and tricks webinar slides

The slides from this session.

Download the slides (opens in a new tab)

Faster work, better output

If you spend your day in financial models, small gains in speed add up, and they should not cost quality. This recorded webinar shares the Excel techniques we recommend, mixing old favourites with newer features, so you take a few new skills back to your desk.

What you will learn

  • Formula tracing, to follow and debug a model quickly
  • What Go To Special can do beyond the options most people use
  • Excel settings that save time and keystrokes
  • Selection techniques for moving around and working with data
  • Quick charting, with classic and newer chart types
  • The snap to grid shortcut, to line up objects on dashboards and presentations

Learn financial modelling in a room

Hands-on courses in person and online, taught to more than 20,000 people on one modelling standard.

Best Practice Project Finance Modelling

Build and sensitise robust cashflow models from scratch, faster in Excel. Hands-on, practitioner-led, in person or online. See dates and book your place.

View full course details: Best Practice Project Finance Modelling

Further Financial Modelling for Advanced Modellers

Further Financial Modelling for Advanced Modellers: shareholder loans, mezzanine debt, regearing, FX and financial-year tax.

View full course details: Further Financial Modelling for Advanced Modellers

Advanced Project Finance Modelling

Debt sizing, covenant monitoring, DSRAs and integrated three-way statements. Hands-on, practitioner-led training, in person or online. See dates and book.

View full course details: Advanced Project Finance Modelling

Browse all training courses

More on this topic

Webinars

Managing circular references in financial models

The circular references that appear in financial models, the errors they cause and the best practice ways to keep them out of a model without VBA.

Mastering timing flags in an Excel financial model

Timing flags that drive every date-based calculation in a model, from construction and operations phases to regular events and delay scenarios.

Services

Financial Modelling Support

Experienced modellers who work alongside your team when you need them, to update a model, add a refinancing case or check work before it goes out.

Financial Model Development

Transaction and operational models built to one modelling standard, documented for lenders and investors and handed over with the logic explained.

Learn to build these models yourself

We run public and in-house courses across the full financial modelling curriculum.

Browse all training coursesSend enquiry