Loading... Please wait...

Excel 2010 Training Videos

Excel 2010 Training Videos

$49.95
SKU
excel2010
Rating
Availability
Usually ships in 1 to 2 business days.
Shipping
Calculated at checkout

Product Description

  • After purchase you will be directed to download the training video file.
  • Unlimited viewing of the training video(s) for one computer.
  • After purchase your training video DVD(s) will be shipped to you.
  • Unlimited viewing of the training video(s) for one computer.

Excel 2010 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 2010 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 2010!

DVD includes Excel 2010 Levels 1, 2 & 3 training videos in both: Flash (.swf) and Windows Media Video (.wmv), Exercise Files, Quiz, Answers and Instructor's Notes. Our Excel 2010 Levels 1, 2 & 3 training videos include all the training you need to pass the Excel 2010 Core (77-882) and Expert (77-888) Exams and become certified!

Excel 2010 Level 1 (6 hrs):

Basics

  1. Excel Getting Started A (6:24)
  2. Excel Getting Started B (5:26)
  3. Color, Fonts & Save Locations (9:19)
  4. Customize Quick Access Toolbar A (6:52)
  5. Customize Quick Access Toolbar B (4:45)
  6. Customizing Ribbon A (4:01)
  7. Customizing Ribbon B (5:07)
  8. Working With Cells (8:38)
  9. Data Entry (9:56)
  10. Save and Save As (8:47)
  11. Excel 2010 Help (2:25)
  12. Converting to Excel 2010 (4:30)
  13. Compatibility Checker (8:02)
  14. Convert to Previous Versions  (6:46)

Functions & Formulas

  1. Basic Formulas A (10:37)
  2. Basic Formulas B (5:48)
  3. SUM and AVERAGE A (6:39)
  4. SUM and AVERAGE B (11:21)
  5. MAX and MIN (8:44)
  6. COUNT and COUNTA (7:48)
  7. Copying & Pasting Data (8:35)
  8. Clipboard (3:23)
  9. Move, Cut and Paste (5:08)
  10. AutoFill (8:58)
  11. Absolute References (9:47)
  12. Mixed References (8:40)
  13. Text To Columns (7:23)

Editing Worksheets

  1. Editing Data (8:42)
  2. Editing Columns and Rows (6:39)
  3. Find and Replace (10:45)
  4. GoTo (6:29)
  5. Transpose Data (3:46)
  6. Adjusting Columns & Rows (3:38)
  7. Hide Columns & Rows (2:29)
  8. Modifying Fonts (4:22)
  9. Spell Check (2:45)
  10. Number Formats (5:07)
  11. Basic Custom Number Formats (4:35)
  12. Borders and Shading (10:04)
  13. Formatting Shortcuts (5:38)
  14. Applying Background (0:40)
  15. Cell Alignment (2:19)
  16. Merge Cells (4:29)
  17. Cell Text Wrapping (1:20)
  18. Create & Modify Styles (7:40)
  19. AutoFormat (3:02)
  20. Applying Themes (8:55)

Formatting

  1. Print Preview (3:15)
  2. Page Orientation (3:48)
  3. Print Titles (6:21)
  4. Headers and Footers A (5:34)
  5. Headers and Footers B (4:53)
  6. Margins (5:36)
  7. Page Breaks (8:50)
  8. Printing A Range of Data (5:15)

Modifying Worksheet Appearance

  1. Modifying Worksheets (10:04)
  2. Hiding Worksheets & Workbooks (3:41)
  3. Splitting Worksheets (5:28)
  4. Freeze Panes (3:59)
  5. Multi-Worksheet & Book Views (4:17)
  6. Text To Speech (2:03)

Excel 2010 Level 2 (4+ hrs):

Advanced Formulas

  1. Name Cells & Ranges (6:06)
  2. Linking Data (5:48)
  3. UPPER, LOWER & PROPER (3:08)
  4. CONCATENATE (3:50)
  5. LEFT, FIND & SEARCH (8:49)
  6. RIGHT, FIND & LEN (8:31)
  7. IF, AND & OR (6:09)
  8. Nested IF (3:11)
  9. IFERROR (2:20)
  10. PMT Payment Function (3:16)
  11. Display & Print Formulas (1:22)
  12. SUM, COUNT & AVERAGE IF(S) (8:11)
  13. VLOOKUP (7:11)
  14. HLOOKUP (5:44)

Tables

  1. Create Tables (3:39)
  2. Modifying Tables (5:37)
  3. Formatting Tables (1:46)
  4. Custom Table Style (2:50)
  5. Table Sorting & Filtering (4:28)
  6. DSUM, DAVERAGE & DCOUNT (9:04)
  7. Time Functions (3:31)
  8. Sorting & Database  Flaws (7:18)
  9. AutoFilter (6:42)
  10. Advanced Filter (10:06)
  11. Subtotals (4:29)

