Microsoft® Office Excel 2007: Level 1

Course Objective: Students will create and edit basic Excel worksheets and workbooks, use formulas and functions, and apply common 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 2007: If you’re new to Microsoft Office 2007, there are some big changes to the look, feel, and operation of Microsoft Excel. Learn about the new Ribbon menu layout, which makes things easier to find and more logical than before. Explore the new graphics options available with SmartArt, a tool that creates organizational charts, lists, or process flow diagrams. Explore the View options of Excel, including the new Layout View.

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 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: Search for Data in a Worksheet
Topic 3D: Manipulate Worksheet Elements 

Lesson 4: Formatting a Worksheet

Topic 4A: Modify Fonts
Topic 4B: Add Borders and Color to Cells
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 2007 Training Class Outlines:

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