Excel Training

Microsoft Excel is the premier software application for creating, editing and sharing spreadsheets, with countless practical applications, from financial reporting and general record keeping to operations management and decision support. As a part of this Microsoft Excel 2007 training, you will create an Excel spreadsheet, use it track several types of data, use Excel to perform calculations on spreadsheet data, and generate professional, presentation-ready graphs and charts that show statistics, trends, and forecasts. This one-day Excel class emphasizes practical exercises and real-world examples, so that you will leave training ready to apply your new knowledge right away.

Navigating Spreadsheets with Confidence and Speed

Understand spreadsheet terminology, including worksheets, workbooks, columns, rows and cells.
Work efficiently with Excel's tool ribbons, gallery commands, and Live Preview feature.
Master shortcuts to quickly navigate through multiple pages of data.

Entering and Editing Text and Formulas

Use AutoFill to complete the entry of sequential data with a minimum of errors.
Perform basic calculations and use cell references to apply calculations accurately.
Understand and use cell references to apply calculations accurately throughout a spreadsheet.
Search for specific data and replace data selectively or globally.

Formatting Cells and Tables For Clarity and Visual Impact

Use styles and style galleries to quickly format cells, tables and entire worksheets.
Apply conditional formatting rules to visually enhance your data.
Automatically display numbers as percentages, currencies, fractions, dates or in the format of your choice.

Printing Spreadsheet Data for Professional Appearance

Avoid multiple printing attempts by adjusting margins and sizing in Page Layout View.
Control page breaking and print options to print the desired number of pages.
Define the print area to exclude unwanted data from your printout.

Creating Professional-Looking Charts

Create dynamically-updating charts quickly with predefined layouts and styles.
Modify chart components manually to graphically display information, to meet your specific requirements.
Easily change chart types, without modifying the data.
Use visual effects to design compelling graphic summaries and accentuate key data.

Managing and Navigating Large Workbooks

Freeze row and column headings in place so that they will always appear when scrolling.
Divide a larger worksheet into smaller, more manageable panes.
Hide columns and rows, as needed, to emphasize key data.
Define page breaks at logical points in your spreadsheet.

Prerequisites:

Basic familiarity with Microsoft Windows

Excel training is offered at four locations::

* Note: This class description is for Excel 2007 training, click here for Excel 2003 training.

Excel 2007 Intro Training