Microsoft Office Excel 2007: Level 1 Training | Chicago
Description for Microsoft Office Excel 2007: Level 1
Welcome to Microsoft Excel 2007 Level 1. This course introduces students to the basics of working with Microsoft Excel, a versatile and powerful program for creating spreadsheets, charts and performing a wide range of calculations. Basic features that will be covered include: the New Interface, basic navigation and selection techniques, working with and formatting worksheets, basic calculations and different Print options. Charts will be covered as well.
Outline of Microsoft Office Excel 2007: Level 1
SECTION 1: Getting Started
- Lesson 1.1: Starting Out
- Lesson 1.2: Exploring your Workbook
- Lesson 1.3: Getting Help in Excel 2007
SECTION 2: The New Interface
- Lesson 2.1: What’s New in Excel 2007
SECTION 3: Excel Basics
- Lesson 3.1: Working With Excel 2007
- Lesson 3.2: AutoFill and AutoComplete
- Lesson 3.3: Using Custom AutoFill Lists
- Lesson 3.4: Smart Tags and Options Buttons
- Lesson 3.5: Editing Tools
SECTION 4: Editing and Formatting Your Workbook
- Lesson 4.1: Modifying Cells and Data
- Lesson 4.2: Enhancing a Worksheet’s Appearance
- Lesson 4.3: Cell Formatting
SECTION 5: Basic Formulas and Functions
- Lesson 5.1: Basic Formulas in Excelo:
- Lesson 5.2: Formulas with Multiple Operators
- Lesson 5.3: Exploring Excel Functions
- Lesson 5.4: Understanding Relative and Absolute Cell References
SECTION 6: Printing and Viewing your Workbook
- Lesson 6.1: Using the View Ribbon
- Lesson 6.2: Printing your Workbook
SECTION 7: Charts
- Lesson 7.1: Working With Charts
- Lesson 7.2: Working with Charts, Part 2
- Lesson 7.3: Creating an AutoChart

