800.978.9790
 Loading... Please wait...


  • Excel 2016 Training Videos - Level 2

Excel 2016 Level 2 (Download)

$14.95
Quantity:

Product Description

Excel 2016 Level 2 training videos download comes in MP4 (.mp4) file format, with follow along exercise files, instructor notes, quiz and answers! Our Excel 2016 Level 2, with Levels 1 & 3 training videos include all the training you need to pass the Excel 2016 Core (77-727) and Expert (77-728) Exams and become certified!

Excel 2016 training videos will explain first what a database is, and then the foundation of the database which are tables. After you'll want to learn how to quickly extract and enter your data in an organized format by using forms. Also, you'll be shown how fun and easy it is to create reports, a way to extract your data from your tables and into a printable format.

Learn to create relationships between tables including the most popularly misunderstood one-to-one relationship, and more by our Microsoft Certified Trainer training Excel 2016!

Excel 2016 Level 2 (5.5+ hrs):

Advanced Formulas

  1. Create Name Cell & Ranges (9:07)
  2. Version Control (1:36)
  3. Linking Data (3:58)
  4. UPPER, LOWER & PROPER (3:36)
  5. CONCATENATE (3:53)
  6. LEFT, FIND & SEARCH (7:14)
  7. RIGHT, FIND & LEN (5:01)
  8. MID (1:17)
  9. AND & OR (3:57)
  10. IF (3:21)
  11. Combined or Nested Functions (5:35)
  12. IFERROR (3:32)
  13. PMT (1:58)
  14. Display & Print Formulas (1:54)
  15. SUMIF(s), COUNTIF(s) & AVERAGEIF(s) (6:01)
  16. CONVERT (0:58)
  17. MATCH & INDEX (3:57)
  18. LOOKUP (3:56)
  19. VLOOKUP (8:17)
  20. HLOOKUP (9:09)

Tables

  1. Single & Multiple Array Formulas (3:48)
  2. Create Tables (3:31)
  3. Modify Tables (6:20)
  4. Format Tables (1:21)
  5. Custom Table Styles (2:18)
  6. Sorting & Filtering Tables (5:24)
  7. DSUM, DAVERAGE & DCOUNT (9:54)
  8. Date & Time Functions A (9:14)
  9. Date & Time Functions B (3:57)
  10. Sorting & Top Database Design Flaws (7:24)
  11. AutoFilter (4:39)
  12. Advanced Filter A (9:14)
  13. Advanced Filter B (7:13)
  14. Subtotals (6:30)

Charts

  1. Create Charts (10:43)
  2. Modify Charts (11:41)
  3. Trend Lines (2:32)
  4. Chart & Axis Titles (5:27)
  5. Format Chart (11:52)
  6. Dual Axis Chart (5:16)
  7. Chart Templates (1:55)
  8. Chart Sharing & Embedding (2:17)

PivotTable & Charts

  1. Create PivotTables (12:27)
  2. Customize PivotTables (11:59)
  3. PivotTable Slicers A (7:34)
  4. PivotTable Slicers B (5:50)
  5. Create PivotCharts (7:18)

Graphics

  1. Insert & Modify Pictures (7:27)
  2. Draw & Modify Shapes (9:32)
  3. SmartArt Graphics (5:11)
  4. Layering & Grouping Objects (6:14)

Customize

  1. Insert & Modify Comments (9:20)
  2. Hyperlinks (8:26)
  3. Watermarks (4:49)
  4. Customize Themes (6:33)
  5. Intermediate Conditional Formatting (3:26)
  6. Custom Workbook Templates (5:17)

 

Excel 2016 Level 2 Training Videos (Download)

Excel 2016 Level 2 Training Videos (Download) from Dream Force — training videos solutions.
Affordable Excel 2016 Level 2 Training Videos (Download)
.

Product Videos

Excel 2016 Convert Text to Upper, Lower, or Proper Case using Formulas 03:42

Excel 2016 tutorial on how to convert your text to upper, lower or even proper case. Proper case being able to convert the first letter to upper case or being capitalized. Training done by Microsoft Certified Trainer and Excel 2016 Specialist and Expert.

  • Excel 2016 Con...
    Excel 2016 tutorial on how to convert your text to upper, low...

Product Reviews

Write Review

This product hasn't received any reviews yet. Be the first to review this product!

Find Similar Products by Category