Blogroll
Use headers and footers in worksheet printouts
Learn how to add headers or footers, including page numbers, or the date and time, at the top or bottom of a printed worksheet.
Categories: Microsoft
Print row and column headings on every printed page
Include column headings (A, B, C, etc.) or row headings (1, 2, 3, etc.) on your printed pages.
Categories: Microsoft
Repeat specific rows or columns on every printed page
Help ensure that the data in your worksheet is properly labeled by including row and column headings or labels on every page.
Categories: Microsoft
Change the placement of titles in a chart
Are your chart titles causing spacing problems? Learn how to quickly change their placement.
Categories: Microsoft
Vary the colors of same-series data markers in a chart
Learn how to automatically vary the colors for data markers in a chart.
Categories: Microsoft
Calculate a running total
Want to see the number of items in a worksheet grow as you add new items? This article shows you how.
Categories: Microsoft
What happened to my favorite charting features?
Not sure what happened to some of your favorite charting features? Here's a handy table that explains the changes between Excel 2007 and Excel 97-2003.
Categories: Microsoft
Math Basics: Percentages Explained
Need a refresher on how precentages work? Check out this explanation.
Categories: Microsoft
Add or subtract units of time
Read this article to learn about calculating the total amount of time that a set of tasks will take.
Categories: Microsoft
Protect or audit formulas
Learn how to help protect your formulas by hiding them from your users.
Categories: Microsoft
Editing Data Series
Did you know that the SetSourceData method of the Chart object is the quickest way to define a completely new set of data for a chart? Read this excerpt to learn more.
Categories: Microsoft
Primer in Excel VBA
In this book excerpt, learn the basics of Excel VBA, including an introduction to the Excel macro recorder.
Categories: Microsoft
Sprucing Up Excel Data with Access Reports
Take your report building beyond the limits of Excel by using some amazing reporting features in Access 2007.
Categories: Microsoft
Change how rows and columns of data are plotted in a chart
Find out how to quickly change the way that data is plotted in your charts.
Categories: Microsoft
Make a worksheet fit the printed page
Use the Scale to Fit options to reduce the size of your worksheets so that they better fit the printed page.
Categories: Microsoft
Replace a formula with its results
Improve the performance of your workbook by replacing formulas with their results.
Categories: Microsoft
Calculate values in a PivotTable report
Learn about the different calculation methods that are available in PivotTable and PivotChart reports.
Categories: Microsoft
Microsoft Excel Tips
Visit this blog to learn about a few tips and tricks for using Excel 2007.
Categories: Microsoft
