Find a Course...Try for FREE

Microsoft Excel 2007 Training Information
Trainer: Cheryl Brumbaugh Duncan
Duration: 8 hrs
Video Lessons: 104
  30 Days Full Online Access:
  $30.00   $30.00
  €21.49   £18.49
  $38.49

(Instant Access to ALL Tutorials)

These tutorials are also available on CD ROM:
Microsoft Excel 2007 Tutorial on CD
Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9


Microsoft Excel 2007 Training Description
• Stop struggling and start to use this powerful spreadsheet application like a true pro with these online Microsoft Excel 2007 training tutorials.
• Using clear and concise video training movies and aimed at both beginner and intermediate users, expert author Cheryl Brumbaugh-Duncan demonstrates all the essentials of MS Excel 2007, which will help you master this most popular application in the shortest time possible.
• Not only will you pick up all the essential skills needed to use MS Excel to a high standard, but you'll also learn numerous useful MS Excel tips, tricks and techniques that will improve you daily workflow's.
• Start learning right away by viewing the FREE Microsoft Excel 2007 training tutorials by clicking any blue linked lesson above.


Training Categories
    Graphics & Page Layout
    Internet & Web Design
    Animation & 3D
    Multi Media & Video
    Business
    Certification
    Operating Systems
    Databases
    Programming
    Music & Audio
    Tutorials Coming Soon


THE MOST COST EFFECTIVE WAY TO LEARN
These best selling online Microsoft Excel 2007 training videos are the fastest and most cost effective way to learn. Using narrated video tutorials to demonstrate key techniques and features, this easy-to-follow instruction will help you to learn rapidly and retain essential knowledge and skills. Commencing from the basics, this "for dummies" training method will help users feel at ease from the outset.

This tutoring method allows users to learn either at home or the office and on any Mac or PC with an internet connection, for as less than $1 a day!

So why not start learning now and see how millions have used this training method as an effective substitute for expensive Microsoft Excel 2007 training courses or workshops, boring books and tedious PDF training manuals.

Microsoft Excel 2007 Training - FREE Tutorials

FREE Microsoft Excel 2007 Training
Learn Microsoft Excel 2007 in the shortest time possible, start now with the linked tutorials below:   (Please allow a few seconds to load)
To ensure the FREE tutorials below run smoothly, please view our short checklist - CLICK HERE

Introduction to Excel 2007
Welcome to Excel 2007
Overview of Spreadsheets and Excel 2007
Overview of Course
New in Excel 2007 - Tuition 1
New in Excel 2007 - Tuition 2
Understanding the Excel 2007 Workspace
Introducing the New Excel 2007 Ribbon
Using the Quick Access Toolbar
Compatibility with Earlier Versions

Installing Excel 2007
Considerations Before You Install
Installing Excel

Microsoft Excel 2007 He|p
Accessing Microsoft Excel 2007 He|p
Using Excel 2007 He|p
Using Microsoft Office On-line
Accessing the Support Knowledge Base

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month.


Working with Worksheets and Workbooks
Launching Excel
Planning a Project
Creating a New Workbook
Adding and Deleting Data
Importing Data into Excel
Naming and Saving a Workbook
Managing Multiple Worksheets
Printing a Worksheet - Tuition 1
Printing a Worksheet - Tuition 2
Opening and Closing a Workbook
Renaming and Deleting a Workbook

Editing Techniques
Selecting Cells / Rows / Columns
Cut / Copy / Paste
Copy and Paste Special
Editing or Replacing Content in a Cell
Undo / Redo / Repeat Edits
Adjusting Row Height
Adjusting Column Width
Inserting and Deleting Rows / Columns / Cells
Merging and Splitting Cells
Clearing a Cell
Finding and Replacing Data
Using AutoFill

Customizing Excel 2007
Customizing the Excel Workspace
Splitting the Screen
Freezing and Locking Cells
Hiding and Showing Rows / Columns / Sheets
Using Different Views
Arranging Multiple Workbooks
Displaying Gridlines and Headings
Setting a Trusted Location
Using Excel Options

