Excel 2007 Training Videos

(41 reviews) Write a Review
SKU:
excel2007
UPC:
837654648513
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at Checkout

Bulk discount rates

Below are the available bulk discount rates for each individual item when you purchase a certain amount

Buy 5 - 9 and get 35% off
Buy 10 or above and get 40% off
  • Excel 2007 Training Videos
$49.95

Description

Excel 2007 Training Videos will introduce you to the basics of creating a: spreadsheet, with simple formulas and calculations to more powerful ones, and how you can use Excel 2007 as a database with many sorting and filtering options. It's also important to know how to create your database right the first time, like how to avoid common design flaws, and numerous time saving features!

Learn how to create charts from your organized data, how to format your data range into a nice looking table, and more by our Microsoft Certified Trainer training Excel 2007!

DVD includes Excel 2007 Levels 1, 2 & 3 training videos in both: Flash (.swf) and Windows Media Video (.wmv). Our Excel 2007 Levels 1, 2 & 3 training videos include all the training you need to pass the Excel 2007 Core (77-602) and Expert (77-851) Exams and become certified!

Excel Level 1 (4 hrs):

Basics

  1. Excel Getting Started (14:29) - Click Here To Watch Demo!
  2. Quick Access Toolbar (8:51)
  3. Data Entry (14:21)
  4. Converting to 2007 (10:37)
  5. Converting to Previous (4:33)
  6. Move Copy Cut Data (5:41)
  7. AutoFill Feature (3:13)
  8. Editing Data (12:11)
  9. Find and Replace (5:55)
  10. GoTo Feature (3:13)
  11. Spell Check (1:24)

Functions & Formulas

  1. Basic Formulas (10:27)
  2. SUM and AVERAGE (12:59)
  3. MAX and MIN (2:34)
  4. COUNT and COUNTA (3:43)
  5. Absolute Reference (6:21)
  6. Mixed References (11:09)
  7. Text To Columns (3:48)
  8. Combine Columns (4:15)

Formatting

  1. Modifying Fonts (3:20)
  2. Borders and Shading (5:52)
  3. Adding Backgrounds (1:03)

Editing Worksheets

  1. Adjusting Columns Rows (5:20)
  2. Text Wrapping (3:38)
  3. Hide Columns Rows (2:41)
  4. Merge Cells (2:59)
  5. Formatting Numbers (8:41)
  6. Create Modify Styles (4:21)
  7. AutoFormat (2:19)
  8. Applying Themes (8:52)
  9. Modifying Worksheets (7:43)

Modifying Worksheet Appearance

  1. Print Titles (2:23)
  2. Headers and Footers (8:22)
  3. Margins (4:10)
  4. Page Orientation (2:16)
  5. Page Breaks (5:08)
  6. Print Scaling (4:22)
  7. Set Print Area (3:21)
  8. Split Window (2:50)
  9. Freeze Panes (3:14)
  10. Arranging Worksheets (4:10)
  11. Hide Worksheet Books (2:39)
  12. Speak Cells (3:57)

Excel 2007 Level 2 (3.5 hrs):

Customize

  1. Customize Excel 2007 Interface (3:18)
  2. Watermarks and Gridlines (7:53)
  3. Customize Themes (5:04)
  4. Cell Comments (6:25)
  5. Create Hyperlinks (6:39)
  6. Web Research (1:08)
  7. Custom Templates (8:39)

Tables

  1. Create Tables (3:01)
  2. Modifying Tables (5:44)
  3. Custom Table Styles (2:13)

Charts

  1. Create Charts (5:49)
  2. Modify Charts (7:07)
  3. Chart Templates (1:27)
  4. Chart Sharing (1:10)

PivotTable & Charts

  1. Create PivotTables A (9:40)
  2. Create PivotTables B (5:16)
  3. Create PivotCharts (5:07)

Graphics

  1. Insert Pictures (2:28)
  2. Draw Modify Shapes (5:08)
  3. SmartArt Processes (4:37)
  4. Clip Art (2:18)
  5. Layering and Groups (5:44)

Advanced Formulas

  1. Create Name Ranges (7:03)
  2. Linking Data (4:43)
  3. Time Functions (3:41)
  4. LEFT and SEARCH A (9:32)
  5. RIGHT SEARCH and LEN B (9:25)
  6. PROPER UPPER and LOWER (2:58)
  7. SUM COUNT AVG Ifs (8:36)
  8. HLOOKUP (7:56)
  9. VLOOKUP (6:50)
  10. IF AND and OR (6:11)
  11. Nested IF (4:13)
  12. IFERROR (5:17)
  13. Display & Print Formulas (2:30)
  14. PMT Payment (4:25)
  15. Sort, Consecutive Sorts & Database Design Flaws (9:22)
  16. Advanced AutoFilter (7:08)
  17. DSUM DAVG DCOUNT (10:40)
  18. Subtotals (4:47)

Excel 2007 Level 3 (2.9 hrs):

Workbook

  1. Macro Basics (8:34)
  2. Editing Macros (4:53)
  3. Advanced Filter and Macros (8:17)
  4. Conditional Formatting (3:47)
  5. Validation Rule (6:32)
  6. Workbook Properties (3:27)
  7. Excel Default Settings (2:04)

