Blogs

Teach Yourself Excel Lesson 12 - Dates
Submitted by Nick on 1 June, 2009 - 09:26
Dates
A lesson on Dates in Excel is a very important one as understanding Dates is crucial to writing an effective spreadsheet.
- Nick's blog
- Login or register to post comments
- Read more
- 12454 reads

Teach Yourself Excel Lesson 11 - Save A File
Submitted by Nick on 29 May, 2009 - 21:44
Save A File
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:
- Nick's blog
- Login or register to post comments
- Read more
- 10773 reads

Teach Yourself Excel Lesson 10 - Format Data
Submitted by Nick on 29 May, 2009 - 10:12
Format Data
Now we've entered some data, it's a good idea to format it nicely.
First, we'll format the date column
- Nick's blog
- Login or register to post comments
- Read more
- 12011 reads

Teach Yourself Excel Lesson 9 - Delete Data
Submitted by Nick on 29 May, 2009 - 09:40
Delete Data
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.
- Nick's blog
- Login or register to post comments
- Read more
- 11199 reads

Teach Yourself Excel Lesson 8 - Data Validation
Submitted by Nick on 28 May, 2009 - 17:43
Data Validation
We have our headings entered, so now we need to enter some expenses.
Enter the following data:
- Nick's blog
- Login or register to post comments
- Read more
- 15920 reads

Teach Yourself Excel Lesson 7 - Change Column Width
Submitted by Nick on 28 May, 2009 - 16:22
Change Column Width
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.
- Nick's blog
- Login or register to post comments
- Read more
- 15742 reads

Teach Yourself Excel Lesson 6 - Enter Data
Submitted by Nick on 28 May, 2009 - 16:02
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.
- Nick's blog
- 2 comments
- Read more
- 16833 reads

Teach Yourself Excel Lesson 5 - Sheet Navigation
Submitted by Nick on 28 May, 2009 - 15:18
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
- Nick's blog
- Login or register to post comments
- Read more
- 16084 reads

Teach Yourself Excel Lesson 4 - Definitions
Submitted by Nick on 28 May, 2009 - 14:43
Definitions
Familiarise yourself with the definitions of the basic components as we'll be referring to them a lot during the course.
- Nick's blog
- 1 comment
- Read more
- 14725 reads

Teach Yourself Excel Lesson 3 - How To Open Excel
Submitted by Nick on 28 May, 2009 - 13:38How 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:
- Nick's blog
- Login or register to post comments
- Read more
- 14517 reads

Teach Yourself Excel - Online Course Outline
Submitted by Nick on 28 May, 2009 - 13:22
- Nick's blog
- Login or register to post comments
- Read more
- 112080 reads

Teach Yourself Excel Lesson 1 - Why Should I Use Excel ?
Submitted by Nick on 28 May, 2009 - 11:54
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:
- Nick's blog
- Login or register to post comments
- Read more
- 24766 reads

95. Excel Tips - Insert Alternate Blank Lines
Submitted by Nick on 27 May, 2009 - 15:23
Here's a tip on how to insert alternate blank lines in about 20 seconds.
We have this:
And we want this:
- Nick's blog
- 2 comments
- Read more
- 30737 reads

94. Excel Tips - Sheet Navigation With Lots Of Sheets
Submitted by Nick on 27 May, 2009 - 14:07
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:
- Nick's blog
- Login or register to post comments
- Read more
- 9578 reads

93. Excel Tips - Copy Charts To Powerpoint
Submitted by Nick on 27 May, 2009 - 10:37
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:
- Nick's blog
- Login or register to post comments
- Read more
- 8186 reads

26-May-2009 NEW UTILITY: Compare 2 Data Sets
Submitted by Nick on 26 May, 2009 - 16:09
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:
- Nick's blog
- 8 comments
- Read more
- 26334 reads

26-May-2009 Free Property Calculators
Submitted by Nick on 26 May, 2009 - 09:12
ExcelExperts.com is pleased to launch a variety of of Free Property Calculators designed to answer your important property decisions:
- Nick's blog
- Login or register to post comments
- Read more
- 3156 reads

25-May-2009 Excel 2007 vs Excel 2003
Submitted by Nick on 25 May, 2009 - 11:06
Excel 2007 vs Excel 2003 ?
I have now been using 2007 for a while, so here are my observations on 2007 vs 2003.
- Nick's blog
- 5 comments
- Read more
- 4885 reads

22-May-2009 NEW UTILITY: Merge 2 Data Sets
Submitted by Nick on 22 May, 2009 - 15:14
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 !
- Nick's blog
- Login or register to post comments
- Read more
- 17454 reads

22-May-2009 NEW UTILITY: Analyse A Workbook
Submitted by Nick on 22 May, 2009 - 12:54
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:
- Nick's blog
- 3 comments
- Read more
- 16899 reads

29. VBA Tips - Find Out If A Cell Is Within A Range
Submitted by Nick on 21 May, 2009 - 10:58
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:
- Nick's blog
- Login or register to post comments
- Read more
- 23914 reads

28. VBA Tips - Selecting Things Demo
Submitted by Nick on 20 May, 2009 - 12:43
In this VBA tip, we'll learn how to select various things on a worksheet:
- Nick's blog
- Login or register to post comments
- Read more
- 9619 reads

27. VBA Tips - Inputbox
Submitted by Nick on 19 May, 2009 - 16:56
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:
- Nick's blog
- 6 comments
- Read more
- 33912 reads

26. VBA Tips - Call Code From Another Workbook
Submitted by Nick on 19 May, 2009 - 15:54
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:
- Nick's blog
- Login or register to post comments
- Read more
- 30360 reads

25. VBA Tips - Email Workbook
Submitted by Nick on 19 May, 2009 - 15:05
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:
- Nick's blog
- 1 comment
- Read more
- 16512 reads

24. VBA Tips - Create An Index Page
Submitted by Nick on 19 May, 2009 - 13:45
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:
- Nick's blog
- 9 comments
- Read more
- 41483 reads

92. Excel Tips - Save As Web Page
Submitted by Nick on 19 May, 2009 - 11:19
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:
- Nick's blog
- Login or register to post comments
- Read more
- 8775 reads

91. Excel Tips - Display All Range Names
Submitted by Nick on 18 May, 2009 - 13:49
Managing Range names can be fiddly, but this tip makes it a lot easier:
- Nick's blog
- 2 comments
- Read more
- 14850 reads

18-May-2009 Launching Excel Experts Question and Answer Forum
Submitted by Nick on 18 May, 2009 - 10:21
ExcelExperts.com is pleased to formally launch the Excel Experts Question and Answer Forum
Why should you use this forum ?
- Nick's blog
- Read more
- 13243 reads

15-May-2009 NEW UTILITY: List Files In Folder
Submitted by Nick on 15 May, 2009 - 19:06
This utility will list all the files in a folder and subfolders.
- Nick's blog
- 40 comments
- Read more
- 80857 reads

Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago