Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Excel 2019 Advanced Tutorial

Learnit Training
956K subscribers
842K views 5 years ago Excel Training
Excel 2019 Advanced Tutorial Get Ad-Free Training by becoming a member today!    / @learnittraining   Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://bit.ly/36ZPKzO Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel. What it is: Microsoft’s spreadsheet application used to clean and organize data. What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we qui …...more
...more

Start

0:00

Introduction

0:03

Overview of List Design

1:02

Formatting Lists as Tables

4:47

Filtering Records from Lists or Tables

6:45

Removing Duplicates from Lists or Tables

10:19

Flash Fill

13:40

Single & Multi-Level Sorting

16:50

Inserting Automatic Subtotals in Lists

21:27

Inserting Data Charts Using Recommended Charts

27:36

Formatting & Editing Chart Elements

32:28

Creating & Applying Custom Chart Templates

36:58

Adding & Removing Data from Charts

40:38

Inserting Sparklines

43:23

Printing Charts

48:52

Inserting Pivot Tables

49:57

Filtering Pivot Tables

55:04

Using Report Layouts in Pivot Tables

59:58

Refreshing & Changing Source Data in Pivot Tables

1:03:05

Inserting Pivot Charts

1:07:21

Data Validation

1:09:18

Applying Built-In Conditional Formatting

1:14:12

Creating Custom Conditional Formats

1:17:26

Linking Data

1:20:23

Comments

1:24:41

Protection

1:26:56
Excel 2019 Advanced Tutorial
Excel 2019 Advanced Tutorial Get Ad-Free Training by becoming a member today!    / @learnittraining   Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://bit.ly/36ZPKzO Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel. What it is: Microsoft’s spreadsheet application used to clean and organize data. What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks. Start 0:00 Introduction 0:03 Overview of List Design 1:02 Formatting Lists as Tables 4:47 Filtering Records from Lists or Tables 6:45 Removing Duplicates from Lists or Tables 10:19 Flash Fill 13:40 Single & Multi-Level Sorting 16:50 Inserting Automatic Subtotals in Lists 21:27 Inserting Data Charts Using Recommended Charts 27:36 Formatting & Editing Chart Elements 32:28 Creating & Applying Custom Chart Templates 36:58 Adding & Removing Data from Charts 40:38 Inserting Sparklines 43:23 Printing Charts 48:52 Inserting Pivot Tables 49:57 Filtering Pivot Tables 55:04 Using Report Layouts in Pivot Tables 59:58 Refreshing & Changing Source Data in Pivot Tables 1:03:05 Inserting Pivot Charts 1:07:21 Data Validation 1:09:18 Applying Built-In Conditional Formatting 1:14:12 Creating Custom Conditional Formats 1:17:26 Linking Data 1:20:23 Comments 1:24:41 Protection 1:26:56 #Excel (C) 2021 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.
67 lessons
Excel Training
Learnit Training

Course progress

0 of 67 lessons complete

Follow along using the transcript.

Learnit Training

956K subscribers