Excel 2019 Expert Tutorial



20
233748

Excel 2019 Expert Tutorial 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. For ad free training and certificates please join Learnit Anytime: https://www.learnitanytime.com Enroll in our live, instructor-led Excel classes: https://bit.ly/3rwKfUf For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops Join our online community! - https://www.offsitebylearnit.com Start 0:00 Introduction 0:03 Creating & Applying Named Ranges 1:24 Navigating with Named Ranges 9:42 IF Functions (Part 1) 11:26 IF Functions (Part 2) 15:17 Introduction to Nesting Functions 18:07 The Round Function 22:16 Formula Auditing Tools 25:39 Introduction to VLOOKUP 29:40 VLOOKUP 33:58 IFERROR 36:13 Database Functions – SUMIF & AVERAGEIF 38:37 Database Functions – SUMIFS 42:42 Text Functions 46:13 Consolidate by Position 53:17 Consolidate by Category 57:34 Goal Seek 1:00:31 Introduction to Data Tables 1:03:22 Data Tables 1:06:25 Scenario Manager 1:07:45 Macros – Adding the Developer Tab 1:12:28 Macros – Recording & Running the Header Macro 1:14:42 Macros – Visual Basic Editor & Form Control 1:20:29 Macros – Adding Macros to the Ribbon 1:25:02 Macros – Exercise 1:27:38 #Excel (C) 2021 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.

Published by: Learnit Training Published at: 3 years ago Category: آموزشی