The Excel Master Class

Excel Essentials: A Step-by-Step Guide to Mastering Microsoft's Most Essential Business Tool

What you'll learn

A full lesson on how to create your own Chat GPT in Excel

Master data analysis techniques, including PivotTables and PowerPivot

Learn how to work with data, including sorting, filtering, and data validation and more

Discover the power of formulas and functions, including VLOOKUP, IF, and SUMIF and many others

Get hands-on experience with real-world projects

Requirements

No Prior Experience required. Come as you are😊.

Description

The Excel Master Class is a comprehensive course that provides you with the skills and knowledge needed to become proficient in using Microsoft Excel. The course is designed for individuals who want to enhance their proficiency in Excel, from beginners to advanced users.Guess What, we have a full lesson on creating your own Chat GPT in Excel.We also offer an optional Certified Certificate (in addition to the Udemy Certificate) from the prestigious International Federation of Accountants (IFA, UK).  The Digital Certificate demonstrates your proficiency in Excel and can be displayed on your resume, LinkedIn profile, or website. The certificate comes at an additional cost of $100.The course is divided into three levels: Beginner, Intermediate, and Advance. Each level builds upon the previous one, gradually introducing you to more advanced features and capabilities of Excel. The course covers a wide range of topics, including creating and formatting worksheets, basic and advanced formulas and functions, pivot tables, macros, VBA programming, data analysis, and much more.The Excel Master Class also includes practical exercises and quizzes to help you apply what you have learned and test your knowledge. The course is self-paced, allowing you to learn at your own speed and convenience.Overall, The Excel Master Class is an excellent investment if you want to master Excel and become more productive in your work and personal life.

Overview

Section 1: LEVEL 1 - BEGINNER

Lecture 1 The Excel Start Up Screen

Lecture 2 Practice Files - Level 1

Lecture 3 The Excel Interface

Lecture 4 Understanding The Excel Workbook

Lecture 5 Save, Save As, etc

Lecture 6 Entering Data into Excel

Lecture 7 Alignment in Excel

Lecture 8 Summation in Excel

Lecture 9 Summation in Excel Cont.

Lecture 10 Relative and Absolute Referencing

Lecture 11 Minimum and Maximum Function

Lecture 12 Average Function

Lecture 13 The Count Function

Lecture 14 Copying and Moving

Lecture 15 Inserting and Deleting Cells

Lecture 16 Deleting Cells, Rows and Columns

Lecture 17 Changing the sizes or Rows and Columns

Lecture 18 Hiding and Unhiding Rows and Columns

Lecture 19 Renaming and moving Sheets

Lecture 20 Formatting in Excel – Introduction

Lecture 21 Formatting – Changing Background

Lecture 22 Formatting – Changing Background 2

Lecture 23 Formatting – Numbers, Currency etc

Lecture 24 Formatting – Adding Borders

Lecture 25 Formatting – Creating Styles

Lecture 26 Formatting – Conditional Formatting

Lecture 27 Formatting – More Borderlines

Lecture 28 Inserting Images and Objects

Lecture 29 Modifying Charts

Lecture 30 Pie Charts

Lecture 31 Formatting Charts

Lecture 32 Yippee Level 1 Complete ??

Section 2: LEVEL 2 - INTERMEDIATE

Lecture 33 Practice Test for Lesson 2

Lecture 34 Introduction to Working with Large Data

Lecture 35 Customizing The Ribbon

Lecture 36 Single Level Sorting(Quick Sorting)

Lecture 37 Multi-Level Sorting (Custom Sorting)

Lecture 38 Special Sorting

Lecture 39 Filtering in Excel

Lecture 40 Subtotal

Lecture 41 Format as Table

Lecture 42 Identifying Duplicates

Lecture 43 Removing Duplicates

Lecture 44 DSUM ( Database Sum)

Lecture 45 DAVERAGE & DCOUNT

Lecture 46 SUB TOTAL

Lecture 47 Data Validation Introduction

Lecture 48 Data Validation Error Messages and Notices

Lecture 49 Dynamic Data Validation

Lecture 50 Data Validation in Action ?

Lecture 51 Pivot Table – Introduction

Lecture 52 Creating Pivot Tables

Lecture 53 Modifying Pivot Tables

Lecture 54 Grouping Pivot Data

Lecture 55 Formatting Pivot Table

Lecture 56 Drilling Down Pivot Tables

Lecture 57 Pivot Charts

Lecture 58 Filtering Pivot Table

Lecture 59 Pivot Table Slicers

Lecture 60 Power Pivot – Introduction

Lecture 61 Activating Power Pivot

Lecture 62 Creating Data Models

Lecture 63 Creating Relationships in Power Pivot

Lecture 64 Creating Pivot Tables from Data Models

Lecture 65 Creating KPIs in Power Pivot

Lecture 66 Level 2 done!!! Go you! Go You!! ?

Section 3: Level 3 Advance

Lecture 67 Practice Test for Lesson 3

Lecture 68 The IF function

Lecture 69 The AND Function

Lecture 70 NESTED Functions

Lecture 71 COUNT IT and COUNT IFs

Lecture 72 SUM IF and SUM IFs

Lecture 73 IF ERROR Function

Lecture 74 V-LOOK UP Introduction

Lecture 75 VLOOKUP Main

Lecture 76 HLOOKUP

Lecture 77 INDEX and MATCH Introduction

Lecture 78 Index and Match in Action

Lecture 79 Index & Match + Data Validation

Lecture 80 Index and Match – Advance

Lecture 81 INDEX and MATCH vs VLOOK-UP

Lecture 82 XLOOKUP

Lecture 83 XLOOKUP Cont.

Lecture 84 Text Based Functions

Lecture 85 What If Analysis

Lecture 86 Data Tables

Lecture 87 Protecting Worksheets in Excel

Lecture 88 You did it ?

Section 4: Level 4 Advance 2

Lecture 89 Non-Traditional use of Excel: Importing list of file names from a Folder

Lecture 90 Chat GPT in Excel - Basic

Lecture 91 Buidling your own Chat GPT into Excel using Chat GPT APIs.

Excel beginners looking to get a solid foundation in the software Intermediate Excel users looking to take their skills to the next level Professionals in any field looking to improve their Excel skills and productivity Students and academics looking to get ahead in their studies or research,Intermediate Excel users looking to take their skills to the next level,Professionals in any field looking to improve their Excel skills and productivity,Students and academics looking to get ahead in their studies or research