Excel 2007 – The Basics

Please read Microsoft Excel – The Basics before reading this article.

Starting A New Spreadsheet

Starting a new spreadsheet in Excel 2007 is very easy.  All you need to do is open the software and it will load itself into a blank spreadsheet ready for you to edit.

[Read more…]

Excel 2003 – The Basics

Please read Microsoft Excel – The Basics before reading this article.

Starting A New Spreadsheet

Starting a new spreadsheet in Excel 2003 is very easy.  All you need to do is open the software and it will load itself into a blank spreadsheet ready for you to edit.

[Read more…]

Microsoft Excel – The Basics

Microsoft Excel is a piece of software that allows you to create, and manage spreadsheets.  You can use a spreadsheet for anything that would be table based and Excel includes the option to run simple and complicated calculations on your data through the use of formulas.  The Aim of this guide is to show you have to create, save, re-open and close an Excel spreadsheet using Excel 2003 or Excel 2007.

[Read more…]

How to Highlight Duplicate Entries in an Excel Spreadsheet using Conditional Formatting

If you have a large spreadsheet with multiple data records it can help to be able to identify duplicate entries.  This tutorial aims to show you how to use Conditional formatting within Microsoft Excel 2003 or 2007 to show how duplicate records within a coloumn can be highlighted.

[Read more…]