ExecuTrain Houston

Microsoft Excel 2003
Part One

Course Length: 1 Day
Hours: 8:30 AM - 4:30 PM
Learning Method: Instructor-Led
Upcoming Dates:

Microsoft Excel 2003
Part One

Register Now

Request Information

Getting Started

LEARN YOUR WAY AROUND THE EXCEL WINDOW, THE BASICS OF CREATING AND SAVING EXCEL FILES, AND HOW TO COLOR-CODE AND REARRANGE WORKSHEETS FOR EASE OF USE.

Details:

• Become familiar with the various elements of the Excel window and their functions, including the toolbars, row and column indicators, Task Pane, sheet tabs, and more

• Gather information from other Microsoft Office applications for use in your spreadsheet.

• Access the help files in Excel using the Ask a Question box and the Help task pane to find information on how to use features you are unfamiliar with.

• Make your workbooks easier to use by color-coding and renaming your sheet tabs. You can also move, copy, insert and delete sheets.

• Create a new blank workbook, create a new workbook based on a template, how to search for and open an existing file, and how to save a workbook. You can even save an Excel workbook or part of a workbook as a Web page to make it available on the web.

Managing Data, Part I

LEARN THE BASICS OF ROWS AND COLUMNS – THE STRUCTURE THROUGH WHICH EXCEL STORES YOUR INFORMATION – AND HOW TO MANAGE THEM ONSCREEN FOR EASE OF USE.  BEGIN ENTERING INFORMATION INTO YOUR EXCEL FILE – EXPLORE TECHNIQUES FOR QUICK ENTRY, BASIC CALCULATIONS, AND KEEPING CRITICAL INFORMATION AVAILABLE AT A GLANCE.

Details:

• Excel organizes data in rows and columns. In this lesson you will learn how to select, insert and delete, and resize rows and columns. When working in long spreadsheets you may find Freeze Panes useful to keep part of your data in view while scrolling through the rest.

• In this lesson you will learn how to enter data in a cell, select cells and ranges, move and copy data, use AutoFill to copy data or enter a series of data, and how to delete data.

• Formulas allow you to develop a wide variety of data from simple addition to complex financial and statistical calculations. In this lesson you will become familiar with creating formulas using the Formula bar, AutoSum and the Insert Function dialog box.

• Ranges that you refer to often can be named to enable you to navigate to them quickly.

• If there are formulas for which you need up-to-the-minute values, the Watch Window enables you to view cell contents without having to navigate to that particular cell.

Managing Data, Part II

HAVING ENTERED YOUR DATA AND CALCULATIONS, EXPLORE A VARIETY OF TECHNIQUES FOR GIVING THEM A VISUALLY ATTRACTIVE, EASY-TO-UNDERSTAND APPEARANCE.  EASILY ARRANGE AND FILTER DATA TO DISPLAY JUST THE INFORMATION YOU NEED IN A MOMENT, AND SET UP THE FILE FOR PRINTING.

Details:

• Enhance the look of your worksheet by applying formats using the Formatting toolbar or the Format Cells dialog box.  Once you find a format you like, you can copy the format to other cells using the Format Painter. If there is a format you want applied throughout the workbook, create a style to ensure consistency.

• Use the Find feature to search your workbook for particular contents or choose Replace to edit the contents of specific contents across your workbook.

• You can sort your data by columns to quickly arrange the way your data is displayed. Use AutoFilter to easily exclude items from your view that do not meet certain criteria.

• Before you print a worksheet it is a good idea to set up pages items such as headers and footers, margins, page orientation, and page break locations.

Charts

CHARTS ALLOW YOU TO PRESENT NUMERIC INFORMATION IN AN ATTRACTIVE, EASILY EDITED, AND HIGHLY CUSTOMIZABLE GRAPHICAL FORM.  CHOOSE ONE OF EXCEL’S MANY BUILT-IN STYLES TO PRESENT YOUR INFORMATION FOR MAXIMUM IMPACT, AND DISPLAY THE IMPACT OF TRENDS OR FORECASTS ACCORDING TO DATA YOU CHOOSE.

Details:

• Modify your charts by including new data ranges, editing the labels, including a title, and adding data labels.

• Add appeal to your charts by formatting the font, color, border or pattern of different chart objects such as the axis and data series.

• Select from a wide variety of chart types to display your information in the best possible format.

• Add trendlines to your charts to display trends or forecast future results. There are a variety of trend or regression lines to choose from.

Advanced Topics: Worksheets

WHILE DATA ARE ROUTINELY STORED ON A SINGLE WORKSHEET, EXCEL DOES NOT LIMIT YOUR CALCULATIONS TO THAT SHEET.  USE A VARIETY OF METHODS TO COLLECT, CALCULATE, AND PRESENT INFORMATION FROM MANY SHEETS SIMULTANEOUSLY IN THE FORMAT YOU CHOOSE.

Details:

• Use the Fill Across Worksheets feature to quickly copy worksheet data to multiple worksheets. You can also link information between worksheets to update the copied data whenever the source data has changed.

• You can create formulas and functions that contain references to cells that are on separate worksheets or workbooks.

• The Consolidate feature enables you to summarize multiple worksheets that contain related lists into one location. You can choose to display a total of each item or use another function to calculate the data in a different way.

• Use conditional formatting to apply a specified format to only the information that meets the criteria you specify.

• There may be times when it would be nice to share data across applications. You can use the Text Import Wizard to import delimited or fixed width text files into Excel. You can save a workbook in a different format to be used in another application.