Master advanced Excel 2019 techniques in this comprehensive tutorial designed for beginners to experienced users. Explore essential features including named ranges, IF functions, nested functions, VLOOKUP, database functions, and macros. Learn to efficiently navigate, calculate data, sort and filter information, create pivot tables, and automate common tasks. Dive into complex topics such as formula auditing, data consolidation, goal seek, data tables, and scenario management. Enhance your spreadsheet skills, increase productivity, and unlock the full potential of Excel 2019 with hands-on exercises and expert guidance throughout this 1-hour 33-minute course.
Overview
Syllabus
Start
Introduction
Creating & Applying Named Ranges
Navigating with Named Ranges
IF Functions Part 1
IF Functions Part 2
Introduction to Nesting Functions
The Round Function
Formula Auditing Tools
Introduction to VLOOKUP
VLOOKUP
IFERROR
Database Functions – SUMIF & AVERAGEIF
Database Functions – SUMIFS
Text Functions
Consolidate by Position
Consolidate by Category
Goal Seek
Introduction to Data Tables
Data Tables
Scenario Manager
Macros – Adding the Developer Tab
Macros – Recording & Running the Header Macro
Macros – Visual Basic Editor & Form Control
Macros – Adding Macros to the Ribbon
Macros – Exercise
Taught by
Learnit Training
