Excel 2010 MOS - Online Course

Microsoft Excel 2010 is a financial tool for performing calculations and other tasks automatically. It lets you accomplish a variety of business or personal tasks in a fraction of the time it would take using pen and paper. This series shows you how to work efficiently with Excel, and prepares you for the Microsoft Office Specialist 77-882 exam and Microsoft Office Specialist (MOS) certification.

This series is for anyone preparing for the Excel MOS 77-882 exam. This online course contains 9 lessons and should take approximately 28 hours to complete.

Lesson 1: Becoming Familiar with Excel (4.0) hours

Becoming Familiar with Excel teaches you how to use the Ribbon and toolbars, create new workbooks, open existing workbooks, move around in workbooks, save workbooks, and recover workbook backups. This course provides an overview of Microsoft Excel 2010 to help prepare you for the Microsoft Office Specialist exam. Topics include Learning the Excel Environment, New and Existing Workbooks, Moving Around a Workbook, Saving Workbooks, Checking Compatibility and Accessibility, Working More Efficiently, and Recovering Workbooks and Updating Excel.

Lesson 2: Performing Basic Workbook Tasks (3.0) hours

Performing Basic Workbook Tasks teaches you how to 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, and use AutoCorrect and work with actions. 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. Topics include Selecting Cells, Rows, and Columns, Entering Labels and Values, Editing and Clearing Cell Contents, Copying, Moving, and Pasting Content, Inserting, Deleting, and Replacing, and Using AutoCorrect and Actions.

Lesson 3: Working with Formulas and Functions (4.0) hours

Working with Formulas and Functions teaches you how to work with formulas, name cells and ranges, and use cell references, perform calculations, locate and correct formula errors, and create and use functions. 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. Topics include Working with Formulas, Editing Formulas and Using References, Naming Cell Ranges, Performing Calculations, Correcting Errors, Audits and Circular References, Creating Functions, and Array Formulas and Nested Functions.

Lesson 4: Modifying Workbooks and Worksheets (3.0) hours

Modifying Workbooks and Worksheets teaches you how to name, insert, delete, move, copy, and hide worksheets, adjust column width and row height, freeze columns and rows, split worksheets, save layouts, and use templates. This course provides instruction on modifying the way information is organized, displayed, or hidden in Microsoft Excel 2010 workbooks and worksheets. Topics include 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, and Using Templates.

Lesson 5: Formatting Worksheets (3.0) hours

Formatting Worksheets teaches you how to format numbers and text, apply and manage conditional formatting, add sparkline formatting, adjust data alignment and text flow, add color, borders, and themes, and apply Cell Styles. This course provides tools and techniques that will allow you to effectively format your worksheets. Topics include 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, and Applying Cell Styles.

Lesson 6: Viewing and Printing (2.0) hours

Viewing and Printing teaches you how to set up pages for printing, adjust page margins, headers, and footers, insert page breaks and customize print jobs, preview and print worksheets, and create PDF and XPS documents. This course explains how to print worksheets in Excel. Topics include Setting Up Pages for Printing, Adjusting Page Margins, Adding Headers and Footers, Inserting Page Breaks, Customizing the Print Area, and Previewing and Printing.

Lesson 7: Working with Graphics (3.0) hours

Working with Graphics teaches you how to use clip art and media clips, insert pictures and screen shots, apply styles, shapes, and borders, correct and recolor pictures, and create WordArt and SmartArt. This course explains how to add visual flair to Excel worksheets with clip art, screen shots, WordArt, SmartArt and graphic shapes. Topics include 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, and Drawing and Modifying Shapes.

Lesson 8: Charting, Sorting, and Filtering Data (2.0) hours

Charting, Sorting, and Filtering Data teaches you how to create and format charts, insert and modify tables, sort and filter table data, and use PivotCharts and PivotTables. 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. Topics include Creating Charts, Creating Tables, Sorting Table Data, Filtering Table Data, and Using PivotTables.

Lesson 9: Reviewing and Sharing Data (4.0) hours

Reviewing and Sharing Data teaches you how to use cell comments, e-mail workbooks, export, import, link, and embed data, publish to the Web, create, format, and use hyperlinks, and save and edit workbooks with Windows Live. 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. Topics include 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, and Saving Workbooks with Windows Live.