October Systems TrainSignal Reseller
01223 894136

excel 2007  training courseExcel 2007 Training Course

 

 

 



"Hands On" Training for IT Users


Excel 2007 Training Demo

With Microsoft Office's Newest release, Excel 2007 is better than ever. Every business out there has an application of Excel 2007 that will benefit them with increased productivity and better analysis. Whether it is just tracking expenses, budget goals or creating massive keyword lists for Google with 1,000,000 rows Microsoft Excel 2007 has a way to make you work better and quicker. In the sample training video Bill will teach you about creating table styles in Microsoft Office Excel 2007.


Topics you will Master in
Microsoft Excel 2007 Training Video Course:

Introduction to Microsoft Excel 2007

  • About your Excel 2007 training instructor: Bill Kulterman
  • Who is Microsoft Excel 2007 training for?
  • About this course
  • Learning Made Fun Scenario
  • Excel Keyboard shortcuts
  • What we learned

Welcome to Microsoft Excel 2007

  • The Ribbon
  • The Quick Button
  • The Quick Access Toolbar
  • Contextual Tabs
  • Navigation
  • Scroll Bars
  • Excel 2007 Keyboard Commands
  • Go To

Entering and Editing Excel Data Part 1

  • Entering Data In Excel 2007
  • Editing Your Data
  • Cut, Copy, Paste, Undo, Redo
  • Inserting Rows and Columns into your Excel Workbook
  • Edit Column Width and Row Height

Entering and Editing Excel Data Part 2

  • Find And Replace Data
  • Working With Ranges
  • Auto Fill: Text, Numbers, Custom Lists

Auditing Your Excel Files

  • Errors: Trace Precedents, Trace Dependants, Trace Errors, Evaluate Formulas, Error Checking, ISERROR
  • Validation: Data Validation, Invalid Data
  • Watch Your Data: Watch Window, Conditional Formatting

Charts in Excel 2007

  • What Is a Chart?
  • Chart Types
  • Create Charts: Column, Pie, Combination Chart, Bar, Modify
  • Format Charts: Design, Layout, Format

Multiple Workbooks

  • Linking Workbooks: Workspaces, External Reference
  • Consolidation: by Position, by Category

Templates For Excel 2007

  • What is a Template?
  • Using Templates
  • Downloading and Installing Excel Templates
  • Creating Your Own Template
  • Protecting Your Worksheet
  • Save As Template

Pivot Tables in Excel 2007

  • What Are Pivot Tables?
  • Creating Pivot Tables in Excel 2007
  • What Else Can I Do With Pivot Tables?
  • Formatting Pivot Tables
  • Pivot Charts

Collaboration with Microsoft Excel 2007

  • Protect and Share a Workbook
  • Tracking Changes in Excel Files
  • Merging Excel Documents
  • Comments and Hyperlinks

Macros

  • Using Macros
  • Creating Macros
  • Creating Buttons in Excel
  • Macro Editor
  • Saving Excel Macros

Printing Your Excel files

  • Viewing your Excel Documents
  • Page Layout
  • Headers and Footers
  • Ready to Print

The Complete Train Signal FastTrack Video
CBT Training Library
Buy "Excel 2007" as Part of our Complete FastTrack Video CBT Training Library...
Every Course we Have on a USB Hard Drive
Check it Out Now!

complete fastrack library


Excel 2007

Only £60 (ex vat & del)

Multi user pricing available - call sales now

Official Purchase orders accepted from Government, Education, Health & Charity, Times 1000 plc's,  Professional Partnerships and other pre-approved accounts. Want to order more than one course ? Contact sales for a custom quote.

TrainSignal Authorized Distributor
October Systems
October Systems The Old Telephone Exchange Balsham Road Linton CB21 4LD
Authorized TrainSignal Distributor
footer image footer image