Further Details
Excel 2003 Module II
Target Audience:
This course targets individuals interested in learning
the features of Microsoft Excel 2003.
Course Length:
Excel 2003 Module II is a one day course.
Prerequisites:
Excel 2003 Module I
Brief Description:
Excel 2003 Module II provides competency in restructuring and formatting worksheets;
manipulating the display of worksheets; creating and using multiple worksheets
and printing worksheets and workbooks. Guided, step-by-step labs provide
opportunities to practice new skills. You can challenge yourself and reinforce
your skills after each lesson in the Lesson Summary and Lesson Review sections,
and the Activities and Optional Labs. Additional skill review is provided
in Lesson Quizzes and a Course Assessment that are available from your
instructor.
Cost:
The cost of this course is just £125per person
Topics
Lesson 1:
Working
with Multiple Worksheets
About
Working with Multiple Worksheets
Organizing Multiple Worksheets
Renaming Worksheet Tabs
Colouring Worksheet Tabs
Consolidating Data from Multiple Worksheets
Lesson 2:
Adjusting the Screen Display
Adjusting the Display of Workbooks and Worksheets
Working with Multiple Workbook
Splitting and Freezing Worksheet Panes
Adjusting the Zoom Setting
Displaying and Hiding Toolbars
Lesson 3:
Working with Advanced Functions
The Function Wizard
Using the NOW Function
Using the DATE Function
Using the HLOOKUP and VLOOKUP Functions
Using the IF Function
Using the PMT Function
Lesson 4:
Using
Advanced Print Options
Controlling the Appearance of Printed Pages
Adjusting Page Scaling and Orientation
Changing Margin Widths
Creating Headers and Footers
Inserting Page Breaks
Setting Print Areas
Printing Repeating Rows and Columns
Controlling the Display of Cell Error Messages
Printing Multiple Worksheets
Printing Entire Workbooks
Lesson 5:
Filtering
Data and Using Comments
Filtering Data
Working with Comments
Naming Worksheet Ranges and Formulas
Lesson 6:
Working
with Names
Naming Ranges
Using Range Names in Formulas
Creating Three-Dimensional References
Naming Formulas
Deleting Range Names
Lesson 7:
Working
with Charts
Introduction to Charts
Creating Charts
Moving and Resizing Charts
Formatting Charts
Changing Chart Types
Editing Chart Data
Printing Charts
Lesson 8:
Protecting
Data:
Introduction to Protecting Data
Protecting Workbooks
Protecting Worksheets
Protecting Cells
Protecting Ranges
Hiding Data
Assigning Passwords to Workbooks
Lesson 9:
Using Basic Integration and Web Features:
Importing Data from Text Files
Importing Data from Microsoft Word
Creating and Modifying Hyperlinks
Exporting Excel Data to Microsoft Word
Saving Worksheets and Workbooks as Web
Pages
Publishing Worksheets and Workbooks
to the Web
Guide price
£125 per Student |
