Microsoft excel XP Training - Microsoft Excel 2002 training

Profile
Login
Catalog

Search
Contact
Cart

Microsoft Excel XP (Beg and Adv.)

MSACCESS

English

Audience Details:

16

Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel. End-users seeking proficiency in the use of Microsoft Excel 2002 at an advanced level; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in Microsoft Excel 2002 at Expert level

This learning path introduces the learner to the basic features and tools of Microsoft® Excel 2002. It introduces these application features and guides the user through the use of spreadsheet workbooks, formulas, charts, and reports. It also provides an introduction to the web-enabled features of Excel 2002.This learning path also provides an overview of the advanced capabilities of Microsoft Excel 2002. It presents the user with the opportunity to learn about Excel s advanced data management and analysis features. In addition, it demonstrates the application s rich data manipulation solutions.

After learning this courses you should be able to:

To provide an overview of the basic features of Excel 2002
To provide an overview of the calculation, chart-creation, and web-enabled features in Excel 2002
To provide an overview of the advanced data management and organization features in Excel 2002
To provide an overview of the advanced data manipulation and analysis features in Excel 2002

Hands on pratice - Simulations

Course Structure: Unit Titles and Topics Covered

Getting started with Excel 2002
Introducing Excel 2002
Entering and modifying data in Excel 2002
Copying and moving data in Excel 2002
Working with data in Excel 2002
Saving work in Excel 2002
Saving a workbook in Excel 2002
Formatting worksheets in Excel 2002
Working with styles and text in Excel 2002
Formatting rows and columns in Excel 2002
Formatting numbers in Excel 2002
Formatting cells and columns in Excel 2002
Adding and modifying worksheets in Excel 2002
Adding a worksheet in Excel 2002
Working with worksheets in Excel 2002
Page setup and printing in Excel 2002
Editing and previewing a worksheet in Excel 2002
Page Setup options in Excel 2002
Printing options in Excel 2002
Changing worksheet setup in Excel 2002
Working with formulas in Excel 2002
Creating and editing formulas in Excel 2002
Creating a formula in Excel 2002
References and names in Excel 2002
Entering a formula with references in Excel 2002
Working with functions in Excel 2002
Basic functions in Excel 2002
The Insert Function feature in Excel 2002
Creating a function in Excel 2002
Logical, financial, and date functions in Excel 2002
Inserting a financial function in Excel 2002
Charts and objects in Excel 2002
Using charts in Excel 2002
Creating a chart in Excel 2002
Editing charts and chart data in Excel 2002
Changing chart data series in Excel 2002
Working with lines and objects in Excel 2002
Inserting a picture in Excel 2002
Working with pie charts in Excel 2002
Web-enabled features of Excel 2002
Creating an HTML spreadsheet in Excel 2002
Hyperlinks and web queries in Excel 2002
Adding a hyperlink in Excel 2002
E-mailing attachments in Excel 2002
E-mailing a workbook in Excel 2002
Working with HTML worksheets in Excel 2002
Advanced editing and customization in Excel 2002
Working with templates in Excel 2002
Creating a template in Excel 2002
Working with smart tags in Excel 2002
Using styles in Excel 2002
Creating a style in Excel 2002
Advanced printing in Excel 2002
Working with templates in Excel 2002
Advanced formatting in Excel 2002
Custom number formats in Excel 2002
Using advanced number formats in Excel 2002
Conditional formatting in Excel 2002
Creating and copying conditional formats in Excel 2002
Organizing data in Excel 2002
Sorting and filtering data in Excel 2002
Data subtotaling in Excel 2002
Sorting, filtering, and subtotaling data in Excel 2002
Grouping and outlining data in Excel 2002
The Excel 2002 LOOKUP function
Using the HLOOKUP function in Excel 2002
Using the data form in Excel 2002
Advanced functions in Excel 2002
Linking and sharing data in Excel 2002
Creating links in Excel 2002
Linking a workbook in Excel 2002
Shared workbooks in Excel 2002
Merging a workbook in Excel 2002
Auditing and protecting data in Excel 2002
Validating data in Excel 2002
Using data validation in Excel 2002
Auditing tools in Excel 2002
Tracking changes in Excel 2002
Data protection in Excel 2002
Protecting a worksheet in Excel 2002
Working with macros in Excel 2002
Using macros in Excel 2002
Recording and running a macro in Excel 2002
Editing and deleting macros in Excel 2002
Editing a macro in Excel 2002
Using macros with command buttons in Excel 2002
Creating and modifying macros in Excel 2002
Importing and exporting data in Excel 2002
Importing data in Excel 2002
Importing data from the Web into Excel 2002
Importing an HTML table into Excel 2002
Exporting Excel 2002 data to other applications
Exporting Excel 2002 data to the Web
Working with PivotTable and PivotChart reports
PivotTable reports in Excel 2002
Creating a PivotTable report in Excel 2002
PivotTable calculations in Excel 2002
Performing PivotTable calculations in Excel 2002
Publishing Excel 2002 PivotTable reports to the Web
PivotChart reports in Excel 2002
Using Excel 2002 data-analysis tools
Working with Goal Seek and Solver in Excel 2002
Using Solver in Excel 2002
Working with scenarios in Excel 2002
Creating a scenario in Excel 2002
Working with data tables in Excel 2002

Curriculum Info:

Microsoft Curriculum

Personal Use License Price $199.00

Contact your Eno Learning Consultant or call 888-742-3214 to order. For organizational purchases, please contact the sales office nearest you.

