Excel 2007 Intro Training

Whether you are new to spreadsheets or just want to stay up-to-date with the latest version of Excel, our Introductory Excel training class will give you all the practice and tips you need to make the most of this versatile application. After completing this class, you'll be the expert who can take confusing data and present it in a way that decision makers appreciate and understand.

With Excel training, you'll learn how to:

Getting Started with Microsoft Excel 2007

We'll get you up and running quickly with spreadsheets in this first section of the Excel training course. You'll discover the easiest way to:

• Work efficiently with Excel's unique tool ribbons, gallery commands, and Live Preview feature
• Open Excel spreadsheets and navigate through multiple pages of data

Entering & Editing Data with Excel

Now that you know your way around the Excel workspace, you can start entering data. With our hands-on exercises, you'll practice entering numbers, text and even graphics in your spreadsheet, adding color and style using Excel's extensive set of formatting tools. This part of the AcademyX Excel training will teach you how to:

• Enter and edit text, values and formulas of any length
• Save time and prevent errors by using AutoFill to complete the entry of sequential data
• Choose and insert formulas to perform calculations on groups of cells
• Save spreadsheets in various formats so your data can be imported into other programs

Modifying a Excel Worksheet

In this part of the Excel training class, you'll master organizing your data into Excel workbook and worksheets. Each workbook displays data in a logical group of worksheets, such as a balance sheet, a cash flow statement and an income statement. After this part of the course, you'll know how to:

• Move and copy data and formulas from cells within your spreadsheet or from other spreadsheets
• "Drag and drop" data into your spreadsheet from one or more cells or from your Office Clipboard
• Populate cells automatically with the fill handle tool

Utilizing Functions in Excel 2007

Excel can save you hours of work by automating formulas for every type of data analysis. We'll teach you the ins and outs of formulas, including how to:

• Use predefined formulas, called functions, such as the SUM function
• Avoid common errors when working with formulas
• Apply the AutoSum, AVERAGE, MIN, MAX, COUNT and COUNTA functions to speed up your work

Formatting Excel Worksheets

Well laid-out spreadsheets can make the difference between data confusion and data clarity. Excel 2007 equips you with a full battery of tools to attractively format your spreadsheet's cells and values. You can even save your favorite styles for future use. In this part of the Excel training class, you will learn how to:

• Attractively format your cells and their values, using highlighting color, and style
• Align data within a cell and apply, edit and remove cell borders
• Format numbers with decimals or as percentages, currencies, fractions or dates
• Quickly find and replace spreadsheet data

Printing Excel spreadsheets

No office is 100 percent paperless, and many managers will want to see printouts of your spreadsheets. In our training class, you learn how to stop wasting reams of paper by printing out just the portion of the spreadsheet you want.

• Preview a spreadsheet to correct errors before printing
• Find and replace values and text whenever they appear ? with one command
• Define the print area to exclude unwanted data from your printout

Creating Charts with Excel

If a picture is worth a thousand words, how much data is a chart worth? Charts, tables and graphs make data relationships more understandable. With Excel, you get some eye-catching chart options to bring those rows and columns to life in a user-friendly format. In this section you'll learn how to:

• Create charts based on any range of figures entered
• Embed dynamically updating charts into your workbook
• Change chart types without touching your data
• Apply quick styles and layouts to reformat charts

Managing Large Workbooks in Excel

If your spreadsheet is longer than one page, it's easy to get lost in the numbers. MS Excel 2007 has an array of features to simplify and streamline large sets of data. In this final section of AcademyX's Excel training course you will explore how to:

• "Freeze" row and column headings in place so that they will always appear when scrolling
• Split up a larger worksheet into smaller, more manageable panes
• Hide and unhide columns and rows to focus your data
• Define page breaks at logical points in your spreadsheet

Prerequisites:

• Basic familiarity with Microsoft Windows

Excel training is offered at four locations::

• Excel training San Francisco
  
• Excel training Los Angeles
  
• Excel training San Jose
• Excel training Sacramento