Excel 2016 Level 3 (Download)

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

Description

Propel Your Microsoft Excel Skills to an Advanced Level 

Take your Microsoft Excel skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Excel at an advanced level. You will learn how to work with additional Excel features including: macros, advanced conditional formatting, digital signatures, power view and consolidating data.

Using my 18+ years of Microsoft Excel training and Certification I will guide you through these advanced Excel features and become an Excel Expert.  Below are just a few of the topics that you will master:

  • Advanced Conditional Formatting using functions, or formulas
  • Get more accurate data entry using Data Validation
  • View another part of your worksheet simultaneously with Watch Window
  • Easily manage various levels of data in a hierarchical structure using Group and Outline
  • Summarize larges amounts of data using Excel’s Consolidating Data feature
  • Set criteria to color, add text and, or symbols to your cells with Advanced Custom Number Formats
  • and much, much, more…

Excel 2016 Level 3 training videos download comes in MP4 (.mp4) file format, with follow along exercise files, instructor notes, quiz and answers! Our Excel 2016 Level 3, with Levels 1 & 2 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 3 (4.5+ hrs):

Workbook

  1. Properties (8:26)
  2. Custom Views (4:32)
  3. Macros A (11:41)
  4. Macros B (12:25)
  5. Edit Macro (2:29)
  6. Absolute & Relative References (3:47)
  7. Advanced Conditional Formatting (5:26)
  8. Quick Analysis (1:21)

Collaborating

  1. Data Validation (9:00)
  2. Protect Worksheets (5:06)
  3. Password Protect Cells (3:45)
  4. Document Inspector (5:09)
  5. Protect Workbook Structure (1:45)
  6. Password To Open And/Or Modify (5:43)
  7. Always Create Backup (4:46)
  8. Share Workbook (9:40)
  9. OneDrive (13:36)
  10. Track Changes (8:42)
  11. Protect & Share Workbook (3:27)
  12. Merge Workbooks (4:56)
  13. Digital Signatures or ID A (8:33)
  14. Digital Signatures or ID B (7:08)
  15. Mark As Final (2:08)

Audit Worksheets

  1. Tracer Errors & Arrows (4:25)
  2. Troubleshoot Invalid Data (3:07)
  3. Watch Window & Evaluate Formulas (5:45)
  4. Outline & Group Data (7:09)

Analyzing Data

  1. Sparklines (6:24)
  2. 3D Map (10:33)
  3. Data Table (4:49)
  4. Scenario Manager (5:17)
  5. Forecast Sheet (2:55)
  6. Goal Seek (2:25)
  7. Solver (5:01)
  8. Random Samples (5:16)
  9. RAND (4:17)
  10. Descriptive Statistics (2:10)
  11. Power View (9:10)

Import & Export Data

  1. Consolidating Data (6:35)
  2. Link Workbooks (9:50)
  3. Form Data (2:54)
  4. Export Data (6:17)
  5. Import Text File (3:19)
  6. Power Pivot (4:52)
  7. Publish to Web (4:28)
  8. XML (8:45)
  9. Advanced Custom Number Format (7:54)
  10. Camera (2:42)

 

Excel 2016 Level 3 Training Videos (Download)

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

View AllClose