Session I - Becoming Familiar with Excel

Time - 4 hours

Description

This course provides an overview of Microsoft Excel 2010 to help prepare you for the Microsoft Office Specialist exam.

Objectives

• This course provides an overview of Microsoft Excel 2010 to help prepare you for the Microsoft Office Specialist exam.
• Use the Ribbon and toolbars
• Create new workbooks
• Open existing workbooks
• Move around in workbooks
• Save workbooks
• Recover workbook backups

Topics

• Learning the Excel Environment
• New and Existing Workbooks
• Moving Around a Workbook
• Saving Workbooks
• Checking Compatibility and Accessibility
• Working More Efficiently
• Recovering Workbooks and Updating Excel

Session II - Performing Basic Workbook Tasks

Time - 3 hours

Description

This course provides information on basic tasks you perform when working with data in your worksheets to help prepare you for the Microsoft Office Specialist exam.

Objectives

• This course provides information on basic tasks you perform when working with data in your worksheets to help prepare you for the Microsoft Office Specialist exam.
• Select cells and cell ranges
• Enter labels and values in a worksheet
• Edit and clear cell contents
• Copy, paste, and move data
• Insert, delete, and replace cell contents
• Use AutoCorrect and work with actions

Topics

• Selecting Cells, Rows, and Columns
• Entering Labels and Values
• Editing and Clearing Cell Contents
• Copying, Moving, and Pasting Content
• Inserting, Deleting, and Replacing
• Using AutoCorrect and Actions

Session III - Working with Formulas and Functions

Time - 4 hour

Description

This course prepares you for the Excel MOS 77-882 exam by providing an introduction to using formulas and functions in Excel 2010. It also provides some tips for troubleshooting common errors with formulas and functions.

Objectives

• This course prepares you for the Excel MOS 77-882 exam by providing an introduction to using formulas and functions in Excel 2010. It also provides some tips for troubleshooting common errors with formulas and functions.
• Work with formulas
• Name cells and ranges, and use cell references
• Perform calculations
• Locate and correct formula errors
• Create and use functions

Topics

• Working with Formulas
• Editing Formulas and Using References
• Naming Cell Ranges
• Performing Calculations
• Correcting Errors
• Audits and Circular References
• Creating Functions
• Array Formulas and Nested Functions

Session IV - Modifying Workbooks and Worksheets

Time - 3 hours

Description

This course provides instruction on modifying the way information is organized, displayed, or hidden in Microsoft Excel 2010 workbooks and worksheets.

Objectives

• Name, insert, delete, move, copy, and hide worksheets
• Adjust column width and row height
• Freeze columns and rows
• Split worksheets
• Save layouts
• Use templates

Topics

• Working with Excel Worksheets
• Moving, Copying, and Hiding Worksheets
• Selecting and Hiding Columns and Rows
• Inserting and Deleting Columns and Rows
• Adjusting Column Width and Row Height
• Freezing and Splitting Worksheets
• Creating Views and Saving Layouts
• Using Templates

Session V - Formatting Worksheets

Time - 3 hours

Description

This course provides tools and techniques that will allow you to effectively format your worksheets.

Objectives

• Format numbers and text
• Apply and manage conditional formatting
• Add sparkline formatting
• Adjust data alignment and text flow
• Add color, borders, and themes
• Apply Cell Styles

Topics

• Formatting Numbers and Text
• Applying Conditional Formatting
• Managing Conditional Formatting
• Adding Sparkline Formatting
• Adjusting Data Alignment and Text Flow
• Adding Color and Borders
• Using Themes
• Applying Cell Styles

Session VI - Viewing and Printing

Time - 2 hours

Description

This course explains how to print worksheets in Excel.

Objectives

• Set up pages for printing
• Adjust page margins, headers, and footers
• Insert page breaks and customize print jobs
• Preview and print worksheets
• Create PDF and XPS documents

Topics

• Setting Up Pages for Printing
• Adjusting Page Margins
• Adding Headers and Footers
• Inserting Page Breaks
• Customizing the Print Area
• Previewing and Printing

Session VII - Working with Graphics

Time - 3 hours

Description

This course explains how to add visual flair to Excel worksheets with clip art, screen shots, WordArt, SmartArt and graphic shapes.

Objectives

• Use clip art and media clips
• Insert pictures and screen shots
• Apply styles, shapes, and borders
• Correct and recolor pictures
• Create WordArt and SmartArt

Topics

• Using Clip Art and Media Clips
• Inserting Pictures and Screenshots
• Applying Styles, Shapes, and Borders
• Correcting and Recoloring Pictures
• Adding Transparency
• Creating WordArt Text
• Building SmartArt Graphics
• Drawing and Modifying Shapes

Session VIII - Charting, Sorting, and Filtering Data

Time - 2 hours

Description

This course explains how to organize and present data with charts, tables, PivotCharts, and PivotTables. Specifically, it focuses on creating charts and tables, and using tables to sort and filter data.

Objectives

• Create and format charts
• Insert and modify tables
• Sort and filter table data
• Use PivotCharts and PivotTables

Topics

• Creating Charts
• Creating Tables
• Sorting Table Data
• Filtering Table Data
• Using PivotTables

Session IX - Reviewing and Sharing Data

Time - 4 hours

Description

This course explains how to review and share data in Microsoft Excel 2010. Specifically, it focuses on importing, exporting, linking, embedding, e-mailing and publishing data, as well as adding comments, hyperlinks, and consolidations to worksheets.

Objectives

• Use cell comments
• E-mail workbooks
• Export, import, link, and embed data
• Publish to the Web
• Create, format, and use hyperlinks
• Save and edit workbooks with Windows Live

Topics

• Using Cell Comments
• E-Mailing Workbooks
• Exporting and Importing Data
• Linking and Embedding Data
• Consolidating Data
• Getting External Data
• Publishing Workbooks to the Web
• Creating and Formatting Hyperlinks
• Saving Workbooks with Windows Live