MS Excel 2010 Introduction

This course will help students prepare for the Microsoft Office Specialist exam for Excel 2010 (exam 77-882). For comprehensive certification training, students should complete our Introduction, Intermediate, and Advanced courses for Excel 2010.

Course Description:

After completing this 1-day Excel 2010 Introduction training course course, students will know how to:

• Start Microsoft Excel and identify the components of the Excel interface
• Open an Excel workbook
• Use the Help window
• Navigate worksheets
• Enter & edit text, values, & formulas
• Examine the order of operations
• Insert pictures
• Use AutoFill
• Save and update a workbook
• Save a workbook as a PDF file
• Move and copy data and formulas
• Use the Office Clipboard
• Use Paste Link
• Work with relative and absolute references
• Insert and delete ranges, rows, and columns
• Use the SUM function, AutoSum, and the Average, Min, Max, Count, and Counta functions to perform calculations in a worksheet
• Format cells, rows, and columns
• Merge cells
• Apply color and borders
• Format numbers
• Create conditional formats
• Copy formatting
• Apply table styles
• Sort data
• Use Find and Replace to update the formatting for specific content
• Check spelling
• Find and replace text and data
• Preview and print a worksheet
• Set page orientation and margins
• Create & format headers and footers
• Print gridlines
• Create, format, modify, and print charts based on worksheet data
• Work with various chart elements
• Apply chart types and chart styles
• Freeze panes and split a worksheet
• Open and arrange a new window with the current worksheet content
• Hide and unhide data
• Set print titles and page breaks to optimize print output
• Insert different even and odd headers
• Manage multiple worksheets
• Represent data graphically within cells by applying three forms of conditional formatting (data bars, color scales, and icon sets)
• Insert and modify SmartArt graphics; and insert and modify screenshots