MCS

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.

In Windows, your Word, Excel and PowerPoint documents save to the My Documents folder by default. However, if you save your documents to a folder on the network or another location, you always have to navigate to another location every time you need to save a 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

Excel Formulas & Functions are covered in these Excel classes:

Basic
Intermediate
Advanced
Formulas & Functions
Managing [...]

Transposing Data allows you to re-arrange rows into columns or vice versa- basically interchanging the two.

Learn to group columns together to easily contract and expand your worksheet in Microsoft Excel

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

How do I link my Microsoft Excel worksheets in my PowerPoint presentations. Can they automatically update my figures.

Fractions are easy to use in Microsoft Excel. With a couple of clicks you can transform your decimal places to fractions. Learn more with this quick tip.