Referencing & Excel Shortcuts for Financial Modeling

1
Referencing Excel Shortcuts for Financial
Modeling About Us MindCypress is an excellent
platform for cognitive e-learning with a great
progressive course structure. We have been
creating an impact on the online education
industry, since 2015. Currently, we are catering
to most parts of the United States (USA), United
Kingdom (UK), Middle East, Africa and South East
Asia for services like Classroom and Live Virtual
Training Courses. In todays time, we are making
our presence globally in the field of e-learning.
Professionals and scholars would get a career
growth with MindCypresss innovative
self-learning certification program. E-learning
courses from MindCypress gives you the
convenience and flexibility to take sessions from
anywhere and indulge in the modules at your own
pace. Our courses are best suited for people who
want to continue working while, studying and earn
a certificate that can turn out to be beneficial
for their career growth
Financial modeling is the process of building
financial models to assess the value of
businesses. If you are familiar with spreadsheets
or have taken financial modeling training, then
financial modeling will be an easy task for you.
You can build financial models by using Excel.
The basic concepts of financial modeling
certifications are the same as the fundamental
concepts of finance. A financial model includes
the following elements Debt, Asset, Equity, Cash
Flow, Budget, Revenue and Cost Formula. Generall
y, a financial model is a mathematical
spreadsheet that shows how a company will perform
in the future. It will include complex
calculations related to the companys financial
performance and it may also include calculations
that show the impact of new strategies on the
company.
2
The idea of developing a financial model is to
provide the users of the model with a
comprehensive and understandable picture of how
the company is performing financially. Financial
models can be used to create realistic scenarios
to see how the company can perform over
time. The output of the financial model can be
used to evaluate and make decisions on the
companys financial performance. For example, a
financial model can show how the companys
performance will be affected by changes to the
companys strategies or assets. Financial models
are very useful tools that can help any business
or organization predict how the organization will
perform and react to changes. Thus, financial
modelling and excel training is a must nowadays
in financial modeling certifications. Excel
shortcuts to Audit Financial Models In general,
shortcuts let you get things done faster and
easier. The following shortcuts will definitely
help you improve your financial model. Financial
modeling and excel training are the best ways to
improve your financial goals. Shortcut 1 Using
the F4 key, you can copy formula into other
cells, across columns and down rows. Shortcut
2 Use Ctrl , Ctrl - to sum a column of
numbers or a row of numbers. Shortcut 3 If you
want to freeze the formulas on particular cells,
use CtrlShift (For Mac Cmd Shift ).
Shortcut 4 In order to quickly copy a formula
from one cell to another cell, use Ctrl (For
Mac Cmd ). Shortcut 5 To get a trendline
for the trendline, use either Ctrl Shift F or
Ctrl Shift T. Shortcut 6 To sum numbers in
a cell, use Ctrl Shift Enter (For Mac Cmd
Shift Enter).
3
Shortcut 7 Undo any action using Ctrl Z (For
Mac Cmd Z). Shortcut 8 To copy values from
one cell to another cell, use Ctrl Shift C
(For Mac Cmd Shift C). Shortcut 9 To copy
values from a range to another cell, do the
following Select range A1A15. Press Ctrl
Shift V (For Mac Cmd Shift V). Shortcut
10 To delete empty rows, use Ctrl (For Mac
Cmd ).
Top Excel Shortcuts You Need for Financial
Modeling

• Here is a list of a few shortcuts that will help
  you become a human calculator and make your life
  easier when you are working on financial models
• CTRLA Selects all the cells in a worksheet.
• CTRLC Copies the selected cell contents.
• CTRLINS Copies the formulas of the selected
  cell.

4

• CTRLSHIFTENTER Copy the formulas to the rest
  of the "References" of a formula in a cell.
• CTRLZ Undo the last action.
• CTRLALTD Creates a Pivot Table in a blank cell
  next to the active cell.
• CTRLENTER When you are entering data in a cell,
  press CTRLENTER to move to the next line in the
  cell.
• CTRLSHIFTMINUS SIGN Insert new row below the
  active cell.
• CTRLSHIFTPLUS SIGN Insert new column to the
  right of the active cell.
• SHIFTF9 While using a function in a cell, press
  SHIFTF9 to evaluate the function and display the
  result in the cell. For example, in an SUM
  function, it will display a sum of all the values
  in the active cell.
• CTRLALTF1 Open the "Microsoft Excel Help"
  window. In a Pivot Table, press F2 to open the
  "PivotTable Fields" window.