Play all

Start

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

Description:

Dive into advanced Excel 2019 techniques in this comprehensive tutorial designed for beginners to experienced users. Master named ranges, complex functions like IF and VLOOKUP, database functions, and text manipulation. Explore data consolidation methods, utilize Goal Seek and Scenario Manager for data analysis, and automate tasks with macros. Learn to create data tables, use formula auditing tools, and customize the Excel interface. Enhance your spreadsheet skills, increase efficiency, and tackle complex data management tasks with confidence. Includes hands-on exercises and practical examples to reinforce learning.

Excel 2019 Advanced Tutorial

Learnit Training

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Spreadsheets #Pivot Tables #Macros #VLOOKUP #Goal Seek

0:00 / 0:00