Oct 11

MICROSOFT OFFICE TUTOR: Tired Of Blue? Give Excel 2007 A New Color Scheme

Excel 2007 gives you a lot of new visual options when it comes to building a spreadsheet. You can apply themes to your data and use new shape effects and conditional formatting looks. But what about your Excel application itself? Believe it or not, you don’t need to stick with Microsoft’s traditional blue color scheme.

To change your Excel application’s color scheme:
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
Jun 14

MICROSOFT OFFICE TUTOR: Get more versatility from AutoFill by enforcing a descending order

If you perform a lot of data entry, then you probably use Excel’s AutoFill feature to save time and fill a series in your spreadsheet. By default, the Fill handle creates a series from lowest to highest, or ascending order. But, if you want a series to extend from highest to lowest, or descending order, it’s a snap to do.
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
May 24

MICROSOFT OFFICE TUTOR: Keep your Excel operations in order

When you’re building formulas, don’t let Excel’s order of operations trip you up with inaccurate results. Table A is a list of the calculation precedence for many common operators.
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
May 03

MICROSOFT OFFICE TUTOR: Automatically open a specific workbook when you launch Excel

When you want to customize the default template that Excel uses for new workbooks, you use the template in your XLSTART folder on your hard drive. This is the template that Excel automatically opens whenever you launch the application.

Here’s another good tip: You can also use the XLSTART folder to automatically open any workbook(s) you want when Excel starts. In fact, there are two folders that Excel checks for workbooks when you start the program. If any files are found in these folders, Excel opens them.
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
Apr 12

MICROSOFT OFFICE TUTOR: Jump to another location in your Excel workbook with a mouse click

When you think of Excel worksheet hyperlinks, you probably think of website links. There’s another great use for hyperlinks in your workbook that you might not use to its full potential: internal links. You can create a hyperlink that takes you to another location within the same workbook when you click on it. This expert trick will make your Excel workbooks easier to navigate.
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!