MCS

We just started the Colorado Excel Users Group. Join us in Twitter, Facebook, Linkedin, or Google Groups for Tips and Tricks on Microsoft Excel. Everyone is welcome, from Power users to novices. Join now!

Learn how to format text in Word, Excel and PowerPoint 2007 using the Mini Toolbar.

When you have a document that spans multiple pages, you might want your column titles/headers to be repeated on each page.

You can change the direction of text in a cell so that it better fits in a cell or stands out more. This includes changing the degree of its angle.

There are more functions available in Excel than you could cover in 5 Excel classes. However, Excel provides a list of all available functions with links to their uses and examples.

Copy Excel Formulas

How to use If Statements in Microsoft Excel.

If you simply copy and paste an Excel chart into a PowerPoint presentation, you are copying not only the chart, but the entire Excel workbook, which creates a security concern, and also increases the size of the PowerPoint file.

Unlike other Microsoft programs such as Word, Excel does not have a button to automatically number data. However, you can easily number your data by using the fill handle to fill a series.

You can create a quick formula that will always calculate the current date on your spreadsheet each time you open it up.

Select a cell
Type the following formula: =Today()
Press Enter
Now that cell will always display the current date and can be referenced in other formulas