800.978.9790
 Loading... Please wait...


  • Image 1

Excel 2010 Training Videos

$49.95
SKU:
excel2010v
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at checkout
Quantity:

Product 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), Excercise 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
.

Product Reviews

Write Review

Showing reviews 1-10 of 43 | Next

  1. 4 Star Review Educational

    Posted by on 26th Feb 2016

    I have lean so much, it has help me a great deal with my job

  2. 5 Star Review Another great training video.

    Posted by on 20th Oct 2015

    The Training video's by Kirt Kershaw of Dream Force LLC keep getting better with each training video he puts out. Excel 2010 is a very comprehensive training video broken down into small easy to follow sessions that even come with sample work sheets with data used in the training video's to follow along with. This is a great addition. Excel 2010 by Kirt Kershaw is an extensive training program. It covers everything you need to know about how to use this fun and powerful Microsoft product. If this is the first time you are using excel, Kirt takes you through the basics and if you follow all three levels of the video lessons, when you are done with this Excel 2010 you will be quite efficient using the Excel 2010 program and will be classified as an advanced user, the go to person for excel 2010. Even when you finish you always have the DVD at your fingertips to review and refresh for features you do not use often but need to use now. This training DVD on Excel 2010 become an invaluable reference source. If you are looking for a training DVD for Excel 2010 or any of the Microsoft Office programs, look no further, you found it with Kirt Kershaw Excel 2010 training video. This is a wonderful learning DVD. I highly recommend this and all Kirt Kershaw training video's. This turned out to be the best investments I have made for learning Excel 2010. I have since purchased the entire collection of Kirt Kershaw training programs include the latest Microsoft Windows 7 which I just upgraded to from Windows XP. It quickly brought me up to speed with Microsoft new operation system. Even if you are already knowledgeable in using the Microsoft programs, you can still learn from these videos. I have watched them all from level 1 to level III, and I learned new techniques and time-saving tips that I've missed and did not know from other training videos. Kirt Kershaw's training videos are the best out there, and his teaching style and the level of detail are unmatched in my opinion. He breaks it down and explains in detail with real world examples. Even if you have limited or no experience using the Microsoft video training programs by Kirt from DreamForce LLC you will learn them and soon master them and become the go to person in how to use the Microsoft program you are learning. The videos are broken down are into small and short lessons. You learn at your own pace. Even after watching the training videos, I still refer back to them often as you do a reference book when you need a refresher course or just want to review something that you haven't done in a while or for review if you didn't master them the first time. I highly recommend, Kirt Kershaw of Dream Force LLC., training videos to anyone who is just starting out, or wants to be more proficient with the Microsoft office suite, or starting up to the new Microsoft Windows 7 operating system. You will soon become an expert and the go to person from friends and family. Keep up the good work Kirt Kershaw and please keep those video training programs coming.

  3. 5 Star Review Thank you for the Excel 2010 training video.

    Posted by on 20th Oct 2015

    Dear Kirt: I just want to sincerely thank you for the Excel 2010 training video. Earlier, I was waiting for your Word 2010 word processing video and really wanted a speedy release. Although I went on the website to try and find another training video (because you weren’t sure when the word processing video would be released), I found that the voices of other instructors were not as engaging as yours. Anyways, I inadvertently decided to "kill time" by buying the Excel 2010 training video first, and it has been "life-altering" and "life-changing." I am a matrimonial lawyer and while I have a Childview program (popular for child and spousal support ...), I had been using primarily a table in WordPerfect and using a basic summation function for tables. When I started dipping into your first few lessons and realized what the potential of that training can do (the power of the ability to designate coordinates in a formula anywhere on a sheet), honestly, I just wanted to "beam down" (okay, fly over) to Utah and give you an "Excel dance and hug." I can't even believe how I functioned the last 18 years of my practice without Excel. It's really hard for me to get away for a whole day and take Excel Level 1 at some community college. I love the fact that when I can't follow a concept, I can "rewind" and pause to take notes. I love the round yellow pointer, your humor and your ability to recognize how students can go wrong and how to "back track." Your voice is quite captivating. I don't fall asleep like I do with other videos (eg. PC Law!). Now, I recently found out that they are teaching Excel in Grade 5 and Powerpoint in Grade 3 (Social Studies).... I really want to thank you for giving me that opportunity to "catch up" with the rest of the world without going back to elementary school! Most senior family law lawyers do not know Excel, and I feel I am developing a great skill, "slightly" ahead of the pack. I am now thinking of just going on Excel at the first client interview with a computer in the boardroom to draft a spreadsheet right off the bat instead of taking notes. I think back to all the data I had to add in past cases (eg. polygamies with multi family members' incomes, credit card statements to prove income evasion, etc., for over a decade of tax returns on numerous parties) and wondered why I didn't know Excel then! The only stumbling block for me on Excel was when I went past Rows 21, 22 and I typed in numbers, only to find dates appearing. I found that very frustrating and wondered why these cells were so "psychotic" until someone at the office here told me to format the cells as numbers (that's in a later video clip). Anyways, I just want to encourage you to keep going. The wait is totally worth it. Thanks so much. I don't want to take up more of your time reading my long email, even though I can go on and on. Thank you so much again!! I feel like I was incarcerated for the last 10 years and then released to find out I can't even use today's modern calculator, Excel, until Kirt Kershaw came along. Honestly, I have tremendous gratitude towards you. So, please keep teaching. It is a privilege for me to learn from you. I am telling all my friends about your videos.

  4. 5 Star Review Great product.

    Posted by on 20th Oct 2015

    Definitely recommended for anyone who wish to learn Excel 2010.

  5. 5 Star Review Best excel video ever, way better than books.

    Posted by on 20th Oct 2015

    I'm a moderate skilled excel user and got benefit from even the beginning lessons. Excited to see what advance skills I can pick up. Highly recommended.

  6. 5 Star Review Very Useful.

    Posted by on 20th Oct 2015

    The Excel 2010 training Videos delivered on every point of interest: - Transitioning from 2003 to 2010 - Learning new tools - Improving analysis methods. Whether your need is to cover Excel overall or to selectively study certain aspects of Excel usage, this is a useful and cost-effective product.

  7. 5 Star Review I like the excel tutorial.

    Posted by on 20th Oct 2015

    You are a good instructor.

  8. 5 Star Review Excellent video.

    Posted by on 20th Oct 2015

    Thank you for such beautiful pictured videos.

  9. 5 Star Review I recommend it.

    Posted by on 20th Oct 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.

  10. 5 Star Review Fantastic training videos.

    Posted by on 20th Oct 2015

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

Showing reviews 1-10 of 43 | Next

Find Similar Products by Category