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 21-29 of 29

  1. Excel 2013 Video Course, the best out there!

    If you want to get ready for your Microsoft Certification Exam for Excel 2013, this is the way to go. This is the most comprehensive video course that I've ever owned. Kirt Kershaw breaks down Excel 2013 making the learning process as easy as taking candy from a baby. This video course covers not only the basics, but it also covers the most complicated features of the application. It is rare to find study material for the Expert Certification Exam for Excel 2013, so I'm thankful for such an affordable quality video course. My friend just paid $300 for an intensive one-day Excel 2013 course, and he only learned the basics. This video course offers three levels, with exercise files, and quizzes, making the learning experience hands on, an important key in learning Excel. The price is less than half a third of what my friend paid, and the videos are mine to revisit as much as I want.

    Edward G. - New York (Submitted on 30th Dec 2014)


  2. Can't imagine finding a better course than this one!

    I had some extra time over this holiday season and decided to brush up on my Excel skills, especially since I had been using a much older software version at work. This set of training videos was perfect! I have learned so many tips and advanced capabilities within Excel. I'd say most clips are between 6 and 9 minutes long, and they are broken down in a very logical manner and one in which you build a little each time you advance in the course. Kirt is the perfect instructor ... he doesn't over- or underwhelm you with information. For most of the training modules you also have access to the Excel data he is working with so that you can go back and practice what you have just learned (this was really important to me!). This would also make a perfect on-the-job reference as you can easily find the topic you need and quickly refresh with the training video at your desk. Can't imagine a better course!

    Andrew E. - California (Submitted on 30th Dec 2014)


  3. Five Stars.

    Easy to follow, trainer goes slow enough to follow. I did really enjoy and learned much from the Excel 2013; I really like your style of training.

    John P. - Michigan (Submitted on 30th Dec 2014)


  4. Easy to follow.

    The training is just what I had hoped for. Easy to follow, helpful, well instructed. I recommend this software to anyone who needs to have a quick trip to readiness or a refresher.

    Mary L. - Florida (Submitted on 30th Dec 2014)


  5. I liked the product.

    I liked the product and the assistance that it was provided was great.

    Leo M. - New York (Submitted on 30th Dec 2014)


  6. Excellent Computer Based Training for all levels of EXCEL.

    This is the best computer based training I have ever had on any level. The author is entertaining, knowledgeable and adds to each lesson no matter what your skill level may be. You will walk away from this training with more knowledge and better prepared to work in Excel 2013.

    Harold B. - Georgia (Submitted on 30th Dec 2014)


  7. Yours are the best!

    By the way, thank you so much for producing such amazing training videos - I have used different online training courses but yours are the best!

    Masayoshi H. - Australia (Submitted on 30th Dec 2014)


  8. Very good training video.

    I've bought it because I have already bought his Access 2007 course and it was good. Always up to the point, very professional. Keep up with good work, thank you!

    Viktor Y. - New York (Submitted on 30th Dec 2014)


  9. Excel 2013 training video is very educating.

    Excel 2013 training video is very educating with thorough explanation of each and every features of Excel. It also covers advance level like pivot tables and macro writing. I have been using Excel from day one when it was competing with Lotus 1-2-3 and I used to write macros in Lotus as well as in Excel. This training video is not only helpful to the beginners but also it points out new locations and features of all the old buttons and menu items of old Excel. Keep up the good work.

    Bharat P. - Montana (Submitted on 30th Dec 2014)


Previous | Showing reviews 21-29 of 29



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.