COMPUTER + SOFTWARE TRAINING
[Spreadsheets]

This course is designed for individuals new to Excel or self-taught users looking to fill gaps in their knowledge

Includes:
Microsoft Office Specialist (MOS) approved courseware
Downloadable CertBlaster© MOS Exam Preparation software
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Getting started

• Spreadsheet terminology
• Exploring the Excel window
• Getting help
• Navigating workbooks

Lesson 2: Entering and editing data

• Entering and editing text and values
• Entering and editing formulas
• Working with pictures
• Saving and updating workbooks

Lesson 3: Modifying a worksheet

• Moving and copying data
• Moving and copying formulas
• Absolute and relative references
• Inserting and deleting ranges

Lesson 4: Using functions

• Entering functions
• AutoSum
• Other useful functions

Lesson 5: Formatting worksheets

• Formatting text
• Formatting rows and columns
• Formatting numbers
• Conditional formatting
• Copying formats and applying table formats

Lesson 6: Printing

• Preparing to print
• Page Setup options
• Printing worksheets

Lesson 7: Creating charts

• Chart basics
• Modifying charts
• Printing charts

Lesson 8: Managing large workbooks

• Viewing large worksheets
• Printing large worksheets
• Using multiple worksheets