How To GurusQuality Training since 1995 
 

 

 

 

 

 

 


Microsoft Excel 2007
Tutorial Training Video Set

Microsoft Excel 2007 Tutorial Training Video

Regular Price $98.95
Sale Price $39.87
Available on DVD-Rom

Our DVD is filled with 15 hours of video tutorial training.
203 individual video lessons.
Covers every topic that you need to know.
Includes all working files and examples.

Comments by recent purchasers

Note: These are Computer DVDs and will not play on a TV style DVD player
Note: This training is for Windows
and does not come with the Adobe InDesign program
Our training videos can be viewed on a Mac.
Visit our Mac page for more info.

This is our New Expanded Training title for Microsoft Excel 2007. More hours of training, More videos. More complete procedure demonstrations. More in-depth discussions than in any of our previous Microsoft Office training titles. We demonstrate all of the new features in Microsoft Excel 2007 including full demonstrations of the new interface and tabs. Plus expanded training on Excel 2007 PivotTables, PivotCharts, Advanced Charting and Macros.

Pass that Exam, Get a Raise, Start a New Job. Using our training can help you attain these goals.

You get the most comprehensive, thorough and complete training for Microsoft Excel 2007 available.

This isn't some dry lecture, or a training disk that was designed to go with classroom training. Our training is complete training for Excel 2007. We demonstrate all of the tools and processes you will need to create your own professional level spreadsheets. We do this using actual examples allowing you to learn the correct techniques and good practices needed for today's market. The training is broken down into easy to follow sections, starting with a basic introduction to Excel 2007 (including a look at the new features) and then moving onto more advanced lessons and topics.

Microsoft Excel 2007 Tutorial Training Video

        • We show you:
          • How to use the New Excel 2007 Interface.
          • How to use the New Excel 2007 Charting Tools
          • How to create Excel 2007 PivotTables and PivotCharts
          • How to work with Excel 2007 Macros
          • Importing and Using pictures, clipart, smart clipart
          • Using Excel 2007 Templates
          • Using the new Excel 2007 Page Layout tools
          • Using the new Excel 2007 Formula and Data tools
          • Full list of Excel 2007 video lessons below
        • And much, much more.

"Your disks are better than the Total Training ones I have gotten with the Adobe software."
"Every so-called guru should be trained by these fellows. A First-class product."

"Excellent product and a great bunch of guys to do business with! 2 thumbs up!"

"Exceptional customer service; Will buy from again; fast shipping!! *10 stars*"

Just some of the many positive comments we receive every week

Each HTG training software title guides you quickly and easily through comprehensive, step-by-step video tutorials.

As you follow along, you learn by doing, mastering the programs at your own pace. You are provided with a dynamic educational tool - an information rich resource you can refer to again and again.

Each instructor-guided CD or DVD title is presented in full motion video, with the instructor clearly demonstrating each lesson in the actual program being taught while providing a full narrative description of each step.

 

Complete List of Excel 2007 Videos

Microsoft Excel 2007 Tutorial Training Video

Microsoft Excel 2007 Training

Excel 2007 Part 1

Excel 2007 Overview
1. How to use this Training
2. Overview
3. New Interface
4. Themes and Styles
5. Formula Writing
6. Sorting and Filtering
7. Table Enhancements
8. New Charting Tools

The Excel 2007 Workspace
9. The Workspace
10. Important Tools
11. Customize
12. Properties
13. More Workspace Tools

Excel 2007 Document Basics
14. Open & New
15. Data
16. Formulas
17. Charts
18. Cell Formatting
19. Pictures
20. Saving
21. Printing

The Excel 2007 Tabs
22. The Office Button
23. The Quick Access Toolbar
24. The Home Tab
25. The Insert Tab
26. The Page Layout Tab
27. The Formulas Tab
28. The Data Tab
29. The Review Tab
30. The View Tab
31. The Developer Tab
32. The Add-Ins Tab
33. Customizing Tabs & Toolbar
34. Help Button
35. Right Mouse Click

           

Excel 2007 Part 2

Excel 2007 Formulas & Functions
1. Formulas
2. References
3. Insert Function Wizard
4. Formula Auditing
5. Functions
6. Dates
7. Text
8. Information

Excel 2007 Layout & Formatting
9. Cells & Rows
10. Moving & Copying
11. Sheets
12. Comments
13. Cell Attributes
14. Borders & Shading
15. Numeric Formats
16. Hiding & UnHiding
17. Formatting Text

Excel 2007 Cell Referencing
18. Relative & Absolute
19. Mixed Referencing
20. 3D Referencing
21. R1C1 Style

Excel 2007 Printing
22. Page Setup
23. Header & Footer
24. Print Preview
25. Printing Controls

