Excel 2016 Level 2 (Download)

(No reviews yet) Write a Review
On Sale
MSRP: $14.95
Now: $9.95
Was: $14.95
— You save $5.00

Description

Go Beyond Excel Basics

Take your Microsoft Excel skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Excel at an intermediate level. You will learn how to work with additional Excel features including: advanced formulas, tables, charts and PivotTables and PivotCharts.

Using my 18+ years of Microsoft Excel training and Certification I will guide you through these more advanced features used by many offices to more easily manage their daily schedules and tasks.  Below are just a few of the topics that you will master:

  • Name your own cell and ranges of cells for faster and more familiar referencing
  • Learn popular functions including: PROPER, CONCATENATE, LEFT, FIND, IF, SUMIF, VLOOKUP and more!
  • Create, modify and format tables including filtering and sorting its records
  • Calculate dates and time with Date & Time functions
  • Create and modify charts including adding trendlines, and dual axis
  • Manage large amounts of data quickly with PivotTables and visually with PivotCharts
  • Insert, draw and modify pictures and shapes including object layering and grouping
  • And much, much more!

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!

Learn this and much 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)
.

View AllClose