EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Financial Modeling in Excel Explore some awesome excel shortcuts to audit financial models
Secondary Sidebar
Finance Blog
  • Financial Modeling in Excel
    • Financial Modeling
    • Financial Modeling Interview Questions
    • Financial Forecasting
    • Financial Projections
    • Financial Modeling For Startups
    • Confidence Interval Formula
    • Degrees of Freedom Formula
    • Multicollinearity
    • Excel shortcuts to audit financial models
    • Financial Modeling Basics Tutorial
    • Building Financial Models
    • Financial Modeling Jobs Descriptions
    • Financial Modeling Tests
    • Financial Modeling Concept Checkers
    • Financial Modeling Techniques
    • Types of Financial Model
    • Financial Modeling In Example
  • Accounting fundamentals (700+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Basics (373+)
  • Credit Research Fundamentals (6+)
  • Economics (88+)
  • Finance Formula (386+)
  • Investment Banking Basics (140+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (27+)
  • Insurance Resources (14+)
  • Top Finance Books (7+)
Finance Blog Courses
  • Online Financial Modeling Training
  • Online Equity Research Training
  • Online Mergers and Acquisitions Certification
  • LBO Modeling Course

Explore some awesome excel shortcuts to audit financial models

By Madhuri ThakurMadhuri Thakur

excel shortcuts to audit financial models

In a research company, Ms. Annie, trainee, with the basic knowledge of excel has built a financial model but unfortunately the financials of the model did not tally.

girl_on-table1Ms. Annie went to every cell to find out where the model went wrong but got confused going cell wise and failed to find out the error.

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

Ms. Annie got frustrated and was wondering “Building a financial model is so easy but auditing the financial model is a tedious task. I wish I could explore some awesome excel shortcuts to audit financial models.”

In this thought Annie went to her friend named Ms. Annika who was working as a senior research analyst in the same company. Annie told her the problem and Ms. Annika helped her to explore some awesome excel shortcuts to audit financial models. Let’s see what did she taught Annie.

All in One Financial Analyst Bundle(250+ Courses, 40+ Projects)
Financial ModelingInvestment BankingUS GAAPCFA-Level 1 & 2
Equity ResearchM & A ModelingPrivate Equity ModelingForex Trading
Price
View Courses
250+ Online Courses | 40+ Projects | 1000+ Hours | Verifiable Certificates | Lifetime Access
4.9 (86,035 ratings)

Financial model and Excel Shortcuts

  • Ctrl page down / Ctrl page up

A financial model has different sheets to navigate.Using a mouse to navigate through these sheets every now and then can be a bit tough.So avoid using mouse and use the keyboard shortcut CTRL+Page up OR Ctrl + Page Dwn to navigate to different worksheets.

  • F2 Key

F2 key of the key board is used if you want to know:-

  • The formula used to calculate a certain item
  • The cells used to calculate the formula
  • Edit the formula

Recommended courses

  • Financial Modeling of Apparel Sector Certification Training
  • Private Equity Modeling Online Training
  • Certification Course in Financial Modeling of Banks
  • Online Training on Financial Modeling and Valuation

Let’s assume you wanted to check which formula is used and which cells are taken into consideration to calculate the EBITDA.

For this go to the desired  EBITDA cell  and click on F2 key.

 

11

You will see something like this wherein the cells that are used to calculate has been highlighted by different colors. Now if you want to change the cell linked in the formula I.e. to calculate EBITDA if you want to use F8 instead of E8 then just click in the highlighted rectangle and drag and drop to the required cell. The changes will be incorporated

To come out of it Click on any cell of the Worksheet or click ESC key of the key board.

  • Ctrl {

An effective financial model does not have sheet linked from one worksheet only but it has cells linked from different worksheets from the same workbook as well.

Imagine a situation where your balance sheet is not tallying due to wrong linkages of interest expense and you need to check which cell it got linked to. The interest expense of income statement needs to be linked from interest expense schedule which is available in different worksheet.

What will you do to overcome this situation? Will you check the cell number it got linked to and go to that worksheet and manually find which cell it was? Don’t you think this is time consuming and confusing as well?

To overcome this Use the shortcut CTRL + {.This shortcut will bring you to the cell it got linked from.

16

 

Now you need to check from where did interest expense got linked so go to the cell you want to check then use the shortcut key Ctrl + { . This shortcut will bring you to the cell it got linked to from any worksheet available in the same work book.

 

 

 

 

 

13vbfh

 

So in this example, for the interest expense it will bring to the interest expense schedule and the cell which got linked will be highlighted.

  • F5

Using the above shortcut key you have reached to the cell which actually got linked. But you have not completed the audit of income statement completely so you want to go back to income statement and start from the same cell you were checking the linkage and complete the audit.

Again now what will you do? Getting a thought of doing it manually is a bad idea. To overcome this situation use the F5 shortcut key .

For example , you had used this ctrl +{ Shortcut and came to the page it got linked and now to again go to the interest expense cell in income statement which you were linking  Press F5 on the same sheet  you will see the cell it is referring to and click ok .

 

14

This will bring you to the cell it was referring. Reference will generally refer to the previous cell you were at.

  • Ctrl ~

This shortcut is used where for the entire worksheet you want to see the formulas used together. So go to any cell of the worksheet where you want to see only the formulas and press CTrl +~ .  This is how it would appear  

15

To check the cells linked to calculate  EBITDA just click on the desired Cell and the cells that are linked will get highlighted.

To come back to numbers do the same procedure again go to any cell of the same worksheet and press Ctrl +~

girl_on-tableMs. Annie got highly delighted as she could explore some awesome excel shortcuts to audit financial models. She thanked Ms. Annika in helping her.

Ms. Annie went back to her financial model and went through the entire model using these shortcuts very easily. She found her mistake and she rectified it and was very happy as her financial model got tallied.

Ms. Annie with a sigh of relief wondered “Auditing a financial model was definitely a tedious job but this awesome excel shortcuts has made it so easy.”

Explore some awesome excel shortcuts to audit financial models, Infographics

Learn the juice of this article in just a single minute, Explore some awesome excel shortcuts to audit financial models Infographics

Recommended Articles

Here are some articles that will help you to get more detail about the Audit financial models so just go through the link.

  1. Pivot Chart in Excel
  2. Useful Features of 2016 Excel Workbook
  3. Advanced Excel Formulas and Functions
Popular Course in this category
All in One Financial Analyst Bundle- 250+ Courses, 40+ Projects
  250+ Online Courses |  1000+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Financial Modeling Course (7 Courses, 14 Projects)4.9
Equity Research Training (17 Courses)4.8
Mergers & Acquisition Course (with M&A Projects)4.7
LBO Modeling Course (4 Courses with Projects)4.7
24 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Financial Modeling Course

3 Statement Model Creation, Revenue Forecasting, Supporting Schedule Building, & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more