Excel 2016 Advanced Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
Dive into advanced Excel 2016 techniques in this comprehensive 2-hour 39-minute tutorial. Master named ranges, complex functions like IF and VLOOKUP, formula auditing tools, and nested functions. Explore data consolidation, Solver tool, Scenario Manager, and Data Tables. Learn to create and edit macros, use the Developer tab, and add macro buttons to worksheets. Ideal for current Excel users looking to enhance their skills, this tutorial progresses from intermediate topics to advanced features, providing practical knowledge for efficient data organization and analysis.
Syllabus
Start
Named Ranges
Creating Named Ranges from Selection
Named Ranges Continued
IF Functions
Formula Auditing Tools
IF Functions Continued
Nesting Functions
VLOOKUP
Autofill VLOOKUP & IFERROR
VLOOKUP Range
VLOOKUP Range with Nested Functions
HLOOKUP
SUMIF
AVERAGEIF
SUMIFS
Date Functions
Text Functions
Consolidating Data
Consolidating Data Without Structure
Complex Solver Tool
Solver Tool
Scenario Manager
Data Table
Turning on the Developer Tab
Recording Macros
Editing Macros in VBA & Recording a Second Macro
Adding Macros to the QA Toolbar
Adding Macro Buttons to the Worksheet
Conclusion
Taught by
Learnit Training
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard