Duration: 4 days

Fee: US$ 173.00

Full Course Outline

Prerequisites: Windows 95 or equivalent knowledge

Accomplishing Basic Tasks

v        Working in the Excel environment

· Rearranging a worksheet by moving and copying cells

· Creating a form to enter data easily

v        Setting up a worksheet

· Building a Template

· Adding a graphic to a worksheet

v        Writing formulas

· Calculation formulas

· Calculating a specific cost

v        Formatting your worksheet for a professional look

· Formatting cells

· Saving your workbook as a template to re-use it easily

· Editing the template

Organizing and Summarizing Your Data

v        Consolidating multiple lists

· Consolidating data from several worksheets

· Using a built-in template to automate data collection

· Adding employee names to the expense statement template

v        Filtering to find specific information

· Calculating filtered sets of records

· Summing up a set of records without filtering

v        Sorting and subtotaling to organize your data

· Summarizing data with subtotals

· Pasting a subtotaled summary into a Microsoft Word document

Presenting Your Data to Others

v        Creating pivot tables to summaries data

· Getting external data into a workbook

· Modifying the data display in a PivotTable

· Creating page reports for distribution to individuals

v        Charting to assess trends and relationships

· Presenting data graphically with charts

· Forecasting trends

· Creating a chart with a secondary axis

v        Printing reports to distribute information offline

· Printing charts

· Setting multiple print areas in a worksheet