This course introduces the basic features and tools of Microsoft® Office Excel 2003, including the following: getting to know Excel, setting up a workbook, performing calculations on data, changing document appearance, filtering and reordering data, combining data from multiple sources, creating charts, printing, and collaborating in Excel.
This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.
This course is 4 hours long.
System Requirements:
Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Flash Player 7.0 or higher;
Speakers and soundcard.
Subscription: 1 year
Modules & Lessons
Core Training for Microsoft® Office Excel 2003
Pre-Assessment
Pre-Assessment
Getting to Know Excel
Lesson Introduction
Introducing Excel
Saving Changes to an Existing Workbook
Organizing Data
Creating and Using Lists
Creating a Workbook
Checking and Correcting Data
Setting Up a Workbook
Lesson Introduction
Making Workbooks Easier to Work With
Making Data Easier to Read
Adding a Graphic to a Worksheet
Managing Comments
Naming Groups of Data
Performing Calculations on Data
Lesson Introduction
Creating Formulas to Calculate Values
Finding and Correcting Errors in Calculations
Rounding Results in Statistical Functions
Changing Document Appearance
Lesson Introduction
Changing the Appearance of Data
Applying Styles and Formats to Data
Making Numbers Easier to Read
Making Printed Worksheets Easier to Read
Positioning Data on a Printed Page
Filtering and Reordering Data
Lesson Introduction
Limiting the Data That Appears on the Screen
Sorting a Data List
Organizing Data into Groups
Combining Data from Multiple Sources
Lesson Introduction
Creating a Template from an Existing Worksheet
Working with More Than One Set of Data
Linking Data to Other Workbooks
Grouping Multiple Workbooks
Creating Charts
Lesson Introduction
Creating a Chart
Customizing Chart Labels and Numbers
Creating Diagrams
Printing
Lesson Introduction
Printing Worksheets
Printing Part of a Worksheet
Printing a Chart
Collaborating in Excel
Lesson Introduction
Saving a Workbook for the Web
Comparing Workbooks
Using Smart Tags to Acquire Real-Time Data
Post Assessment
Post Assessment
Reference and Glossary
Quick Reference
Glossary
|