Microsoft Excel 2007 Tutorial Video

Self Study, Tutorial Video on CD - DVD. Tutor Cheryl Duncan guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users

These Microsoft Excel 2007 tutorials offer a straightforward uncomplicated insight to using Excel 2007. Created for beginners and experienced users alike this training CD is a comprehensive reference on using Excel in a commercial environment, and making a seamless transition from earlier versions. Using high quality narrated QuickTime videos that cover every aspect in great detail this training CD is a ideal reference and learning aid that will move you towards total proficiency with Microsoft Excel 2007. The tutorial comes complete with working files. Click here for all versions of Microsoft Excel Tutorials. Watch our free Excel 2007 Tutorial Videos by clicking the blue lesson links below.

try for free

Excel 2007 Tutorial CD / DVD

Create the best self-paced learning environment
right on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Problems Playing the Demos?
Benefits
  • Professional Tuition from an Expert
  • Free Certificate with Each Tutorial
  • Works on PC or Mac
Just Released This Week
Apple Logic Pro 9 tutorial video
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Introduction to Excel 2007 Installing Excel 2007 Microsoft Excel 2007 He|p
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$149.95
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 Tutorials 1
  • Printing a Worksheet Lesson 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 in Excel
  • 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 in Excel
  • 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 Tutorials
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 Tutorials
  • 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 and these Tutorials
UK & Europe
Apex Web Media
PO Box 398
Bolton, BL7 9RZ
United Kingdom
T: 01204 592071
USA & Canada
600 17th Street, Suite 2800, Denver CO 80202
Open 8am - 5pm M to F (EST)
Tel - Toll free 1866 402 1903 ( USA )
Tel 434-878-4158
Fax 1 207 433 4356