MCS

Learn how to create a printed report using multiple worksheets and have it be print ready.

Sparklines are a new feature in Microsoft Excel 2010 that allow you to create mini-charts that can be directly put inline with your data to better visually convey the data you are tryint to display in a table.

Have you ever needed to delete every 3rd, 5th, or say 9th row in a worksheet? This often happens if you import data from other applications. You can do so without the use of macros by using this handy trick using the Mod statement and AutoFilter.

If you have an Excel file that contains formulas, formatting, layouts, etc. that you use often, then saving it as an Excel template may help save you time. It becomes a model for other spreadsheets.

The F5 key is a great shortcut key in many of the Office programs for everything from navigating, inserting named ranges into formula, and starting a slide show.

You can more easily track how a formula is calculated by using the Trace Precedents or Trace Dependents options

Excel Printing can be very challanging. Orientation, print area, and scaling will help fit Excel spreadsheets on one page.

When you want to copy or format columns and rows of data, do you find yourself dragging the cursor across columns and down rows to select them?

Learn how to hit a single key to repeat the last thing you did again and again as many times as you want.

Use Named Ranges in Excel to quickly jump to different locations in different spreadsheets.