[Who is Akersoft] [Akersmart Library] [Akersoft Customers] [Why CBT]

This course teaches the student the skills that are needed to use the Excel 97 electronic spreadsheet package as an effective budgeting, planning, and projection tool in business operations. Topics include designing, creating, and modifying spreadsheets as well as report and graphical output options.

Windows 95 or equivalent skills and ability to type

This course contains 11 sections (grouped in 5 lesson units) and 1 test

Section 1 - The Control Panel, Using Lesson Help, Foundations and the Lesson Glossary, Using the Help Search Feature, Using Lesson Map Features, Using the Go To Page Feature, Section Summary

Section 2 - Starting Excel 97, Selecting Cells, Moving Between Worksheets, Using Multiple Workbooks, Scrolling in a Worksheet, Excel 97 Worksheet Dimensions, Types of Cell Entries, Date and Time Entries, Numeric Entries, Section Summary

Section 3 - Shortcut Key Help, Excel Formulas, The Freeze Panes Feature, The Excel IF Function, Creating a Worksheet, Copying and Pasting Between Worksheets, Using the Fill Handle to Create a Data Series, Entering Data in a Worksheet, Adjusting Column Width, Saving a Workbook File, Section Summary

Section 1 - Using a Pick List, Copying Formulas, Pasting Formulas, Using the Fill Handle with Formulas, Splitting the Worksheet Window, Editing and Updating Cells in a Worksheet, Cell Clearing Options, Moving a Column, Inserting and Removing Columns, Section Summary

Section 2 - Using the AutoFormat Feature, Selecting Multiple Worksheets, Adjusting a Column Width, Merging Cells, Using the Format Painter Tool, Adjusting the Title Row Height and Font, Aligning the Title and Column Headings, Shading and Borders, Grid Lines and Spell Checking, Section Summary

Section 1 - Using the AutoSum Tool, Completing the Region Totals, Finding the Product Totals, Finding Regional Percent Shares, Using an Absolute Address, Finding the Product Percent Shares, Using a Colored Font, Adding a Comment to a Worksheet Cell, Viewing the Labels, Section Summary

Section 2 - Creating an Excel Chart, Categories and Data Series, Types of Charts, Adding Data to a Chart, Using the Chart Wizard, Charting with Multiple Worksheets, Naming the Data Series, Naming the Chart and the Axes, Section Summary

Section 1 - Using the Paste Function Tool, Finding the Second Quarter Subtotals, Editing on the Formula Bar, Moving a Row in a Worksheet, Entering Cell References by Pointing, Automatic Outlining, Creating a Chart from an Outline, Adding Text to a Chart, Adding an Arrow to a Chart, Section Summary

Section 2 - Creating Subtotal Columns, Subtotals in Outlines, Finding the Beverage Grand Totals, Creating an Outline Manually, Completing the Manual Outline, Using the AutoFilter Feature, Sorting Records in a Data List, Producing Automatic Subtotals, Charting Automatic Subtotals, Section Summary

Section 1 - Finding Data Values, Searching Multiple Worksheets, Replacing Data Values, Creating an Excel 97 Macro, Running a Macro, Printing a Worksheet, Using an Excel Template, Entering Data in the Template, Using the Goal Seek Feature, Section Summary

Section 2 - Naming a Cell, Using Column Headers as Names, Copying a Worksheet, Using 3-D Formulas to Consolidate Worksheets, Finding the Other Annual Totals, Changing a Value in a Supporting Worksheet, Using the Consolidate Command, Adding the Other References, Protecting a Worksheet, Section Summary

Test - Comprehensive final exam

[Who is Akersoft] [Akersmart Library] [Akersoft Customers] [Why CBT]

To find out more about Akersoft's educational products, please contact Akersoft at: