Nick's blog
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
ExcelExperts.com is HIRING !
Submitted by Nick on 8 December, 2009 - 14:06Yep, that's right, ExcelExperts.com is looking for Excel Experts to get paid for Excel consultancy.
...but this is no ordinary interview.
To apply for this job, you need to prove the following:
- You must be an Excel Expert, or be smart enough to learn quickly.
- You need excellent communication skills. (Written more important than verbal)
- You have to prove that you have the tenacity to see problems through to completion.
How do you prove this ?
- 13 comments
- Read more
- 37821 reads
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
ExcelExperts.com - Excel VBA Consultancy is open for business !
Submitted by Nick on 12 November, 2009 - 11:54
ExcelExperts.com is excited to announce that our Excel VBA Consultancy service is open for business, and we have completed the first Excel VBA consultancy job.
The task involved analysing the valuation of a large development site by way of complex discounted cash flows prepared by property valuation experts.
The work included:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Nov-2009 - ExcelExperts.com Update
Submitted by Nick on 9 November, 2009 - 15:08You've probably been wondering what I have been up to for the last few months given that there have not been many updates on the site.
Wellll... I've been looking after my new daughter, redecorating the entire house, and making photography books...
Here's the first one:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 27 - Create Hyperlinks
Submitted by Nick on 2 June, 2009 - 11:13
Create Hyperlinks
So, we have added data, pivot tables, and charts. We're now going to create an index page.
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 26 - Create A Chart
Submitted by Nick on 2 June, 2009 - 10:39
Create A Chart
Now we are going to create charts of our pivot tables so that we can get a visual representation of all this data.
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 25 - Create A Pivot Table
Submitted by Nick on 2 June, 2009 - 09:55
Create A Pivot Table
And now the lesson you've all been waiting for - How to create a pivot table !
A pivot table is an ingenious invention that allows you to slice and dice your data in as many ways as you can think of.
- 2 comments
- Read more
- 35461 reads
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 24 - Inserting And Renaming Worksheets
Submitted by Nick on 2 June, 2009 - 08:58
Inserting And Renaming Worksheets
We have finished with the data entry sheet now, so lets create an index page. We now need to insert a worksheet.
Insert A Worksheet
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
02-June-2009 - ExcelExperts.com Update
Submitted by Nick on 2 June, 2009 - 08:15June 2009 Stats update from ExcelExperts.com
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 23 - Find And Replace
Submitted by Nick on 1 June, 2009 - 17:08
Find And Replace
Suppose I've changed my mind and now prefer to use the term "Entertainment" instead of "Eating Out"
How do I do this ?
Easy..
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 22 - VLOOKUP Formula
Submitted by Nick on 1 June, 2009 - 16:09
VLOOKUP Formula
Now, it has occurred to me that I can save time when entering future expenses because I have realised that I can pretty much categorise the expenses.
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 21 - Filter Data
Submitted by Nick on 1 June, 2009 - 15:42
Filter Data
Now you want to know how many of those expenses occurred in the last 1000 days.
Autofilter is perfect for this!
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 20 - Sort Data
Submitted by Nick on 1 June, 2009 - 15:32
Sort Data
So you've entered a load of expenses, and now realise that you have entered them in the wrong order. It would be nice to sort them.
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 19 - Freeze Panes
Submitted by Nick on 1 June, 2009 - 15:13
Freeze Panes
This lesson is on how to freeze the panes. Freezing panes is about keeping the headings in view whilst being able to scroll down to enter data at the end.
To demonstrate why you want to do this:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 18 - Protection
Submitted by Nick on 1 June, 2009 - 14:36
Protection
When designing a spreadsheet, it is important to differentiate between areas to enter data, and areas that are calculating values based on that data.
Think: Inputs / Outputs
As a general rule, cells containing formulae should be protected, and coloured differently, so lets do that here.
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 17 - Copy And Paste Special Values
Submitted by Nick on 1 June, 2009 - 13:57
Copy And Paste Special Values
We've just learnt how to enter a formula, so this lesson is on how to convert the formulae to values.
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 16 - Absolute References
Submitted by Nick on 1 June, 2009 - 13:15
Absolute References
Now we want to enter a formula to calculate how many days ago we spent the money.
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 15 - Insert A Column
Submitted by Nick on 1 June, 2009 - 11:37
Insert A Column
I now want to calculate how many days ago I spend the money, but I forgot to add a heading for that. I'll need to insert a column.
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 14 - Copy A Formula
Submitted by Nick on 1 June, 2009 - 10:47
Copy A Formula
In the last lesson, we entered a formula. We now want to apply that formula to all the dates in column A.
There's a quick way to copy a formula that saves us from entering it again and again.
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
Teach Yourself Excel Lesson 13 - Enter A Formula
Submitted by Nick on 1 June, 2009 - 10:20
Enter A Formula
We've entered some dates in our Expense tracker, and now we need to enter a formula that will tell us the month and the year of those dates so we can use this information in the summary of our expenses.
Steps:
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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 picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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 picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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 picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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 picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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 picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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 picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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.
- 2 comments
- Read more
- 16828 reads
![Nick's picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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 picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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 picture Nick's picture](http://excelexperts.com/sites/default/files/pictures/picture-1.jpg)
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:
![RSS - Nick's blog Syndicate content](/misc/feed.png)
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