Changing the Appearance of a Worksheet
Formatting Options in the Ribbon
Formatting Text
Formatting Numbers
Adding Borders
Adding Fill Colors and Patterns
Using the Format Painter
Using Cell Styles
Using Document Themes
Using Wrap Text
AutoCorrect
Setting Page Layout Options
Adding Headers and Footers
Setting Page Breaks
Using Templates
Using Conditional Formatting

Working with Formulas
Using Formulas
Formula Writing Made Easy
Creating Simple Formulas
Order of Operations
Creating Formulas with Operators and Cell References
Understanding Cell References
Calculating Totals with AutoSum
Common Functions
Creating Formulas with Functions
Creating Formulas with Nested Functions
Creating and Managing Names
Creating Formulas with Names
Displaying and Printing Formulas
Error Checking
Common Errors When Creating Formulas

Managing Data
Overview of Excel Data Handling Tools
Creating an Excel Table
Sorting an Excel Table
Filtering an Excel Table
Formatting Excel Table Data
Working with Excel Table Rows and Columns
Displaying and Calculating Table Data Totals
Using Structured References
Validating Data
Linking Data Between Worksheets
Linking Data Between Multiple Workbooks
Exporting Data

Charts and Graphics
Overview of Charts and Excel
Understanding Chart Types
Creating a Chart
Changing the Chart Type of an Existing Chart
Moving and Deleting a Chart
Changing the Charted Data
Editing Charts
Formatting a Chart - Design Tab
Formatting a Chart - Layout Tab
Formatting a Chart - Format Tab
Creating a Chart Template
Applying a Chart Template
Importing Graphics into Excel
Modifying Imported Images

Excel 2007 Plays Well with Others
Overview of Sharing and Collaborating
Excel and Other Office Applications
Using the Office Clipboard
Creating PDF Files
Opening and Saving Files in Other Formats
Excel and Databases
Using Queries
Using with a Document Management Server
Publishing an Excel Worksheet
Excel XML Files
Wrap Up

Credits
About This Author

CLICK HERE TO BUY THIS TUTORIAL ON CD




Sign up to the Online University and view over 400 titles for only $30/£15 per month
BENEFITS:
  1 Minimum Sign Up: ONLY ONE MONTH! - Cancel at any Time
  2 Unlimited Viewing
  3 Downloadable Instruction Files/PDFs
  4 Learn Microsoft Excel 2007 from Expert Tutors
  5 View on any Computer in the World
  6 Works on PC and Mac
  7 Full Support Offered
  8 Easy to Follow Video Instructions - Visual Advantage Over Bulky Microsoft Excel 2007 User Guides / Help Manuals
  9 550+ Online Classes- New Titles Added Weekly
  10 A Truely Professional Study Guide

Learn how to work faster and smarter right now, CLICK HERE to sign up to the Online University

These tutorials are also available on CD ROM:
Microsoft Excel 2007 Tutorial on CD

Multi user options available for large organistions and education
CLICK Here for further info

Free Certificates downloadable once each course has been completed


RECENTLY ADDED TUTORIALS
  APPLE MOTION 4 TRAINING
  MS SQL SERVER 2008 TRAINING
  ADOBE PREMIERE ELEMENTS 8
  FINAL CUT PRO 7 TRAINING
  AUTODESK REVIT 2010
  ADOBE PHOTOSHOP ELEMENTS 8
  ACT 2010 TRAINING
  CAKEWALK SONAR 8/8.5
  MS VISUAL BASIC 2008
  TOON BOOM STUDIO 5
  LINUX+ CERTIFICATION 2009
  PYTHON PROGRAMMING TRAINING
  REVIT STRUCTURE 2010 TRAINING




CERTIFICATE WITH EVERY COURSE
After a course is completed you are able to download a FREE certificate. This certifies that you have completed the training and that you now possess essential
skills and detailed knowledge of Microsoft Excel 2007