Excel 2007 How to Create a Cash Flow Forecast Guide - Level 1

Provides a step by step guide on how to create a Cash Flow Forecast in Excel 2007.

This covers the following:

Select Multiple Cells
Change Cell Formats
Resize Columns and Rows
Adjust Printing Preferences
Save Excel files
Carry out AutoSum and Enter Bespoke Formulas
Use Auto Fill and Copying by Dragging
Add Different Types of Borders
Add Colors, Font Size and Text Orientation
And Much More...

Visit me at Spreadsheet Republic for more Guides, Videos and Spreadsheet Templates.

---

Closed Caption:

Hello and welcome to my Excel 2007 How to
Create a Cash Flow Forecast - Level 1 Guide.
My name is Mark and today I will be walking
you through, step by step, the techniques and
processes required to set up a simple Cash
Flow Forecast in Excel 2007.
This video guide is suitable for those with little,
or no, experience with Excel 2007.
Along the way you will learn:
How to Create, Save, Preview and Print files.
How to use time saving Functions and
Formatting techniques.
How to apply Colors, Borders and Font Formats
with confidence.
How to structure a spreadsheet to ensure that it
remains easy to read and understand, no matter
what data it contains.
Use this guide in conjunction with my Free
Overview Guide for Excel 2007 if you are just
staring out with Excel.
This is the spreadsheet we will be creating
today.
It is a Cash Flow Forecast broken down into
twelve months, with separate Receipts and
Payments sections.
We also have an Opening Cash Balance that is
automatically taken from the Closing Cash
Balance of the previous month.
Work with me today to create this Cash Flow
Forecast.
Each of my guides comprise of three parts.
Part One focuses on structuring your
spreadsheet.
Part Two looks at entering the formulas required
for your Cash Flow Forecast.
Part Three moves on to focus on applying
formatting to your Cash Flow Forecast.
Download my video guide now and within a few
minutes I could be helping you, to not only
create this Cash Flow Forecast,
but also be well on the way to boosting your
confidence with Excel 2007.
Join me at www.spreadsheetrepublic.com where
you can download this guide, as well as, other
written guides and videos.