Excel 2007 Worksheets & Workbooks
26. Splitting & Freezing                       
27. Troubleshooting
28. Templates
29. Smart Tags
30. Workbooks
31. Multi-Sheet Workbooks
32. Comments
33. Collaboration
34. Shared Workspace

Microsoft Excel 2007 Tutorial Training Video

Microsoft Excel 2007 Training

Excel 2007 Part 3

Excel 2007 Auditing & Advanced Functions
18. Tracking Changes
19. Cell Relationships
20. Error Correction
21. Circular References
22. Conditional Formulas
23. Calculation Operators
24. Order Precedence
25. Nested Functions

Excel 2007 Common Formulas
26. Look Up Values
27. Multiplication Table
28. Convert Measurements
29. Text & Other Functions
30. Date & Time Entry
31. Formatting Dates
32. Convert Times
33. Insert Julian Dates

Excel 2007 Insert Tab
18. Insert Table
19. Insert Pictures/Clip Art
20. Insert Shapes/Charts
21. Hyperlinks
22. Headers and Footers
23. Text Box
24. WordArt
25. Signature Line
26. Object
27. Symbol

Excel 2007 Page Layout 1
28. Themes
29. Colors
30. Fonts
31. Effects
32. Margins
33. Orientation
34. Size/Print Area
35. Background
36. Print Titles

           


Excel 2007 Part 4

Excel 2007 Page Layout 2
1. Scale to Fit
2. Gridlines
3. Headings
4. Send to Front/Back
5. Selection Pane
6. Align
7. Group
8. Rotate

Excel 2007 Formulas 1
9. AutoSum
10. Recently Used
11. Financial
12. Logical
13. Text
14. Date & Time
15. Lookup & Reference
16. Math & Trig
17. More Functions

Excel 2007 Formulas 2
18. Name Manager
19. Defining/Using Names
20. Trace Precedents
21. Trace Dependents
22. Remove Arrows
23. Show Formulas
24. Error Checking
25. Evaluate Formula
26. Watch Window
27. Calculation Options

Excel 2007 Data
28. From Sources
29. Connections
30. Sort
31. Filter
32. Data Tools
33. Data Validation
34. What-If Analysis
35. Outline

Microsoft Excel 2007 Tutorial Training Video

Microsoft Excel 2007 Training

Excel 2007 Part 5

Excel 2007 Review Tools
1. Check Spelling
2. Research
3. Thesaurus
4. Translate
5. Commenting
6. Protect Sheet
7. Protect Workbook
8. Share Workbook
9. Tracking Changes

Excel 2007 View Tools
10. Workbook Views
11. Show/Hide
12. Zoom
13. New Window
14. Arrange Windows
15. Freeze Panes
16. Split Windows
17. Save Workspace
18. Switch Windows

Excel 2007 Developer Tools
19. Visual Basic
20. Intro to Macros
21. Insert
22. Design Mode
23. Properties
24. View Code
25. XML Source
26. Import/Export XML
27. Document Panel

Excel 2007 Add-Ins
28. Using Add-Ins
29. Contribute Example

Excel 2007 Templates
30. Opening Templates
31. Online Templates
32. Saving as a Template

Excel 2007 Part 6

Excel 2007 Charts
1. Creating Charts
2. Chart Types
3. Chart Templates
4. Hidden Data
5. Data Series
6. Modify Chart
7. Formatting Chart
8. Titles and Labels
9. Gridlines

Excel 2007 PivotTables/PivotCharts
10. About PivotTables/Charts
11. Create PivotTable/Chart
12. PivotTable Formats
13. Options
14. Field Settings
15. Formulas
16. Reports
17. Report Filters
18. Calculations
19. Layout/Formatting
20. Convert to Worksheet Formulas
21. Sorting Data

Excel 2007 Macros
22. Creating Macros
23. About Macro Security
24. Copy between Workbooks
25. The Macro Editor
26. Editing Macros
27. Enable/Disable Macros



 

Our DVD is filled with 15 hours of video tutorial training.
203 individual video lessons.
Covers every topic that you need to know.
Includes all working files and examples.

Regular Price $98.95
Sale Price $39.87

Microsoft Excel 2007 Tutorial Training Video

 

Home | Company |Policy | Sitemap | Testimonials | Free Tutorials

Making Money on the Web | Photoshop | Photoshop Elements | InDesign | After Effects | Premiere | Illustrator | Flash | Dreameaver
JavaScript | HTML | CSS | Fireworks | PageMaker | QuarkXPress | Microsoft Office | Internet Security


Follow howtogurus on Twitter

© 2017 How To Gurus, all rights reserved