Feb 22nd, 2008Lesson 3: Subtracting & Conditional Format
In this video tutorial we will learn:
To create a simple record of income & expenditure in Excel.
How to make a text box.
How to subtract using Excel.
How to ensure that negative balances are shown in red, by using conditional formatting.
Feb 22nd, 2008Lesson 1: Add up with Excel
In this video tutorial we are going to learn how to:
Add up using the Excel ‘Sum’ function.
How to format cells so that they have a currency.
We will also get some idea of:
What a ’spreadsheet model’ means.
Why spreadsheet models are useful.