Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.
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
Associated Tutorials: Crystal Reports | Microsoft Project Tutorial | Excel 2003 | QuickBooks 2008 | Microsoft Word 2010 | Microsoft Outlook 2010 Tutorial | MS Powerpoint 2010 | Microsoft Word 2007 Tutorial | Microsoft Access 2010 | Microsoft Project 2010 | Microsoft Office for Mac 2011
Microsoft Excel 2007 Tutorial CD / DVD
When you order this Microsoft Excel 2007 Video Tutorial CD You'll Receive...
Over 8 hours of high quality video-based training that walks you through
the program in easy to follow stages.
A training video that focuses on real life examples and teaches you
real life skills. These tutorials are
structured to increase not only your skills but also your earning potential.
With this Training Video you will...
Learn Microsoft Excel 2007 from a leading expert and quickly master
the skills required to work in a commercial environment.
Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike
Customer Comments
" ...now I watch the training at home and on my laptop on the train going to work. It couldn't be more convenient. Thanks. "Christopher Brazell, Virginia
Microsoft 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.

Topics Covered on this Training Course
- Welcome to Excel 2007

- Overview of Spreadsheets and Excel 2007

- Overview of Course

- New in Excel 2007 Lesson 1

- New in Excel 2007 Lesson 2

- Understanding the Excel 2007 Workspace

- Introducing the New Excel 2007 Ribbon

- Using the Quick Access Toolbar

- Compatibility with Earlier Versions

- Accessing Microsoft Excel 2007 He|p

- Using Excel 2007 He|p

- Using Microsoft Office On-line

- Accessing the Support Knowledge Base

- 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
- 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 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
- 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
- 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
- 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
- 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
- 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
- About This Author and these Tutorials
About this Microsoft Excel 2007 Training CD
| Title | Microsoft Excel 2007 |
| Tutor | Cheryl Duncan Other tutorials by Cheryl Duncan |
| Videos | 104 Lessons- Video run time: 8 hours |
| Compatibility | Vista, XP, Windows 7, Mac OSX |
| Released | 2007 |
| Work files | Yes |
| Availability | Immediate Dispatch |
| Price US / Canadian Sales | Only $99.95
|
| Closed Captions | Closed Captions are available to Online Users only |
Mutli User Training Options
This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.
Not Sure Which Titles to Buy? Unlimited Access to all -$30
Unlimited Access to over 70,000+ Training Videos
Not sure which training CD titles to purchase? Why
not join our Online University and have unlimited access to all our tutorial videos for one low
price of $30 per month.
No contract .
No minimum
period.
No commitment on your part.
Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.
Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits
Why Is This Training Format So Effective?
- Learn Microsoft Excel 2007 from an accredited expert in days.
Related Training Videos
Microsoft Project Tutorial | FileMaker Tutorials | Excel Tutorial Videos | Online Microsoft Excel 2007 Training Courses
Prove your Knowledge - Free Certificate
Prove Your Credentials!
Free Certificate.



