Excel 2003 Intro Training

Our AcademyX instructors will show you just how easy it is to enter, track, and present numerical, financial, and even text data. You will learn how to calculate values and automatically populate fields. And you will leave this introductory Excel training course with the ability to generate professional, presentation-ready graphs and charts that show statistics, trends, and forecasts.

Getting Started with Microsoft Excel 2003

We'll begin with the basics: Exploring the Excel user interface and making sure you understand Excel terminology like workbooks, worksheets, rows, and columns. This section of the course covers how to:

• Find your way in the Excel 2003 user interface
• Put your favorite commands on personalized menus and toolbars
• Open and manage Excel workbooks (spreadsheets)
• Benefit from Excel's optional task panes
• Enable and disable smart tag actions

Entering Data into Excel 2003

This section of the course covers how to get your data into Excel and manipulate it. You will learn how to efficiently organize and enter large amounts of information, and we'll show you tips and strategies for setting up worksheets and editing data. In this part of the Excel intro training, you will learn how to:

• Select a range of cells on which to work
• Create a new blank workbook
• Use built-in templates to automate common documents like invoices or purchase orders
• Enter your numbers as "constant" values (as opposed to "calculated" values)
• Make changes to cell contents

Using Excel Formulas

Excel formulas are calculations that you build from constant values and cell addresses to help you analyze worksheet data, saving you hours of manual calculation. In this key section of the course, you will get hands-on experience with how to:

• Automatically add all the numbers in a specific column or row
• Choose from Excel's built-in statistical formulas, such as Average, Min, and Max
• Rapidly copy, move, and paste values and formulas
• Save time and reduce errors with the indispensable AutoFill feature
• Apply "absolute" and "relative" cell references in formulas

Formatting Worksheets with Excel

In this unit, we'll teach you how to use Excel's formatting features to improve the readability of your data. Effective formatting can make your workbooks easier to use, and easier for stakeholders to understand. During this part of the Excel training class, you will find out how to:

• Automatically format numbers as currency, percentages, and many more
• Set a consistent number of decimal places for cells
• Set up text fonts and styles to make certain rows or columns stand out
• Similarly, add, remove, or reformat cell borders to highlight data
• Adjust cell sizes or merge cells to accommodate cell content
• Apply built-in color themes with the AutoFormat too

Modifying Columns & Rows in Excel 2003

Excel makes it easy to deal with even large amounts of data. In this section, the focus is on arranging and presenting your data most efficiently and effectively. Our instructors will show you how to:

• Change column width and row height manually or automatically - for any number of columns and rows in the spreadsheet
• Using the AutoFit feature to automatically fit columns and rows to the values in the cells
• Quickly insert and delete columns and rows
• Use the hide and unhide command to view just the data you need
• Customize your spreadsheet view and save it for future viewing and printing

Editing Workbooks with Excel

Excel is not just for numbers! Your spreadsheets will also contain text, for example, item descriptions, lists of client names and addresses, and category or group descriptions. In this part of the training, we will look at tools to manage text data and reduce text errors. In this section of the training, you'll learn how to:

• Enable AutoCorrect to highlight errors as you type
• Use Excel's spell-check tools
• Find and Replace any value in a single cell, a range of cells, or the entire spreadsheet

Printing Worksheets in Excel 2003

The Excel training course ends with guidelines for setting up effective printouts. This can be tricky for large spreadsheets, which may not fit on paper as expected, with data cut off at inconvenient points. We'll show you how to prevent this from happening and get perfect printouts every time. You will learn the secrets of how to:

• Preview spreadsheets and see where page breaks land before sending data to the printer
• Adjust margins and column widths in print preview mode to prevent data being cut off
• Use page setup tools
• Organize your printed sheets with helpful headers and footers

Creating Charts with Excel

A chart can instantly convey the meaning of a series of numbers and add impact to your presentations. Excel offers simple yet powerful features to quickly draw bar, pie, linear, and other types of charts based on data in your spreadsheets. In this section we show you how to:

• Determine the type of chart appropriate for your data
• Create charts based on selections of data in your worksheet
• Change the type of chart from one format to another while working with the same data
• Apply styles and formatting changes

Prerequisites:

• Basic familiarity with Microsoft Windows

Excel 2003 training is offered at four locations::

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