Nick's blog

Nick's picture

2. Excel Tips - Create numbers 1 to 10 easily

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:

Nick's picture

1. Excel Tips - How many days until Christmas ?


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:

Nick's picture

5. Learn VBA - What does my recorded Macro code actually mean ?


This is a follow on from our previous VBA tip on how to record macros.

Nick's picture

4. Learn VBA - Record a Macro


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:

Nick's picture

3. Learn VBA - SUBS and FUNCTIONS explained

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 ?

Nick's picture

2. Learn VBA - FOR Loops

Loops 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.

Nick's picture

1. Learn VBA - Introduction to VBA Editor

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:
Data

Step2:

Nick's picture

05-Mar-09 NEW CALCULATOR - "Sell Or Rent Out" calculator - designed for Buy to Let investors

"Sell Or Rent Out" calculator
- Should you stick with your "Buy To Let" Property, or sell it now ?

More on the "Sell or Rent Out" Calculator.

Nick's picture

18-Feb-09 Two NEW sections on Interview questions


Today, we have 2 new sections to ExcelExperts.com. Dedicated to those looking for a job in this tough market.

Nick's picture

Nick's Finance Interview Questions


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  

Nick's picture

Newest Releases - 17-Jan-09

Newest developments !

Nick's picture

Nick's Excel Tip Of The Day - Part 3


This is a follow-on from my 2nd series on Excel Tips - Excel Tip Of The Day - Part 2

All NEW tips Here

Nick's picture

Nick's Excel For Finance Tip Of The Day


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.

Nick's picture

Nick's guide to Excel / VBA Interview Questions

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"

Nick's picture

Nick's step by step guide to learn VBA

Learning 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

 

Nick's picture

Nick's VBA Tip Of The Day


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.

To Learn VBA, follow this link

Nick's picture

Nick's Excel Tip Of The Day - Part 1

I 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

Syndicate content