Home | Photo/Video/Web | Services | SEO | Training | Database Services ! Links | Contact Us

Microsoft Office Excel 2007
Training Courses

Microsoft Office Advanced Excel 2007

Section One: Advanced Topics
Lesson 1.1: Setting Excel Options
Lesson 1.2: Excel and Windows
Lesson 1.3: Using the Excel Viewer

Section Two: Getting the Most from your Data
Lesson 2.1: Getting the Most from your Data
Lesson 2.2: PivotTables
Lesson 2.3: More About PivotTables
Lesson 2.4: Exploring Scenarios
Lesson 2.5: What If Analysis

Section Three: 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 Four: 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, Consolodating, and Combining Workbooks

Microsoft Office Excel 2007 Intermediate 1 Day
sample course contents

Section One: Advanced File Tasks
Lesson 1.1: Using My Computer within Excel
Lesson 1.2: Saving Your Files
Lesson 1.3: Using Templates

Section Two: 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 Three: 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 Four: 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 Five: 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

We can also offer on site training including comprehensive manuals for any of the Microsoft Suite of Products from Office 2007

Microsoft Office Excel 2007 Foundation

Section One: 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 Two: 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 Formula Ribbon
Lesson 2.6: The Data Ribbon
Lesson 2.7: The Review Ribbon

Section Three: 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 Four: 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 Five: 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

If you want to up skill your in-house staff with fast track training courses give us a call and we can custom design a course to your requirements and deliver it on a schedule that suits you!

Remember all of our excel courses can be delivered on site
( always the lower cost option)
or in training rooms in Raheen also all courses can be fully customised to your requirements and can also be delivered as evening courses.

View Our New Blog!

Handy Links For Training info

Home | Digital imaging Services | Computer Services | Training Services | Microsoft App Training | Links | Contact Us

© CCSL Web Design . All rights reserved.