.gif)
Course 4101: Advanced Training for Microsoft Office Excel 2003 by Microsoft
Course Description
This course provides an overview of the advanced capabilities of Microsoft® Office Excel 2003, including the following: working with Excel and other Office programs, organizing data, performing calculations on data, analyzing data, working with pivot tables, working with graphics and charts, working with database data and macros, publishing on the Web and using XML, and collaborating in Excel.
This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.
This course is 5 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
Advanced Training for Microsoft Office Excel 2003
Pre-Assessment
Pre-Assessment
Working with Excel and Other Office Programs
Lesson Introduction
Creating a Template from an Existing Worksheet
Modifying Workbook Settings
Using Custom Data Formats
Sharing Data Between Excel and Other Office Programs
Organizing Data
Lesson Introduction
Limiting the Data That Appears on the Screen
Performing Calculations on Filtered Data
Validating Data
Changing Data Appearance Based on Value
Summarizing and Grouping Multiple Sets of Data
Performing Calculations on Data
Lesson Introduction
Naming Cell Ranges
Creating Formulas to Calculate Values
Finding and Correcting Errors in Calculations
Analyzing Data
Lesson Introduction
Defining and Editing Alternative Data Sets
Defining Multiple Alternative Data Sets
Working with Goal Seek and Solver
Analyzing Data with Descriptive Statistics
Working with PivotTables
Lesson Introduction
Creating and Using PivotTables
Editing PivotTables
Creating PivotTables from External Data
Working with Graphics and Charts
Lesson Introduction
Formatting and Resizing Graphics
Creating a Chart
Creating a Dynamic Chart Using PivotCharts
Working with Database Data and Macros
Lesson Introduction
Locating and Retrieving Data from a Database
Summarizing List Data
Introducing Macros
Creating and Modifying Macros
Publishing on the Web and Using XML
Lesson Introduction
Converting an Excel Workbook to XML
Using XML Data Capabilities and Retrieving Web Data
Publishing Worksheets and PivotTables on the Web
Collaborating in Excel
Lesson Introduction
Sharing and Comparing Workbooks
Managing Comments
Tracking and Managing Changes
Protecting Workbooks and Worksheets
Post Assessment
Post Assessment
Reference and Glossary
Quick Reference
Glossary
Course Details
Course Length: 5 hours
Course 6789: Analyzing Data and Working with Macros in Microsoft Office Excel 2007 by Microsoft
Course Description
This one-hour online course provides you with the skills and knowledge required to use the features of Microsoft Office Excel 2007 to analyze data and work with macros. Excel 2007 provides analysis tools that help you perform complex analysis. Excel 2007 also includes the macro feature that helps run frequently-performed steps by using a few clicks.
Student prerequisites:
* Students must have basic skills of using Excel 2007.
* These include basic tasks such as working with data, formatting data, using formulas, using tables etc.
* In addition it will be helpful if students have gone through the collection 5259 "Core Training for Microsoft Excel 2007" or possess equivalent skills.
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
You will need Excel 2007 installed on your machine to use some of the local labs in this course.
Analyzing Data and Working with Macros in Excel 2007
Module Overview
Analyzing Data
Using Macros
Lab: Analyzing Data and Working with Macros in Excel 2007
Module Summary
Glossary
Course Details
Course Length: 1 hour
