Loading... Please wait...

Excel 2016 Level 3 (Download)

Excel 2016 Level 3 (Download)

$14.95

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 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!

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 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)
.

Find Similar Products by Category

Product Reviews

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

Write your own product review



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 2016 Level 3 (Download) to your wish list.