Excel Shortcuts

Lesson Overview
This lesson will introduce you to what are in our opinion the essential excel shortcuts. Microsoft Excel is a powerful tool that allows you to take data from your worksheet and position the chart within the worksheet.

Lesson

Excel keyboard shortcuts can dramatically increase your productivity.

The Reference Guide that can be downloaded for this lesson lists the most important keyboard shortcuts and some combination of key strokes that will save you a lot of time. We suggest you practice these until they are second nature.

Additionally, if you don’t know how relative referencing works (E9, $E$9, E$9, $E9, E9) check this tab out too.

The Reference Guide also covers all the other model techniques that we cover in all the subsequent lessons. There is no need to look at these sheets yet. You will be guided to the right place in each subsequent lesson.

Summary

Now you know the most essential excel shortcuts that will save you time.

Assignment

Build a simple model in your current modeling style to demonstrate the two mortgage options used in Lesson 1. This model will be used for the next 2 lessons and feedback on it will be given after Lesson 4. We recommend you use the template from lesson 2.

Inputs
-House Price: £300,000
-Mortgage Payment over 15 years
-Mortgage 1
-10% Deposit
-Annual Payment of £32,400
-Mortgage 2
-50% Deposit
-Annual Payment of £13,200

Outputs
-Annual cashflow
-Cumulative cashflow
-Graph of Annual cashflow
-Graph of Cumulative cashflow

By: Rich Bowdler

Article Directory: http://www.articledashboard.com

For more free professional training visit us at indexmatch.co.uk