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 11-20 of 42 | Next

  1. Great product.

    It starts with basic classes and goes all the way to advanced.

    Anna G. - New Jersey (Submitted on 2nd Jan 2015)


  2. I really like the program.

    I really like the program, and cannot wait to get really into it.

    Mary H. - Arizona (Submitted on 2nd Jan 2015)


  3. This will definitely help for Excel Expert!

    Listened to 3 hours -- I am amazed at how much I have learned so far. Am currently Excel Specialist -- this will definitely help for Excel Expert! :>

    Peter S. - Wisconsin (Submitted on 2nd Jan 2015)


  4. Great instructional video.

    Great instructional video.

    Angel D. - Arizona (Submitted on 2nd Jan 2015)


  5. This really helps you understand the Spreadsheet Program.

    The individual videos are easy to follow along with and don't require any prior knowledge in order to figure out and understand the concepts being explained. Each individual video does a good job in explaining that part of the software. It's broken up into small lessons basically so you can do a few each day or just spend a few hours and watch a whole bunch at once. You do find yourself wanting to watch just one more today, and then maybe just one more, hehe, and time goes by quickly as you learn. This I feel is a good thing and it's better than having to force yourself to sit through extremely boring videos. It makes learning Excel 2010 much easier than trying to read a book, at least for me anyway... To be honest, I haven't totally completed the lessons yet myself. I got distracted with other stuff during the holidays but look forward to getting back to the lessons. I did find them enjoyable over-all. I hope this helps you determine whether this training disc full of videos will help you or not. You can click the exact topic you need to learn about, everything is clear as day, all laid out in sections and chapters for each of the 3 difficulty levels, level 1, level 2 and level 3 (the most advanced lessons). Having ALL 3 levels all included like this on just one disc is very convenient! I recommend this highly for anyone wanting to learn Excel 2010 no matter their prior skill level. Have a great 2013 everyone...!

    Nycvideogeek N. - New York (Submitted on 2nd Jan 2015)


  6. Trainer is easy to listen.

    I bought this for advanced excel functions. However, after reading many of the comments, I believe there is benefit to work though some of the introductory training as well. I especially like that he steps through a variety of options to achieve the 'result'.

    Deb E. - Illinois (Submitted on 2nd Jan 2015)


  7. I have to give this company a 10 star rating if it were possible.

    Great customer service with real people who take care of their customers. I will be ordering more Video's in the future and highly recommend them to anyone looking for training Videos! A company who really care about their customers.

    Nancy E. - Colorado (Submitted on 2nd Jan 2015)


  8. These training videos gave me the knowledge and confidence to land my dream job.

    In tough economic times such as these it’s essential to have valuable skills to bring to a job interview. Having very strong MS Office skills is a must have for any decent CV (change this to resume if you like) to stand a chance in today’s job market. My investment in this training has paid for itself several times over on day 1 of starting the job – Thank you!

    Peter W. - United Kingdom (Submitted on 2nd Jan 2015)


  9. Recommended all of your DVDs to all of my colleagues.

    You can know that I have recommended all of your DVDs to all of my colleagues in the Federal Government. I was responsible for training 50 people in our office and I always use your DVDs and I've recommended them to everyone I know. I'll buy the 2010 Word as soon as you guys finish.

    Michael R. - Virginia (Submitted on 2nd Jan 2015)


  10. I am happy with your products.

    Kirt: As you may have noticed, I am happy with your products. Just thought it would be nice to hear from a new customer. I'm currently working my way through the Excel Level 1 and I have to say your instruction is great. The communication and overall presentation is right on! Thanks.

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


Previous | Showing reviews 11-20 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.