Charts

  1. Create Charts (5:14)
  2. Modifying Charts A (4:55)
  3. Modifying Charts B (3:15)
  4. Chart Titles (3:26)
  5. Formatting Charts (3:50)
  6. Creating Chart Templates (1:34)
  7. Chart Application Sharing (1:04)

PivotTable & Charts

  1. Create PivotTables (9:58)
  2. Customize PivotTables (10:08)
  3. PivotTable Slicers (8:24)
  4. Create Pivot Charts (5:20)

Graphics

  1. Insert & Modifying Pictures (4:00)
  2. ClipArt (2:26)
  3. Drawing & Modifying Shapes (5:33)
  4. SmartArt Graphics (5:25)
  5. Layering & Grouping Objects (4:21)

Customize

  1. Insert & Modify Comments (7:31)
  2. Hyperlinks (7:01)
  3. Web Research (0:55)
  4. Watermarks & Gridlines (5:00)
  5. Customize Themes (6:58)
  6. Create Workbook Templates (1:15)
  7. Create Custom Templates (3:59)

Excel 2010 Level 3 (3.5+ hrs):

Workbook

  1. Workbook Properties (6:24)
  2. Custom Views (4:50)
  3. Macro Basics (8:42)
  4. Editing Macros (4:30)
  5. Absolute & Relative Macros (3:19)
  6. Conditional Formatting (6:41)
  7. Data Validation (6:44)

Collaborating

  1. Protect Worksheets (6:24)
  2. Password Protect Cells (3:22)
  3. Document Inspector (2:49)
  4. Protect Structure (1:31)
  5. Password to Open/Modify (5:03)
  6. Create Backup (6:03)
  7. Share Workbook (11:26)
  8. SkyDrive Sharing A (4:52)
  9. SkyDrive Sharing B (3:57)
  10. SharePoint Sharing A (4:51)
  11. SharePoint Sharing B (3:38)
  12. Track Changes (4:50)
  13. Protect & Share (3:08)
  14. Merge Workbooks (5:33)
  15. Digital Signatures (9:15)
  16. Restrict Access (6:57)
  17. Mark As Final (1:27)

Audit Worksheets

  1. Tracer Arrows & Errors (4:55)
  2. Troubleshoot Invalid Data (2:46)
  3. Watch & Evaluate Formulas (4:13)
  4. AutoOutline & Grouping Data (9:35)

Analyzing Data

  1. Trend Line (2:40)
  2. Sparklines (2:55)
  3. Scenarios (5:44)
  4. Goal Seek (2:38)
  5. Solver (6:01)
  6. Random Samples (8:24)

Multiple Workbooks

  1. Workspace (2:37)
  2. Consolidating Data (5:13)
  3. Link Workbooks (5:46)

Import & Export Data

  1. Export to Word (3:53)
  2. Import Text File (3:18)
  3. Publish Worksheet to Web (3:36)
  4. Import from Web (4:05)
  5. XML A (6:49)
  6. XML B (4:47)
  7. Advanced Number Formats (5:56)
  8. Camera (3:59)
Excel 2010 Training Videos

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

Find Similar Products by Category

Product Reviews

Write your own product review

