In this clinic with hands-on labs, you will gain the knowledge and skills to work with introductory features and functionality of Microsoft Excel 2010.

What You'll Learn

• Create, save, open, close, and move around in an Excel workbook to learn navigation skills necessary for creating and using Excel worksheets
• Organize columns and rows to accommodate information and edit the contents of cells to organize the information in your worksheet
• Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference
• Create formulas by typing functions or build more complex formulas using the Insert Function dialog box
• Format worksheets and use view features to more effectively review large worksheets
• Use views to determine the layout of a worksheet, change the page setup, and preview/print workbooks

Who Needs to Attend

New Microsoft Excel 2010 users

Prerequisites

Experience with Windows XP, Windows Vista, or Windows 7

Follow-On Courses

• Microsoft Excel 2010 - Level 2 (S102)
• Microsoft Excel 2010 - Level 3 - Spreadsheet Analysis (S103S)
• Microsoft Excel 2010 - Level 3 - Data Management (S103D)
• Microsoft Excel 2010 - Level 3 - VBA Macros (S103V)

Course Outline

1. Getting Started with Excel 2010

• Spreadsheet Concepts
• Getting Started
• Creating and Saving Workbooks
• Opening and Closing Workbooks
• Review Exercise

2. Modifying Worksheets

• Working with Columns and Rows
• Working with Cell Contents
• Review Exercise

3. Using Formulas and Functions

• Creating and Using Formulas
• Creating and Using Functions
• Using Absolute Cell References
• Inserting Functions
• Review Exercise

4. Formatting and Viewing Worksheets

• Formatting Worksheets
• Viewing Worksheets
• Review Exercise

5. Printing Workbooks

• Using Workbook Views
• Changing the Page Setup
• Previewing and Printing Workbooks
• Review Exercise