Nick's blog

3. Excel Tips - Easily paste special values - Hidden Menu
Submitted by Nick on 8 March, 2009 - 20:29
A neat trick that most people don't know (even some professed experts) is a quick way of pasting values.
Step1:
Type anything in cell A1
Step2:
Right click on the right hand side of selection, and drag slightly to the right
A Hidden menu will appear:
Training Video on easily Pasting Values:

2. Excel Tips - Create numbers 1 to 10 easily
Submitted by Nick on 8 March, 2009 - 20:27
You can easily create a list of numbers by:
Step1:
In cell A1, type: 1
Step2:
In cell A2, type: 2
Step3:
Select the range A1 to A2
Step4:
Click and drag down to A10 the square in the bottom right of your selection
.. you can drag this as far as you want, and it will keep on incrementing the number
Video Training on creating numbers 1 to 10:

1. Excel Tips - How many days until Christmas ?
Submitted by Nick on 8 March, 2009 - 20:20
This example will show you how to calculate the number of days between now and christmas.
Step1:
- In a cell A1 in a new workbook, press: CTRL + ;
- That will put today's date in the cell
Step2:
- In cell A2 type: 25/dec
- Excel will correctly guess the year
Step3:

5. Learn VBA - What does my recorded Macro code actually mean ?
Submitted by Nick on 8 March, 2009 - 19:39
This is a follow on from our previous VBA tip on how to record macros.

4. Learn VBA - Record a Macro
Submitted by Nick on 8 March, 2009 - 19:37
Do you find yourself doing the same tasks every day ?
Do you want Excel to automate them ?
This tip is about how to record a macro.
Recording macros is the first step to automate tasks, and to learn VBA.
You can get a decent amount of automation done with this simple procedure.
Step1:
Press the following in sequence:
ALT then t then m then r
That will bring up this screen:

3. Learn VBA - SUBS and FUNCTIONS explained
Submitted by Nick on 8 March, 2009 - 19:36
Now we're going to learn what VBA SUBS and FUNCTIONS are.
A SUB is a piece of code that runs something
A FUNCTION is a piece of code that returns something
Now lets see it in action with a real life example:
Your wife asks you the time.
You look at your watch
You tell her the time.
What would this look like in code ?

2. Learn VBA - FOR Loops
Submitted by Nick on 8 March, 2009 - 19:35Loops are fundamental to programming, and in this tip, we'll look at FOR loops.
If you have never programmed before then this step by step guide will show you how to write your first program.
Q. What is a loop ?
A. I think this is best explained using an example.

1. Learn VBA - Introduction to VBA Editor
Submitted by Nick on 8 March, 2009 - 19:33
Excel 2007:
Lesson 1 will teach you how to attach some code to a button that will bring up a message box that says Hello!.
Step1:
Make sure your excel options (Office button in top left => Excel Options) are as shown:
Step2:

05-Mar-09 NEW CALCULATOR - "Sell Or Rent Out" calculator - designed for Buy to Let investors
Submitted by Nick on 5 March, 2009 - 21:53
"Sell Or Rent Out" calculator
- Should you stick with your "Buy To Let" Property, or sell it now ?

18-Feb-09 Two NEW sections on Interview questions
Submitted by Nick on 18 February, 2009 - 19:01
Today, we have 2 new sections to ExcelExperts.com. Dedicated to those looking for a job in this tough market.

Nick's Finance Interview Questions
Submitted by Nick on 18 February, 2009 - 09:23
This section is on Finance Interview Questions...
Largely Fixed Income.
These are some of my favourite interview questions to ask in a finance interview.
If you have questions you've been asked and you want an answer, Contact ExcelExperts.com
- 53 comments
- 183491 reads

Newest Releases - 17-Jan-09
Submitted by Nick on 17 February, 2009 - 20:31Newest developments !
- 12-Feb-09 Facebook Texas Holdem Poker Training
- 17-Feb-09 Redundancy Planning Calculator
Know any poker players ?
- this is for them.
Know anyone who has been made redundant recently, or anyone who is worried in case they're made redundant ?
- this is for them.

Nick's Excel Tip Of The Day - Part 3
Submitted by Nick on 16 February, 2009 - 09:30
This is a follow-on from my 2nd series on Excel Tips - Excel Tip Of The Day - Part 2
All NEW tips Here
- 5 comments
- 17451 reads

Nick's Excel Tip Of The Day - Part 2
Submitted by Nick on 23 January, 2009 - 21:45- 14 comments
- 17546 reads

Nick's Excel For Finance Tip Of The Day
Submitted by Nick on 23 January, 2009 - 15:51
This is my Excel for Finance Tip of the day blog. If you want to know how to calculate compound interest in excel, about discount factors, or even convert from simple interest to compound interest, this is the place for you.
- 11 comments
- 32065 reads

Nick's guide to Excel / VBA Interview Questions
Submitted by Nick on 12 January, 2009 - 14:33
I have hosted hundreds of Excel / VBA interviews, and I can work out very quickly how good someone is.
The biggest blunder to make in an interview is to say something like: "Oh, that's easy, I can do that in 5 minutes with the compiler and help files"
- 101 comments
- Read more
- 138815 reads

Nick's step by step guide to learn VBA
Submitted by Nick on 11 January, 2009 - 19:13Learning VBA is all about building on a few fundamentals. Once you've started, it gets a lot easier. This VBA Training section will teach you those VBA fundamentals.
Hundreds of New VBA Training Videos added here
- 20 comments
- Read more
- 367455 reads

Nick's VBA Tip Of The Day
Submitted by Nick on 10 January, 2009 - 10:37
There definitely won't be VBA tips every day, but I think it's a good idea to separate the VBA tips from the Excel ones.
- 15 comments
- 37941 reads

Nick's Excel Tip Of The Day - Part 1
Submitted by Nick on 19 December, 2008 - 12:49I will try to add a tip each day, but it's more of a goal than a promise
; - >
Nick
New Tips added here
Subscribe to new tips
- 66 comments
- Read more
- 72596 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