Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel 2016 Advanced Tutorial

Learnit Training via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course on Excel 2016 Advanced Tutorial aims to teach learners how to utilize advanced features and functions in Microsoft Excel. By the end of the course, students will be able to work with named ranges, IF functions, VLOOKUP, HLOOKUP, SUMIF, AVERAGEIF, SUMIFS, date functions, text functions, data consolidation, Solver Tool, Scenario Manager, Data Table, and Macros. The teaching method includes video tutorials with hands-on exercises. The course is designed for individuals currently using Microsoft Excel or those looking to enhance their Excel skills.

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

Reviews

Start your review of Excel 2016 Advanced Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.