Hi fellow Excel Addict,

Have you been watching the Winter Olympics from Vancouver? If you've been reading or listening to all the critisism from the media about these Olympics, you are being seriously misled. Just ask Lindsey Vonn, Alexandre Bilodeau, Hannah Kearney, and Maelle Ricker how they feel about the 2010 Olympics.

Vancouver isn't the only place having unprecedented weather this winter. Just ask the people living around Washington DC. Even here in eastern Newfoundland, for the most part, we have had very little snow this winter compared to other years. However that may be about to change. For the third Friday in a row, we are facing a major snow storm. A 'snow day' on a Friday is a gift, but three Fridays in a row? What did we do to deserve this? (I'm only half joking.)

Keep on Excelling,
Francis J Hayes (The Excel Addict)

   

As you know, in Excel, you can get very creative with formulas and do things most users would never have thought possible. One of the drawbacks of complex formulas is that they are often difficult to understand - especially when you go back and look at them long after they were originally created.




Did you know you can make your complex formulas easier to read by breaking each section onto a separate line? Yes, you CAN insert line breaks in your formulas - just like you can insert line breaks in text in a cell.

Simply press ALT + ENTER as you are editing your formula to break the next section of the formula to the next line.

Not only does this make your formulas easier to read when you look back at them later but it also makes the process of creating your multi-step formulas much easier.

"I purchased your eBook and so did my boss.  Even though we are both experienced Excel user in the field of engineering and construction surveying, we find that your tips are top-notch and to the point; well above the standard fodder you find in the range of Excel books available on the market. Thank you" -- Richard J., Las Vegas, NV Try out the secrets in my ebook for two months. If they  don't save you 10 times the price of the book... If you're not 100% satisfied... ...simply request a full refund from ClickBank.com There's absolutely no risk to you.

If you're not 100% satisfied, simply request a full refund from ClickBank.com

Group Or Ungroup Your Taskbar Buttons? (WinXP)
 
When you have multiple windows open in the same application, by default, Windows XP will try to save space on the Taskbar by grouping these buttons. To switch to another window in the same application, you have to click the grouped button and choose from the list that pops up.
Some people find this grouping feature useful. Others, me included, prefer to work with separate buttons for each window.

If your buttons are currently grouped, try ungrouping them and see if you like it.

1) Right-click an empty area of the Taskbar and click Properties;
2) From the Taskbar tab clear the 'Group similar taskbar buttons' option;
3) Click OK.

At a glance you can see which windows you have open and also, when you are working between two windows (i.e. two Excel workbooks), you can quickly toggle back and forth using the familiar ALT+TAB keyboard shortcut.

If you work with many files open at the same time and find that the buttons on the Taskbar are too small to read the descriptions, you can adjust your Taskbar to show the buttons on two rows.

To do this, right-click a blank area of your Taskbar and, from the pop-up menu, make sure the 'Lock the Taskbar' option is not checked. Then, move your cursor to the top edge of the Taskbar until it changes to a two-headed vertical arrow. Now, slowly drag it up until the taskbar takes up two rows.