Microsoft Excel Training - Texas Web Hosting, Web Design Texas, Search Engine Ranking

MICROSOFT OFFICE®
Excel

The courses as outlined are designed by modules,
two modules equal a level.
Each level is taught in a 4 hour training course for $175.00
plus the cost of the Training Manual $22.50 (optional)

Basic - Intermediate - Advanced

INTRODUCTION TO MICROSOFT EXCEL 2002

PARTICIPANTS
Introduction to Microsoft Excel 2002 is designed for people who have prior experience with Microsoft Windows 98 or XP and are involved with the production of spreadsheets.

PREREQUISITES
Students must have completed Introduction to Microsoft Windows 98 or Microsoft Windows XP.

OBJECTIVES
Students will develop a thorough understanding of the Excel environment and spreadsheet concepts. Specific objectives are listed below and at the beginning of each chapter of the workbook. Hands-on exercises test the students’ mastery of the topics at the end of each chapter.

STRUCTURE
The course is presented through a combination of instructor-led lectures and hands-on exercises, aided by a step-by-step workbook and an exercise disk. Sample data files are provided on the exercise disk so students spend less time typing and more time learning.

OUTLINE

Getting Started
- Starting Excel
- Elements of Excel’s Windows, Worksheets, and Workbooks
- Executing Excel Commands
- Using Toolbars and Menus
- Working with Worksheets and Workbooks
- Exiting Excel
Creating a Workbook
- Working with Multiple Workbooks
- Moving the Cell Marker using the Mouse and
   Keyboard
- Entering Labels, Data, Formulas, Cell   Addresses, Dates, and Times in Worksheets
- Opening and Saving Workbooks from and in
   Specific Folders
- Closing All Workbooks
Editing Worksheets
- Editing and Replacing Cell Contents
- Selecting Cells, Rows, Columns, and Ranges
- Clearing Cell and Range Contents
- Undoing Actions
- Redoing Undone Actions
- Copying and Moving Data and Objects in Cells and Ranges
- Using the Office Clipboard for Multiple Copies
- Using Excel’s Fill Commands
- Using AutoFill

Working with Formulas and Functions
- Understanding Formulas and Functions
- Understanding Operators and Operations
- Understanding Relative, Absolute, Mixed, and Quick Cell Referencing
- Correcting Circular Referencing
- Using the Paste Function Button
- Using Range Names in Formulas
Changing Worksheet Appearance
- Cell Font, Alignment, and Number Formatting
- Adding Borders and Patterns
- Using AutoFormat and the Format Painter
- Adjusting Row Height and Column Width
- Using AutoFit
- Using Conditional Formatting
- Using the Formatting Toolbar
Working with Page Layout and Printing
- Inserting, Moving, and Removing Page Breaks
- Using Page Break Preview
- Printing Worksheets
- Using Print Preview
- Adjusting Margins
- Working with Page Setup
- Printing
Finding and Getting Help
Using Excel’s Shortcut Keys

INTERMEDIATE MICROSOFT EXCEL 2002

PARTICIPANTS
Intermediate Microsoft Excel 2002 is designed for those who have prior experience with Microsoft Excel2002, are involved with the production of spreadsheets, and who want to use Excel’s more advanced features.

PREREQUISITES
Students must have completed Introduction to Microsoft Excel 2002.

OBJECTIVES
Students will learn how to use Excel’s charts, styles, templates, and formulas and functions, and learn how to enhance their worksheets and customize Excel’s workspace and window. Specific chapter objectives are listed at the beginning of each chapter of the workbook. Hands-on exercises test the students’ mastery of the topics at the end of each chapter.

STRUCTURE
Course strategy is a combination of lectures and hands-on exercises, aided by a workbook and exercise disk.

OUTLINE

Creating Charts
- Using the Chart Wizard
- Creating Single and Multiple Series Charts
- Creating a Chart on a Separate Worksheet
- Adding Data to a Chart
- Deleting Data from a Chart
- Rearranging Chart Data
- Formatting Chart Elements
- Printing a Chart
Working with Styles and Templates
- Applying an Excel Style
- Creating New Styles
- Merging Styles Between Workbooks
- Using an Excel Template to Create a Form
- Customizing an Excel Template
- Creating a New Template
- Creating a Templates Folder
- Moving Templates Between Folders
Using Advanced Functions and Formulas
- Using the LOOKUP Function
- Using the VLOOKUP and HLOOKUP Functions
- Using Cell Addresses as Arguments
- Cascading Lookup Functions
- Working with Logical Functions AND, FALSE, IF,OR, NOT, and TRUE
- Using Comparison Operators
- Applying Logical Functions to a Worksheet

