Loading... Please wait...

Excel 2013 Training Videos

Excel 2013 Training Videos

$49.95
SKU
excel2013
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 2013 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 2013 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 2013!

DVD includes Excel 2013 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 2013 Levels 1, 2 & 3 training videos include all the training you need to pass the Excel 2013 Core (77-420) and Expert Part 1 (77-427) and Part 2 (77-428) Exams and become certified!

Excel 2013 Level 1 (4.5+ hrs):

Basics

  1. Excel 2013 Overview (9:46)
  2. Customize Excel Environment (9:33)
  3. Customize Quick Access Toolbar (6:51)
  4. Customize Ribbon (10:14)
  5. Navigating Excel (5:44)
  6. Creating A Basic Worksheet (4:52)
  7. Save & Save As (5:13)
  8. Convert To 2013 (3:44)
  9. Compatibility Checker (5:20)
  10. Convert To Previous Version (6:10)
  11. Excel 2013 Help (2:30)

Functions & Formulas

  1. Basic Formulas A (10:31)
  2. Basic Formulas B (6:13)
  3. SUM & AVERAGE A (9:10)
  4. SUM & AVERAGE B (5:44)
  5. MAX & MIN (4:56)
  6. COUNT & COUNTA (4:01)
  7. Move, Copy & Cut Data (10:33)
  8. Absolute References (7:59)
  9. Mixed References (6:38)
  10. AutoFill (7:58)
  11. FlashFill (3:57)
  12. Text To Columns (3:29)

Editing Worksheets

  1. Editing Data (3:13)
  2. Editing Columns, Rows & Cells (3:55)
  3. Find & Replace (5:29)
  4. GoTo (5:20)
  5. Transpose Data (3:08)
  6. Adjust Columns & Rows (4:40)
  7. Spell Check (2:04)

Formatting

  1. Modifying Fonts (2:45)
  2. Basic Number Formats (5:11)
  3. Basic Customer Number Formats (3:54)
  4. Borders & Colors (7:41)
  5. Formatting Shortcuts (3:16)
  6. Adding Background (1:29)
  7. Align & Positioning Contents (5:46)
  8. Create & Manage Styles (5:15)
  9. AutoFormat (2:30)
  10. Applying Themes (11:00)

Printing

  1. Print Preview (2:34)
  2. Page Orientation (2:25)
  3. Print Titles (5:08)
  4. Headers & Footers (7:09)
  5. Margins (3:15)
  6. Page Breaks (8:33)
  7. Print Range & Scaling (5:27)

Modifying Worksheet Appearance

  1. Managing Worksheets (8:56)
  2. Hide Sheets & Workbooks (5:02)
  3. Split Worksheet (1:37)
  4. Freeze Panes (4:45)
  5. Multiple Worksheet & Workbook Views (3:13)
  6. Formula Options (2:49)
  7. Speak Cells (1:25)

Excel 2013 Level 2 (5+ hrs):

Advanced Formulas

  1. Name Range (11:10)
  2. Version Control (4:06)
  3. Linking Data (5:04)
  4. UPPER, LOWER & PROPER (4:38)
  5. CONCATENATE (3:48)
  6. LEFT, FIND & SEARCH (7:41)
  7. RIGHT, FIND & LEN (6:59)
  8. IF, AND & OR (9:27)
  9. Nested IF (3:20)
  10. IFERROR (2:48)
  11. PMT (2:14)
  12. Display & Print Formulas (2:23)
  13. SUMIF(s), COUNTIF(s) & AVERAGEIF(s) (8:33)
  14. LOOKUP (4:47)
  15. VLOOKUP (6:57)
  16. HLOOKUP (6:53)

Tables

  1. Create Tables (3:21)
  2. Modify Tables (5:20)
  3. Format Tables (1:46)
  4. Custom Table Styles (2:33)
  5. Sorting & Filtering Tables (3:39)
  6. DSUM, DAVERAGE & DCOUNT (8:18)
  7. Time Functions (6:55)
  8. Database Design Flaws & Sorting (7:18)
  9. AutoFilter (4:00)
  10. Advanced Filter A (9:42)
  11. Advanced Filter B (6:46)
  12. Subtotals (6:33)

Charts

  1. Create Charts (10:31)
  2. Modify Charts (11:16)
  3. Trend Lines (2:55)
  4. Chart Axis Titles (4:06)
  5. Format Chart (10:29)
  6. Dual Axes Chart (5:47)
  7. Chart Template (1:22)
  8. Chart Sharing (2:15)

PivotTable & Charts

  1. Create PivotTables (11:20)
  2. Customize PivotTables (7:39)
  3. Slicers A (6:54)
  4. Slicers B (5:55)
  5. Create PivotCharts (5:27)

Graphics

  1. Insert & Modify Pictures (3:25)
  2. Clip Art (2:28)
  3. Draw & Modify Shapes (6:44)
  4. SmartArt Graphics (5:01)
  5. Layering & Grouping Objects (4:38)

Customize

  1. Insert & Modify Comments (7:36)
  2. Hyperlinks (8:32)
  3. Web Research (3:04)
  4. Watermarks (5:46)
  5. Customize Themes (8:08)
  6. Advanced Themes (3:53)
  7. Workbook Templates (2:51)
  8. Custom Templates (3:48)

Excel 2013 Level 3 (4.5+ hrs):

Workbook

  1. Properties (8:08)
  2. Custom Views (4:27)
  3. Macros A (11:44)
  4. Macros B (10:16)
  5. Edit Macro (2:21)
  6. Absolute & Relative References (3:26)
  7. Conditional Formatting A (10:46)
  8. Conditional Formatting B (3:57)
  9. Data Validation (6:48)
  10. Quick Analysis (2:46)

