Dates

Download starting Sheet

A lesson on Dates in Excel is a very important one as understanding Dates is crucial to writing an  effective spreadsheet.

Save A File

Download starting Sheet

So, we've entered some data in our spreadsheet, and now it's important to save that data so it's not lost.

How to Save

There is nothing worse than losing data that you've spent hours entering so here's a note on saving.

To save your file:

Format Data

Download starting Sheet

Now we've entered some data, it's a good idea to format it nicely.

First, we'll format the date column

Delete Data

Download starting Sheet

Now we're going to learn how to delete data.

Suppose the last expense entry you did was completely wrong, and you need to delete it.

Data Validation

Download starting Sheet

We have our headings entered, so now we need to enter some expenses.  

Enter the following data:

Change Column Width

Download starting Sheet

Having entered your data in the previous lesson, You'll immediately notice that you cannot see all the data as the columns are too small.

Enter Data

From now on, we will build up a blank workbook step by step in order to make the finished Expense Tracker. Each lesson will follow-on from the previous one, and at each stage, you will be able to download the correct files at the beginning and the end.

Sheet Navigation

Now, you'll learn how to find your way around Excel.

Practice all of these before proceeding: 

NOTE: The + in this case means hold down the first key before pressing the second once

Definitions

Familiarise yourself with the definitions of the basic components as we'll be referring to them a lot during the course.

How To Open Excel

Step1:

With your mouse, click on the START button:

That brings up a menu that will look like this:

Step2: Press R (to Run a program).. You'll now see this:

Why Should I Use Excel ?

If you've found this page, you're probably asking: Why should I use Excel ?... I've managed my whole life without it.. What is this Excel thing ?

Well, here's my list of top reasons why you might want to learn how to use it:

Here's a tip on how to insert alternate blank lines in about 20 seconds.

We have this:

And we want this:

Navigating around your sheets can be very fiddly when you have a lot of sheets, but this little tip simplifies things massively

Simply right click on the sheet navigation arrows at the bottom left of your worksheet. (Bottom left of screen shot below)

You'll get this:

This tip is about the second stage of creating a model in Excel:

• Getting it into a powerpoint presentation.

Here's a screen shot of our data in Excel:

We can copy it to powerpoint to look like this:

Compare 2 Data Sets

• Have you ever spent hours reconciling 2 sets of data ?
• Is it your job to reconcile data ?

If yes, then this utility goes out to you. I have done that job, and it's really hard work.... This will get you home early.

You can use this utility for:

ExcelExperts.com is pleased to launch a variety of of Free Property Calculators designed to answer your important property decisions:

Excel 2007 vs Excel 2003 ?

I have now been using 2007 for a while, so here are my observations on 2007 vs 2003.

This ulility can save you an enormous amount of time if you have a task involving merging 2 data sets.

If you work in Data or Operations, this could be the file for you !

This utility is aimed at working out how complex a spreadsheet is

• Simply enter the full file path of the file, press the button, and you will be provided with an analysis of your file.

You'll get:

This tip is about finding out whether a cell is within a range.

• It's basic set theory... we use VBA's INTERSECT

What we want to write is some VBA code that tells us whether we have selected a cell within the data table:

In this VBA tip, we'll learn how to select various things on a worksheet:

A way to ask a user of your system a question is to use an Inputbox:

Here's what we're trying to achieve:

Ask the question:

Display the answer:

Here's the code:

In this VBA tip, we'll learn how to call code from another workbook:

• The way to do this is to use Application.Run

Here's the code:

To replicate:

There's an easy way to email a workbook with a single line of code:

• Use "Activeworkook.SendMail"

Here's the code:

Here's the email it produces:

This tip shows you how to create an Index page with hyperlinks to each sheet:

Here's a screen shot of what we will produce:

Here's the code we use:

Don't go writing code to convert Excel sheets to HTML:

• Use Save As Web Page instead.
• It's quick, easy, and does a lot of work for you.
• If you have an intranet at work, and want to use it to share information without worrying about sharing workbooks, this is a good way.

Here's a screen shot of our data in Excel:

Managing Range names can be fiddly, but this tip makes it a lot easier:

ExcelExperts.com is pleased to formally launch the Excel Experts Question and Answer Forum

Why should you use this forum ?

This utility will list all the files in a folder and subfolders.