Collaborating

  1. Protect Worksheet (7:39)
  2. Protect Structure and Windows (2:06)
  3. Protect  Workbook and  Backup A (3:59)
  4. Protect  Workbook and Backup B (5:29)
  5. Share Workbook (10:15)
  6. Protect Shared Workbook (5:03)
  7. Merge Workbooks (6:07)
  8. Macro Settings (3:20)
  9. Digital Signatures (10:43)
  10. Restrict Access by User (8:54)

Audit Worksheets

  1. Formula Auditing (4:04)
  2. Circle Invalid Data (2:30)
  3. Watch & Evaluate Formulas (5:18)
  4. Automatic Outline and Group (5:57)

Analyzing Data

  1. Chart Trend Lines (1:42)
  2. Scenario Manager (5:36)
  3. Goal Seek (2:52)
  4. Solver (4:59)
  5. Random Sampling (8:10)
  6. Workspace (2:34)
  7. Consolidate Data (4:25)
  8. Link Workbooks (5:54)

Import & Export Data

  1. Export To Word (1:48)
  2. Import Text Files (1:31)
  3. Publish Worksheets To Web (1:39)
  4. Import Data From Web (2:22)
  5. XML Structuring (10:41)
  6. Advanced  Number (6:01)
Excel 2007 Training Videos

Excel 2007 training videos from Dream Force — training videos solutions.
Affordable Excel 2007 training videos
.

View AllClose

41 Reviews

  • 5
    My students really enjoyed the course and most of them made A's and B's in the course because of the Dream Force Excel Training Video.

    Posted by Gary W. - West Virginia on 17th Feb 2015

    I teach Excel at a community college in my town. The Dream Force Excel DVD Video was a wonderful tool in teaching Excel to my students. After each section, I would stop the DVD and have my students to get hands-on-experience by doing the exercises. Some of the students had dropped the class previously because their instructor taught them by using the textbook and it was confusing and was hard for them to understand. My students really enjoyed the course and most of them made A's and B's in the course because of the Dream Force Excel Training Video. I also recommended that my students should purchase a copy of the DVD from Amazon.com if they wanted to take the Microsoft Excel Certification exam in the near future. I give it 5 stars!

  • 5
    Actually surprised to find things that I didn't know.

    Posted by Dennis K. - Georgia on 17th Feb 2015

    Very easy to follow from beginner to advanced... I am very pleased with these training videos. I went through the basic videos first even though I am familiar with the basic functions of Excel and was actually surprised to find things that I didn't know. The videos are structured that it is very easy to find the instructions for what you want to do as the videos are separated out so that you don't have to search through hours of video to find one certain thing. All in all, I don't think you can find better training anywhere else at a price like this.

  • 5
    Very easy to follow.

    Posted by Ray G. - Florida on 17th Feb 2015

    Good Foundation. The training does a very good job building on the basics. Very easy to follow.

  • 5
    Amazing DVDs, you will love these!

    Posted by Sharon S. - Florida on 17th Feb 2015

    I just wrote a stellar review on MS Excel, but I love all of these products and will follow up with reviews of others as well... Amazing DVDs, you will love these! I purchased these dvds to brush up on my Excel abilities and this product is outstanding! I have used these dvds often, they're very informative, cover the topics well and give relative, interesting, applicable examples. Thank you, thank you, thank you for offering this wonderful product, it has helped me tremendously! Thanks so much for these wonderful dvds!

    There's something else I wanted to tell you… I took an Excel class hosted at a local hotel recently by a big name company who apparently is known more for their classes being infomercial-like, than learning based. It was terrible. They pushed their expensive software products the entire time and there was little instruction going on during the course. I felt bad because my company had sent me to the course, I didn't really know Excel, and I was afraid to tell my bosses just how much of a rip-off the class really ended up being. Knowing that I needed the Excel knowledge in my head quickly, due to my daily job responsibilities, I purchased your DVDs so I could learn at home. They have saved me so much time at work! I went from not knowing Excel to being a semi-pro – I text-to-column and concatenate my data daily!

  • 5
    Live, careful instructional videos show each step and voice over explanation.

    Posted by Arnold J. - New Jersey on 17th Feb 2015

    Dream Force Excellence in Excel-Word-Access. This is the best tutorial available to use if you're tired of trying the old book-cd "click here-type that" routine. Live, careful instructional videos show each step and voice over explanation. Very nice.

  • 5
    Nearly finished level 3 on Excel 2007; good job!

    Posted by Paul B. - Ireland on 17th Feb 2015

    Nearly finished level 3 on Excel 2007; good job! Would it be right to say, that level 3 still only scratches the surface of excel....there are so many formulas that could be used? Having said that, your Excel course is excellent, well designed and prepared...I still have 3 modules in level 3 to finish, but so far so good :) Have you any distribution network to get these disks to Europe and beyond!...the potential market for your product is huge!

  • 5
    We are all learning and loving the training.

    Posted by Cheryl T. - Oklahoma on 17th Feb 2015

    I purchased two of your excel training dvd's -- one for my office and one for my husband's. We are all learning and loving the training.

  • 5
    Will recommend them to my friends.

    Posted by Paul P. - Illinois on 17th Feb 2015

    Your Excel and Access training vids are great and will recommend them to my friends. Do you offer anything for QuickBooks?

  • 5
    So happy that I'm going to order the Office 2007 bundle also.

    Posted by Anthony B. - Kentucky on 17th Feb 2015

    I received my lessons on DVD for Excel 2007, and I'm very happy with them. So happy that I'm going to order the Office 2007 bundle also.

View AllClose