Collaborating

  1. Protect Worksheets (5:26)
  2. Password Protect Cells (4:24)
  3. Document Inspector (3:39)
  4. Protect Structure & Windows (1:11)
  5. Password To Open And/Or Modify (4:38)
  6. Always Create Backup (5:17)
  7. Share Workbook (7:30)
  8. SkyDrive A (10:33)
  9. SkyDrive B (2:04)
  10. SharePoint Sharing A (8:04)
  11. SharePoint Sharing B (3:34)
  12. Track Changes (5:51)
  13. Protect & Share Workbook (4:29)
  14. Merge Workbooks (4:07)
  15. Digital ID A (7:44)
  16. Digital ID B (7:37)
  17. Mark As Final (2:32)

Audit Worksheets

  1. Tracer Errors & Arrows (5:02)
  2. Troubleshoot Invalid Data (4:33)
  3. Watch Window & Evaluate Formulas (4:27)
  4. Outline & Group Data (6:36)

Analyzing Data

  1. Sparklines (6:15)
  2. Scenario Manager (6:18)
  3. Goal Seek (5:01)
  4. Solver (10:30)
  5. Random Samples (5:51)
  6. RAND (3:40)
  7. Descriptive Statistics (2:37)
  8. Power View (8:31)

Import & Export Data

  1. Consolidating Data (7:24)
  2. Link Workbooks (10:06)
  3. Export To Word (4:52)
  4. Import Text File (4:32)
  5. PowerPivot (4:30)
  6. Publish To Web (4:20)
  7. Import From Web (7:29)
  8. XML (10:55)
  9. Advanced Custom Number Format (7:38)
  10. Camera (4:24)
Excel 2013 Training Videos

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

Find Similar Products by Category

Product Reviews

Write your own product review

Previous | Showing reviews 11-20 of 29 | Next

  1. I'm using this to take the 2013 MOS certification.

    These videos are great! Learning much faster than following a dull textbook.

    Dan P. - Texas (Submitted on 11th Feb 2015)


  2. This Video Trainer on Excel 2013 Is Well Worth The Money.

    This video trainer is especially valuable to people like me who need to manipulate/process data skillfully using Excel 2013, however, actually only use that tool occasionally. I love the processing power offered with Excel but don't use it everyday and often need a refresher and/or clear explanation of the steps required to carry out very specific tasks. To me, Kirt Kershaw and the Excel 2013 Training Video offers the "method of choice" to enable one to learn or re-learn specific Excel tasks in a time frame that is most convenient. Kirt is clear and easy to listen to communicator, and his explanations for a whole host of common tasks are detailed and complete.

    John P. - New York (Submitted on 6th Feb 2015)


  3. From the very beginning Kirt Kershaw made the training fun and easily understandable,

    I purchased the Video Trainer for Excel 2013 after viewing some online tutorials and not grasping various aspects of the program. From the very beginning Kirt Kershaw made the training fun and easily understandable. The lesson duration is just the right size in order to grasp each and every concept in an easily understandable way. I highly recommend this Video Trainer if you are interested in learning Excel 2013.

    Cary G. - New York (Submitted on 6th Feb 2015)


  4. The best of the best!

    By-far, the most valuable and trust-worthy instructional DVD people I know! Learned so much great concepts, techniques, and tools -- I bought ACCESS 2013! Assignments, quizzes, you name it! FOR ... SAKE, GIVE THIS PEOPLE A TROPHY!

    Amin M. - Virginia (Submitted on 5th Feb 2015)


  5. I would buy others in the future

    I have been working with the video for the past few weeks in order to pass the Excel certification. It has been very informative, and is very well organized.

    Michael C. - Virginia (Submitted on 5th Feb 2015)


  6. Superb Training.

    The Excel 2013 Trainer Video is a life saver for me. I was so happy to find and purchase the Excel 2013 Video Trainer and not have to attend several courses at a training facility or community college for a substantial cost. This training video provides you the convenience to learn Excel at your own pace to achieve your comfort level of working with Excel. The trainer speaks clearly at a moderate speed, explains each step thoroughly as you view each keystroke, mouse click, or movement on the screen. The length of time the trainer teaches each lesson is adequate to cover the topic. There are additional exercises that assist in applying the knowledge you gained in the training. Overall, a great product that teaches Excel effectively!

    Thelma P. - Maryland (Submitted on 30th Dec 2014)


  7. Perfect Way To Add To Your Skills.

    If you think you know how to use Excel then you're exactly the person that needs this training video. I use Excel at work for Construction Estimating. I thought I had a handle on all the features - I wasn't even close. Trust me, buy the Training Video. You'll be happy that you did.

    James D. - New York (Submitted on 30th Dec 2014)


  8. I'm enjoying the Video Trainer Excel 2013!

    When do you think you will release Word, PowerPoint and Outlook 2013?

    Julie M. - Texas (Submitted on 30th Dec 2014)


  9. Great Product.

    I got this product and think it's a wonderful product. It will take you from a novice user to an advanced user. I have tried other products to learn Excel like books and other video products and within a few days I had forgotten what I had just learned, with the test I was able to retain 90% of what I had just learned. This product is just superior to other items on the market. I liked everything about this product and didn't find any dislikes. I would highly recommend this product to anyone who wants or needs to learn Excel 2013.

    Ken R. - Illinois (Submitted on 30th Dec 2014)


  10. Terrific!

    So far what I have viewed is terrific!

    Debbie C. - Florida (Submitted on 30th Dec 2014)


Previous | Showing reviews 11-20 of 29 | 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 2013 Training Videos to your wish list.