Available Online, Interactive CDs, Network

	Microsoft Excel XP (Beg and Adv.)
	MSACCESS
	English

Audience Details:
	16
	Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
	Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel. End-users seeking proficiency in the use of Microsoft Excel 2002 at an advanced level; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in Microsoft Excel 2002 at Expert level
	This learning path introduces the learner to the basic features and tools of Microsoft® Excel 2002. It introduces these application features and guides the user through the use of spreadsheet workbooks, formulas, charts, and reports. It also provides an introduction to the web-enabled features of Excel 2002.This learning path also provides an overview of the advanced capabilities of Microsoft Excel 2002. It presents the user with the opportunity to learn about Excel s advanced data management and analysis features. In addition, it demonstrates the application s rich data manipulation solutions.
	After learning this courses you should be able to:
	To provide an overview of the basic features of Excel 2002 To provide an overview of the calculation, chart-creation, and web-enabled features in Excel 2002 To provide an overview of the advanced data management and organization features in Excel 2002 To provide an overview of the advanced data manipulation and analysis features in Excel 2002
	Hands on pratice - Simulations

Course Structure:	Unit Titles and Topics Covered
	Getting started with Excel 2002 Introducing Excel 2002 Entering and modifying data in Excel 2002 Copying and moving data in Excel 2002 Working with data in Excel 2002 Saving work in Excel 2002 Saving a workbook in Excel 2002 Formatting worksheets in Excel 2002 Working with styles and text in Excel 2002 Formatting rows and columns in Excel 2002 Formatting numbers in Excel 2002 Formatting cells and columns in Excel 2002 Adding and modifying worksheets in Excel 2002 Adding a worksheet in Excel 2002 Working with worksheets in Excel 2002 Page setup and printing in Excel 2002 Editing and previewing a worksheet in Excel 2002 Page Setup options in Excel 2002 Printing options in Excel 2002 Changing worksheet setup in Excel 2002 Working with formulas in Excel 2002 Creating and editing formulas in Excel 2002 Creating a formula in Excel 2002 References and names in Excel 2002 Entering a formula with references in Excel 2002 Working with functions in Excel 2002 Basic functions in Excel 2002 The Insert Function feature in Excel 2002 Creating a function in Excel 2002 Logical, financial, and date functions in Excel 2002 Inserting a financial function in Excel 2002 Charts and objects in Excel 2002 Using charts in Excel 2002 Creating a chart in Excel 2002 Editing charts and chart data in Excel 2002 Changing chart data series in Excel 2002 Working with lines and objects in Excel 2002 Inserting a picture in Excel 2002 Working with pie charts in Excel 2002 Web-enabled features of Excel 2002 Creating an HTML spreadsheet in Excel 2002 Hyperlinks and web queries in Excel 2002 Adding a hyperlink in Excel 2002 E-mailing attachments in Excel 2002 E-mailing a workbook in Excel 2002 Working with HTML worksheets in Excel 2002 Advanced editing and customization in Excel 2002 Working with templates in Excel 2002 Creating a template in Excel 2002 Working with smart tags in Excel 2002 Using styles in Excel 2002 Creating a style in Excel 2002 Advanced printing in Excel 2002 Working with templates in Excel 2002 Advanced formatting in Excel 2002 Custom number formats in Excel 2002 Using advanced number formats in Excel 2002 Conditional formatting in Excel 2002 Creating and copying conditional formats in Excel 2002 Organizing data in Excel 2002 Sorting and filtering data in Excel 2002 Data subtotaling in Excel 2002 Sorting, filtering, and subtotaling data in Excel 2002 Grouping and outlining data in Excel 2002 The Excel 2002 LOOKUP function Using the HLOOKUP function in Excel 2002 Using the data form in Excel 2002 Advanced functions in Excel 2002 Linking and sharing data in Excel 2002 Creating links in Excel 2002 Linking a workbook in Excel 2002 Shared workbooks in Excel 2002 Merging a workbook in Excel 2002 Auditing and protecting data in Excel 2002 Validating data in Excel 2002 Using data validation in Excel 2002 Auditing tools in Excel 2002 Tracking changes in Excel 2002 Data protection in Excel 2002 Protecting a worksheet in Excel 2002 Working with macros in Excel 2002 Using macros in Excel 2002 Recording and running a macro in Excel 2002 Editing and deleting macros in Excel 2002 Editing a macro in Excel 2002 Using macros with command buttons in Excel 2002 Creating and modifying macros in Excel 2002 Importing and exporting data in Excel 2002 Importing data in Excel 2002 Importing data from the Web into Excel 2002 Importing an HTML table into Excel 2002 Exporting Excel 2002 data to other applications Exporting Excel 2002 data to the Web Working with PivotTable and PivotChart reports PivotTable reports in Excel 2002 Creating a PivotTable report in Excel 2002 PivotTable calculations in Excel 2002 Performing PivotTable calculations in Excel 2002 Publishing Excel 2002 PivotTable reports to the Web PivotChart reports in Excel 2002 Using Excel 2002 data-analysis tools Working with Goal Seek and Solver in Excel 2002 Using Solver in Excel 2002 Working with scenarios in Excel 2002 Creating a scenario in Excel 2002 Working with data tables in Excel 2002
Curriculum Info:
	Microsoft Curriculum
	Personal Use License Price $199.00
	Contact your Eno Learning Consultant or call 888-742-3214 to order. For organizational purchases, please contact the sales office nearest you. Available Online, Interactive CDs, Network