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.
Excel 2007 Tutorial CD / DVD
Create the best self-paced learning environmentright 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
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Introduction to Excel 2007
Introduction to Excel 2007
- 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
We hope you enjoyed the free videos above. To watch all this course including the
chapters below please purchase the CD.
Working with Worksheets and Workbooks
$149.95
- 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 Excel 2007 Training CD
| Title : | Excel 2007 |
|---|---|
| Tutor : | Cheryl Duncan
Other tutorials by Cheryl Duncan |
| Videos : | 104 Lessons- Video run time: 8 Hours |
| Delivery time: | Only 3 working days |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2007 |
| Work files | Yes |
| Price Australia / New Zealand & Asia | AUD $149.95 (+ $10.00 Shipping ) |
210 In Stock
Purchase Orders from Schools, Colleges, Government and Military Accepted
Multi User Network Version Available
This training is also available in Multi User format for Schools and Corporate users.
10 Multi User $695
10 Multi User $695 Why use this method of video training?
- Learn Excel 2007 from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application from basics to advanced for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you.
- It's cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
Want to hear what our customers say about our products?
Associated Tutorials:
Mircosoft Outlook 2007 | Crystal Reports | Microsoft Project Tutorial | Excel 2003 | Microsoft Project 2003 | QuickBooks 2008 | Visio 2007 | FileMaker 11 | Microsoft Word 2010
Excel 2007 Related Training Videos:
Free Certificate. Prove Your Credentials
We now offer all customers a free certificate to verify they have undertaken a training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your free certificate without delay.
Instant Online Access all the Training Videos for only $30.00
Unlimited Accesss to 60,000 Training Video only $30.
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.
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, and no commitment on your part.
You can have access to every title we list on this site for just $30 per month. When you sign up, you get instant access with absolutely no restrictions or limits. Log on from any location and learn as much as you like.
When you're finished, cancelling is easy. Just click the cancel button - that's it, no questions - you're in total control.
