Excel 2010 Training Videos

(42 reviews) Write a Review
SKU:
excel2010
UPC:
013964082029
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at Checkout
  • Excel 2010 Training Videos
$49.95

Description

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
.

View AllClose

42 Reviews

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

    Posted by Ivy C. - California on 2nd Jan 2015

    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!

  • 5
    It's a great product, I learned a lot.

    Posted by Matsaerh D. - New Jersey on 2nd Jan 2015

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

  • 5
    Amazing product!

    Posted by Elaine H. - Georgia on 2nd Jan 2015

    Amazing product!

  • 5
    Best training videos ever!!

    Posted by Sam O. - California on 2nd Jan 2015

    These training videos saved my life! Seriously! If I didn't pass an Excel exam for school, my degree progress would've been thrown way off track. The videos are extremely well done and easy to watch. Kirt Kershaw is a great teacher. I learned so much, and I am so glad I discovered this program. Thank you!!!!!

  • 5
    Wonderful Training Series.

    Posted by Jason K. - Pennsylvania on 2nd Jan 2015

    I recently purchased the Excel 2010 Training Videos made by Kirt Kershaw in preparation for taking Microsoft Exam 77-882 to get MOS certified. The product was sent very quickly, and I was very excited to start. I opened up the package and started to play the DVD in my computer. It only took minutes to figure out that lots of the flash videos, WMV files, and PDFs would not open up and read as corrupt - much to my disappointment. I then got on Google and found the phone number and email address for Dream Force LLC. I contacted them about the problem, and the response was near immediate. Once they realized that I received a faulty disc, they told me that they would be sending another disc via next-day shipping. The customer service was outstanding. It is really no wonder that they have an A+ rating with the BBB. The new DVD arrived promptly, and all of the features worked just fine. The actual video series is extremely thorough, and I am learning some very interesting features of Excel 2010 even in the beginner sections. Kirt is an excellent teacher, and I will be sure to recommend this product to anyone else trying to further their knowledge of using Excel for personal use or, like in my case, to advance in my business field. My employers are ecstatic about what I'm learning, and my ability to use Excel as a customer database that can be cross analyzed in a variety of ways with formulas I am learning. My only regret is purchasing the Excel videos only, instead of the entire Microsoft Office 2010 package. Because of how he teaches and has tons of practice files to follow along with, I am now planning on taking my education further, until I have been MOS (Microsoft Office Specialist) certified, MOS-Expert certified, and MOS-Master certified. Wonderful product, and wonderful company to deal with!

  • 5
    Excellent product!

    Posted by Robert R. - New Jersey on 2nd Jan 2015

    Excellent product!

  • 5
    Fantastic training videos.

    Posted by Ronald G. - California on 2nd Jan 2015

    Very informative and easy to follow. As the saying goes...you get what you pay for. Well. I got my monies worth.

  • 5
    I recommend it.

    Posted by Anthony A. - Colorado on 2nd Jan 2015

    I liked it, allowed me to select what I wanted, by item. I think it was easy to move from topic to topic, as a visual learner I was able to follow the list or jump around. I have been a casual user of Excel for a long time and I was able to pick up things about 10 that I would have missed. Thanks.

  • 5
    Excellent video.

    Posted by Stephen D. - United Arab Emirates on 2nd Jan 2015

    Thank you for such beautiful pictured videos.

View AllClose