Previous | Showing reviews 21-30 of 42 | Next

  1. Great level of detail.

    I have looked for a lot of options for learning Excel and this is the best I have found. These video series are very complete and have a great level of detail, and at the same time are easy to understand. The package includes 14 hours of learning material, which is pretty good compared to other Excel videos. The narrator voice is clear and with good rhythm, which is very important in instructional videos. I can highly recommend you this video trainer because it has helped me a lot.

    Alberto R. - California (Submitted on 2nd Jan 2015)


  2. This is an excellent video.

    Accountants don't use Excel to the software's full potential and I was looking for an easy to understand video, that covered useful features that could be used in the accounting profession. This is an excellent video covering a variety of skill levels and explained clearly with live examples. Kirt Kershaw has a relaxed manner, and a voice that you never tire of. My concern on using video's is that after the first couple of lectures, I would wish the trainer would shut up. Whether it be an irritating voice, lack of teaching skill or just boring. I would definitely recommend Excel 2010 - it is an excellent training tool and teaches knowledge that is required to be efficient in the business world. I thought the training videos from Dream Force were excellent. The trainer was so good and had a voice that u never tired of. Some videos you wish the person would shut up, as they have an irritating voice. I will gladly rate this, as it was EXCELLENT. Kirt Kershaw is a brilliant teacher, I've never met him but after 14 hours - I love him to bits.

    Terry R. - Alabama (Submitted on 2nd Jan 2015)


  3. They are wonderful.

    Just want to let you know I have only listened to the first two video sessions and they are wonderful.

    Janet B. - Canada (Submitted on 2nd Jan 2015)


  4. Yours are much more informative.

    I have enjoy watching your video's they are short and to the point. In the past I have bought Learnkey video's but find yours much more informative.

    Katrina D. - New Zealand (Submitted on 2nd Jan 2015)


  5. Something new in the very first lesson.

    I have been using Excel for years and learned something new in the very first lesson.

    Elsie K. - Illinois (Submitted on 2nd Jan 2015)


  6. The most complete self-training program on Excel that is available.

    As a business analyst managing an Information Technology project portfolio of 50+ million dollars, I work with Excel workbooks on a daily basis. While my employer provides a training portal with several courses on Excel 2010 Basics/Intermediate/Advanced and Business Analysis using Excel, I have often found myself falling asleep while taking those courses due to dry, low quality and boring training materials. To enhance my Excel and business analysis skills, I decided to look for a good computer based training program on Excel 2010. I've bought a few programs on Excel from the major IT training providers, each costs from $99.95 to $249.99. Then one day while searching for a book on Microsoft Office Specialist exam preparation, I run into Dream Force, LLC, office training programs - among which is Microsoft Excel. At first, by looking at the price of $39.95, I thought it was a low-end training course. However, after giving this program a try and spending a week learning with this 3-Level course, I have found it to be the most complete self-training program on Excel that is available. In this program, the instructor will walk you through, step by step, all the skills you need to be proficient with this spreadsheet application and get ready to take the certification exam as a Microsoft Office Excel Specialist. You can start from scratch or from whatever point you already know in Microsoft Excel as this program covers more than 150 topics, complete with exercise files - from the basic definition such as what it means by "a cell", "a row", "data range", "name range", "function", "argument", "formula" to the most advanced business analysis tools like sorting, filtering, graphing and charts, trend lines, sparklines, import and export of data, pivot tables and pivot charts. What you need to know, this course will take you there. The video clips show the LIVE Excel environment. The instruction is very easy to follow along and the instructor will let you know what you may expect to see on your OWN COMPUTER screen so that you will never miss a thing! I love this course, and the DVD will be a good reference material whenever I need it.

    Ricky L. - Virginia (Submitted on 2nd Jan 2015)


  7. Well done.

    I've been retired for several years now and at one time I thought I was very capable when using Excel at work. Since those years have passed I have forgotten everything I had ever learned about this software. I just came across your training videos when browsing websites. I listened to the instructor for a while as a matter of slight interest. I'm not in the market for any instructions yet but I thought I'd tell you that what I heard was quite interesting, well spoken and quite enlightening.

    Grant T. - Canada (Submitted on 2nd Jan 2015)


  8. Excel 2010 Training Video is absolutely a must-buy video.

    Very informative, super-easy to understand and it serves as a tool guide in my excel related work. Since it's a DVD, you can always watch it anytime you need it. It's fun too, it has Exercise Files, Student Questions & Instructors Answers. I highly recommend it!

    Ivy C. - California (Submitted on 2nd Jan 2015)


  9. It's a great product, I learned a lot.

    It would be great that this product exists especially for Mac. If they can do the same just to learn the vba. 5 stars.

    Matsaerh D. - New Jersey (Submitted on 2nd Jan 2015)


  10. Amazing product!

    Amazing product!

    Elaine H. - Georgia (Submitted on 2nd Jan 2015)


Previous | Showing reviews 21-30 of 42 | Next



Sign up to receive information about new videos:

Contact Info

Professional & Certified Training
on Microsoft's Office: Access, Excel, Outlook, PowerPoint, Project and Windows.

Dream Force, LLC
10348 S. 2420 E.
Sandy, UT 84092

800-978-9790
801-278-0892

Kirt Kershaw
Microsoft Certified Trainer

Kirt has over a decade of training experience with Microsoft's Office and Windows. He holds Microsoft Certifications from the year 2000 to the present, and can help you certify too!


Access 2016 Training Videos | Excel 2016 Training Videos | Word 2016 Training Videos | Office 2013 Training Videos | Access 2013 Training Videos | Excel 2013 Training Videos | Outlook 2013 Training Videos | PowerPoint 2013 Training Videos | Project 2013 Training Videos | Word 2013 Training Videos | Office 2010 Training Videos | Access 2010 Training Videos | Excel 2010 Training Videos | Outlook 2010 Training Videos | PowerPoint 2010 Training Videos | Project 2010 Training Video | Word 2010 Training Videos | Office 2007 Training Videos | Access 2007 Training Videos | Excel 2007 Training Videos | Outlook 2007 Training Videos | PowerPoint 2007 Training Videos | Project 2007 Training Videos | Word 2007 Training Videos | Windows 7 Training Videos | Windows Vista Training Videos

Microsoft Office Training Videos Home | DVD | Download | Reviews | About | Contact

Click the button below to add the Excel 2010 Training Videos to your wish list.