For more info call us @ 614 441 9564
EXCEL 2007 - FUNDAMENTALS
SECTION 1: Getting Started
Lesson 1.1: Starting Out
Lesson 1.2: About Workbooks
Lesson 1.3: Exploring your Workbook
Lesson 1.4: Getting Help in Excel 2007
SECTION 2: The New Interface
Lesson 2.1: The Quick Access Toolbar
Lesson 2.2: The Home Ribbon
Lesson 2.3: The Insert Ribbon
Lesson 2.4: The Page Layout Ribbon
Lesson 2.5: The Formulas Ribbon
Lesson 2.6: The Data Ribbon
Lesson 2.7: The Review Ribbon
SECTION 3: Excel Basics
Lesson 3.1: Working With Excel 2007
Lesson 3.2: Basic Excel Features
Lesson 3.3: Moving your Data
Lesson 3.4: Smart Tags and Options Buttons
Lesson 3.5: Editing Tools
SECTION 4: Editing Your Workbook
Lesson 4.1: Modifying Cells and Data
Lesson 4.2: Cell Formatting
Lesson 4.3: Enhancing a Worksheet’s Appearance
Lesson 4.4: Working With Charts
Lesson 4.5: Working with Charts, Part 2
SECTION 5: Printing and Viewing your Workbook
Lesson 5.1: Using the View Ribbon
Lesson 5.2: Managing a Single Window
Lesson 5.3: Managing Multiple Windows
Lesson 5.4: Printing your Workbook
EXCEL 2007 - INTERMEDIATE
SECTION 1: Intermediate File Tasks
Lesson 1.1: Using My Computer within Excel
Lesson 1.2: Saving your Files
Lesson 1.3: Using Templates
SECTION 2: Working with Functions and Formulas
Lesson 2.1: Using Formulas in Excel
Lesson 2.2: Exploring Excel Functions
Lesson 2.3: Using Functions in Excel
Lesson 2.4: Working with Names and Ranges
Lesson 2.5: Working with Array Formulas
SECTION 3: Managing Tables
Lesson 3.1: Working with Tables
Lesson 3.2: Working with Records and Fields
Lesson 3.3: Working with Tables and Filters
Lesson 3.4: Using Excel as a Database
SECTION 4: Enhancing your Workbook
Lesson 4.1: Customizing your Workbook
Lesson 4.2: Working with Text Boxes
Lesson 4.3: WordArt
Lesson 4.4: ClipArt
Lesson 4.5: Using Objects
SECTION 5: Finalizing Your Workbook
Lesson 5.1: Protecting your Workbook
Lesson 5.2: Finishing Your Workbook
Lesson 5.3: Using Excel in Word
Lesson 5.4: Using Excel and Access
Lesson 5.5: Using Excel With other Programs and Files
SECTION 1: Advanced Topics
Lesson 1.1: Setting Excel Options
Lesson 1.2: Excel and Windows
Lesson 1.3: Using the Excel Viewer
Section 1: Review Questions
SECTION 2: Getting the Most from your Data
Lesson 2.1: Getting the Most From Your Data
Lesson 2.3: More About PivotTables
Lesson 2.4: Exploring Scenarios
Lesson 2.5: What If Analysis
SECTION 3: Excel and the Internet
Lesson 3.1: Excel and Hyperlinks
Lesson 3.2: Saving Workbooks as Web Pages
Lesson 3.3: Getting Data from the Internet
Lesson 3.4: Excel and Office Servers
SECTION 4: Advanced Excel Tasks
Lesson 4.1: Creating and Using Shared Workbooks
Lesson 4.2: Using Custom AutoFill Lists
Lesson 4.3: Using the VLOOKUP Function
Lesson 4.4: Linking, Consolidating, and Combining Workbooks
EXCEL 2007 – ADVANCE
Lesson 2.2: PivotTables
EXCEL 2007 - EXPERT
SECTION 1: Add-ins, Smart Tags, and Digital Security
Lesson 1.1: Add-ins and the Trust Center
Lesson 1.2: Information Rights Management
Lesson 1.3: Digital Signatures
Lesson 1.4: Smart Tags and XML
SECTION 2: Macros, VBA, and Excel Programming
Lesson 2.1: Macros
Lesson 2.2 More Macro Tasks
Lesson 2.3: Visual Basic and Macros
SECTION 3: Expert Topics
Lesson 3.1: Form Controls
Lesson 3.2: Advanced Functions
Lesson 3.3: Using SharePoint
Lesson 3.4: User Forms and ActiveX Controls