Enhancing Worksheets
- Adding, Resizing, and Moving Graphics
- Adding, Formatting, and Moving Text Boxes
- Adding and Formatting AutoShapes
- Adding and Formatting Callouts
- Adding and Formatting WordArt
- Adding and Formatting a Map
Customizing Excel
- Customizing Excel’s Windows
- Showing, Hiding, and Customizing Toolbars
- Changing Toolbar Shapes
- Docking and Undocking Toolbars
- Creating a Custom Toolbar
- Adding Commands and Menus to Toolbars
- Moving and Grouping Buttons on a Toolbar
- Floating Toolbar Menus
- Changing and Creating Worksheet Views
- Using Full Screen View and Zooming
- Creating and Importing Custom AutoFill Lists
- Splitting Worksheets Horizontally and
Vertically into Panes
- Freezing and Unfreezing Panes
- Hiding and Unhiding Worksheets, Rows, and Columns
- Creating, Using, and Deleting AutoCorrect Entries
- Using AutoComplete
- Setting and Modifying Excel Options

ADVANCED MICROSOFT EXCEL 2002

PARTICIPANTS
Advanced Microsoft Excel 2002 is designed for those who have prior experience with Microsoft Excel 2002, are involved with the production of spreadsheets, and who want to master Excel’s advanced features.

PREREQUISITES
Students must have completed Intermediate Microsoft Excel 2002.

OBJECTIVES
Students will learn how to use Excel’s advanced data management features, such as pivot tables, sorting, AutoFiltering, and AutoOutlining. Goal Seek, the Solver, the Scenario Manager, macros, object linking and embedding, sharing, protecting, and Web and networking features will also be covered. Specific chapter objectives are listed at the beginning of each chapter of the workbook. Hands-on exercises test the students’
mastery of the topics at the end of each chapter.

STRUCTURE
Course strategy is a combination of lectures and hands-on exercises, aided by a workbook and exercise disk.

OUTLINE

Managing Worksheet Data
- Using a Worksheet as a Database
- Entering and Validating Data
- Sorting Data by Rows and Columns
- Using Top 10 and Custom AutoFiltering
- Inserting Subtotals
- AutoOutlining Worksheets
Using Pivot Tables and Pivot Charts
- Creating and Modifying Pivot Tables and Charts
- Adding and Hiding Fields
- Using Pivot Table Functions
- Rearranging and Formatting Pivot Tables
- Using Pivot Table Functions
Analyzing Worksheet Data
- Using Goal Seek in Worksheets and Charts
- Using the Solver
- Creating and Working with Scenarios
- Creating a Scenario Summary Report
Working with Macros
- Recording a Macro
- Running a Macro
- Assigning a Shortcut Key to a Macro
- Creating and Using a Macro Button
- Editing and Deleting Macros
Working with Web Pages
- Definitions of Terms
- Publishing Web Pages
- Adding Interactivity
- Modifying Web Pages
- Saving Web Pages to Other Locations

Embedding and Linking Data
- Converting the Data Format
- Changing the File Type
- Changing Excel’s Default File Type
- Linking to Live Data on the Web
- Using Hyperlinks
- Embedding Objects Across Applications
Using Copy and Paste
Using Click and Drag
- Linking Objects Across Applications
- Using the Paste Special Command
- Updating Linked Objects
Protecting Workbooks
- Protecting and a Worksheet
- Locking and Hiding Cells
- Protecting a Workbook
- Hiding a Workbook and a Worksheet
- Assigning, Changing and Removing Passwords
Sharing, Messaging, and Collaboration
- Sharing a Workbook
- Tracking Changes in Shared Workbooks
- Viewing the Change History
- Merging Shared Workbooks
- Merging Multiple Shared Workbooks
- Removing Sharing from a Workbook
- Protecting and Sharing Workbooks
- E-Mail Integration
- Sending a Worksheet as an E-mail Message
- Sending a Workbook as an E-mail Attachment
- Collaborating Online Using NetMeeting