Microsoft® Office Excel 2010: Level 1

Course Objective: Students will create and edit Excel worksheets and workbooks, use formulas and functions, as well as apply formatting and printing techniques.

Prerequisites: To ensure your success, each student should have a general knowledge of Microsoft Windows and Microsoft Office concepts.

Contact us to discuss if this level is right for you.

What’s New in 2010: Enhance your workbooks with new graphic features, including the Remove Background tool. Use new designs and capabilities for SmartArt graphics. Get to know the Backstage View and the much improved excel environment, which can be fully customized. Improved paste options let you see a live preview before you select which paste to use. Users can capture screenshots using the new screenshot tool, which works on any open window, document, or webpage.

Lesson 1: Creating a Worksheet

Topic 1A: Explore the User Interface and the Ribbon
Topic 1B: Update a Workbook’s Properties
Topic 1C: Navigate and Select Data in Excel
Topic 1D: Enter Data and Save a Workbook
Topic 1E: Customize the Quick Access Toolbar
Topic 1F: Obtain Help
Topic 1G: Use Microsoft Office Templates

Lesson 2: Performing Calculations

Topic 2A: Calculate with Formulas
Topic 2B: Calculate with Functions
Topic 2C: Copy Formulas and Functions
Topic 2D: AutoFill Options and Series List

Lesson 3: Modifying a Worksheet

Topic 3A: Manipulate Data
Topic 3B: Insert and Delete Cells, Columns, and Rows
Topic 3C: Find and Replace Data in a Worksheet
Topic 3D: Manipulate Worksheet Elements

Lesson 4: Formatting a Worksheet

Topic 4A: Modify Fonts
Topic 4B: Add Borders, Color to Cells, Cell Styles
Topic 4C: Change Column Width and Row Height
Topic 4D: Apply Number Formats
Topic 4E: Position Cell Contents

Lesson 5: Printing Workbook Contents

Topic 5A: Print Workbook Contents
Topic 5B: Set Page Layout and Print Options
Topic 5C: Set Page Breaks

Lesson 6: Managing Large Workbooks

Topic 6A: Format Worksheet Tabs
Topic 6B: Manage Worksheets in a Workbook
Topic 6C: Manage the View of Large Worksheets

Lesson 7: Inserting Graphic Objects

Topic 7A: Insert and Modify Pictures and ClipArt
Topic 7B: Draw and Modify Shapes
Topic 7C: Illustrate Workflow Using SmartArt Graphics
Topic 7D: Layer and Group Graphic Objects

Excel 2010 Training Class Outlines:

Excel 2010 Level 1: Fundamentals of Excel
Excel 2010 Level 2: Intermediate Functions and Features
Excel 2010 Level 3: Advanced Tools and Collaboration Features
Excel 2010 Level 4: Advanced Formulas and Functions
Excel 2010 Level 5: Introduction To VBA Macros
Excel 2010 Level 6: Advanced VBA Macros