Microsoft Excel Tips & Tricks for All Occasions

Excel Tips for Creating Charts The Bright Hub library of Microsoft Excel tips isn’t just limited to techniques and strategies for creating files needed in the business world – we also look at quite a number of ways you can use Excel’s powerful features to manage your personal finances and even how you can use the spreadsheet software to create your own games. In fact, if you already own Excel and have been thinking about purchasing an additional software product to help organize and analyze personal or business data, you may want to hold off on that purchase and see if it’s possible to use Excel instead. This way, a small investment of time could save you quite a bit of money!

In addition to investigating new uses for the application, many of these Excel tips focus on becoming more efficient through the use of keyboard shortcuts, macros, and other neat little tricks. And, if you’re using an older version of Excel – don’t worry. While many of these tips focus on getting the most out of Excel 2007 and 2010, we cover prior releases of the software as well.

Microsoft Excel: Make Any Logo Into an Autoshape Turn your business logo into an Excel AutoShape with these easy steps....	Microsoft Excel: Transform Black And White Spreadsheets Into Color Problem: Your worksheet is boring black and white, as shown in Fig. 1045. You want to jazz it up with color....
Microsoft Excel: Copy Matching Records To A New Worksheet Problem: From the dataset shown in Fig. 656, you want to copy records for one particular customer to a new worksheet....	Microsoft Excel: Increase A Range By Two Percent Problem: You run the repair department for a company. As shown in Fig. 779, you have a spreadsheet of prices. Your manager tells you to increase the price on all service contracts...

Microsoft Excel: Add A Page Break At Each Change In Customer

Problem: Your data is sorted by customer in column A, as shown in Fig. 1251. You want to put each customer on a different page....

Automatic Calculation Options in Excel 2007

If you’re having trouble with Excel recalculating formulas too often (or not often enough), you can modify the calculation settings to fix this problem. These changes are especially helpful...

Microsoft Excel: Measure the Accuracy of a Sales Forecast

There are several different ways that you can use to develop a sales forecast, but how do you measure how accurate that sales forecast is? Mr. Excel describes how to perform a forecast accuracy calculation...

Microsoft Excel: Add A Tooltip To A Cell

With the help of the Data Validation feature, you can add your own custom Excel tooltip to any cell in a worksheet. Read on as Mr. Excel explains how to accomplish this task with just a few easy clicks...

Microsoft Excel: Use Parentheses To Control Order Of Calculations

Problem: In what order does Excel perform calculations? Is 2+3*4 equal to 20 or 14?...

Microsoft Excel: Use A Macro To Further Customize Startup

Problem: Every time that you open a workbook, you would like to put the file in Data Form mode, as shown in Fig. 72, or to invoke any other Excel menu as the file opens....

Microsoft Excel: Save Excel Data As A Text File

Problem: You have an Excel file as shown in Fig. 86. You need to produce a file for another application to read. This application can only read .txt files....