MS Excel

Help With Excel Formula Syntax

So, you're trying to use a formula in MS Excel but it's been a while and you can't quite remember the formatting to use when entering the cell references of the data. Hmm… what to do, what to do?
http://www.worldstart.com/tips/tips.php/2007

The Never-Disappearing Borders

Ever run across a cell border in MS Excel that just wouldn't disappear? Here's how to fix it.
http://www.worldstart.com/tips/tips.php/1996

The AutoSum With More

Excel's handy little AutoSum button can be used for more than sums.
http://www.worldstart.com/tips/tips.php/1994

AutoSum in Excel with just 2 keys

Insert a sum formula without leaving the keyboard
http://www.worldstart.com/tips/tips.php/1991

Updating formula values in MS Excel- two methods

Excel values can update with your formula
http://www.worldstart.com/tips/tips.php/1987

Data insertion and cell shifting in MS Excel

Copy-paste and cut-paste and auto-shift the cells
http://www.worldstart.com/tips/tips.php/1977

Copy Column Widths in MS Excel

speed up column format adjustments in your spreadsheets
http://www.worldstart.com/tips/tips.php/1962

Using the Keyboard to Highlight Rows and Columns

Highlight an entire row or column in Excel
http://www.worldstart.com/tips/tips.php/1491

How Many More Work Days?

Let Excel figure out the days left until a deadline
http://www.worldstart.com/tips/tips.php/1486

Now Where Did That Zero Go?

If you've ever entered a number with a zero in the first place(s) you probably became very frustrated when you realized that Excel takes those zeros off the number. So, how do we overcome Excel's natural tendency to "help" us out in these situations?
http://www.worldstart.com/tips/tips.php/1273

Playing The Name Game

Get a better understanding of what it means to name ranges of cells in Excel.
http://www.worldstart.com/tips/tips.php/1269

Use A Title In Formulas in MS Excel

Did you know that when you have a title at the top of a column of data that you can use that title in formulas—instead of the cell reference?
http://www.worldstart.com/tips/tips.php/1268

Be The Master Of Your Excel Lists

Let's take a look at how to create a list that's all your own—in other words, a custom list.
http://www.worldstart.com/tips/tips.php/1267

Lists In MS Excel

Excel has lists? Yes, it does. (And fortunately they're not "to do" lists!)
http://www.worldstart.com/tips/tips.php/1266

Turn Many Into One

Here's the scenario: you're working on a table of data in MS Excel and you're trying to put a title over the entire table. What do you do?
http://www.worldstart.com/tips/tips.php/1265

What Was That Function Again?

Ever find yourself working in MS Excel and realize that the function you're looking for is right on the tip of your tongue - or fingers in this case?
http://www.worldstart.com/tips/tips.php/1264

Date & Time On Demand

Do you find yourself constantly entering the date and / or time in MS Excel? Wish you had a quick key combination to get the job done for you?
http://www.worldstart.com/tips/tips.php/1262

Quick Slide Margins - Part 2 - MS Excel

I thought it might be relevant to discuss quick margin adjustments in MS Excel.
http://www.worldstart.com/tips/tips.php/1261

Playing The "Shifty Cell" Game

Have you ever found yourself happily working in a large MS Excel worksheet only to discover that you need some cells in the middle of the thing?
http://www.worldstart.com/tips/tips.php/1257

The Wonders Of F2 In MS Excel

When you're working in Excel and you need to edit something that is already in a cell what do you do?
http://www.worldstart.com/tips/tips.php/1256