Excel 2007

Syndicate content
Get Help and How-to information about Office Excel 2007 with RSS on Office Online
Updated: 9 years 12 weeks ago

Use headers and footers in worksheet printouts

Wed, 01/21/2015 - 08:42
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

Wed, 01/21/2015 - 08:42
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

Wed, 01/21/2015 - 08:42
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

Wed, 01/21/2015 - 08:42
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

Wed, 01/21/2015 - 08:42
Learn how to automatically vary the colors for data markers in a chart.
Categories: Microsoft

Calculate a running total

Wed, 01/21/2015 - 08:42
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?

Wed, 01/21/2015 - 08:42
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

Wed, 01/21/2015 - 08:42
Need a refresher on how precentages work? Check out this explanation.
Categories: Microsoft

Add or subtract units of time

Wed, 01/21/2015 - 08:42
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

Wed, 01/21/2015 - 08:42
Learn how to help protect your formulas by hiding them from your users.
Categories: Microsoft

Editing Data Series

Wed, 01/21/2015 - 08:42
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

Wed, 01/21/2015 - 08:42
In this book excerpt, learn the basics of Excel VBA, including an introduction to the Excel macro recorder.
Categories: Microsoft

Chart Labels

Wed, 01/21/2015 - 08:42
In this book excerpt, learn how easy it is to add chart labels.
Categories: Microsoft

Sprucing Up Excel Data with Access Reports

Wed, 01/21/2015 - 08:42
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

Wed, 01/21/2015 - 08:42
Find out how to quickly change the way that data is plotted in your charts.
Categories: Microsoft

Make a worksheet fit the printed page

Wed, 01/21/2015 - 08:42
Use the Scale to Fit options to reduce the size of your worksheets so that they better fit the printed page.
Categories: Microsoft

RibbonX

Wed, 01/21/2015 - 08:42
Read this book excerpt to learn how to customize the Ribbon in Excel.
Categories: Microsoft

Replace a formula with its results

Wed, 01/21/2015 - 08:42
Improve the performance of your workbook by replacing formulas with their results.
Categories: Microsoft

Calculate values in a PivotTable report

Wed, 01/21/2015 - 08:42
Learn about the different calculation methods that are available in PivotTable and PivotChart reports.
Categories: Microsoft

Microsoft Excel Tips

Wed, 01/21/2015 - 08:42
Visit this blog to learn about a few tips and tricks for using Excel 2007.
Categories: Microsoft

eXTReMe Tracker