Category Archives: Excel

Tip #006 – Excel

COUNT is Good Excel formula but it has Limitations

If you want Excel to count how many cells contain numeric entries – use the COUNT function (ie, =COUNT(range)). Cells containing non-numeric entries (ie, text) will NOT be included in the answer…

 

Read More

Tip #008 – Excel

Speed up your data entry

If you need to enter the same data (text, numbers or equations) into a range of cells – rather than type it then copy it to the adjacent range of cells – type it into the entire range at once…

 

Read More

Tip #011 – Excel

Repeating an Entry…Quickly

Hopefully you are already familiar with Excel’s AutoFill feature: if you are typing a list and start to type an entry that matches a previous entry in that column/list – Excel will try to facilitate quick data entry by displaying (in black) the rest of the entry. If that IS what you were intending to type – press [ENTER] and Excel will complete the entry for you. If that wasn’t what you intended – then finish the entry yourself.

HOWEVER…

Read More

Tip #068 – Excel

Excel: More Ways to Play with the Fill Handle

Yet another use for the ever-flexible Fill Handle…

 

Read More

Tip #002 – Excel

The Fastest Copy Method

You have typed a formula into a cell near the top of a column. You would like to COPY that equation to all the blank cells below you (stopping at the lower boundary of the other columns in your spreadsheet)…

 

Read More