Ms Excel Mastery: New & Powerful Functions For Smart Work

Update your Excel Knowledge with Dynamic Arrays, XLOOKUP, Advanced Logical & Statistical Functions to Boost Efficiency.

What you'll learn

Know the Hidden Power of the Powerful Functions.

Master 25+ Advanced Functions in Just 3 Hours!

No Need for CTRL + SHIFT + ENTER for Array Functions.

Replacement of VLOOKUP & HLOOKUP with XLOOKUP.

Master Dynamic Array Functions: Learn SEQUENCE, RANDARRAY, SORTBY, UNIQUE, FILTER, and SORT to organize and manage data dynamically.

Feel the Magic of FLASHFILL.

Simplify Complex Logic with IFS and SWITCH etc.

Utilize EOMONTH, NETWORKDAYS, and WORKDAY functions for streamlined scheduling and date management.

Use statistical functions like FORECAST, CORREL, and TREND to forecast trends and correlate data.

Comprehensive Excel Skills: Update your Excel Knowledge, tailored for students and professionals alike.

Requirements

Some functions discussed in this course are available exclusively in MS Office 365.

The remaining functions are also available in Excel 2019.

Description

IntroductionUnlock the full potential of Excel with our comprehensive Excel Mastery course. Designed for students and professionals alike, this course covers advanced functions and techniques to enhance your productivity.These Hidden gems are untapped features that save time and boost efficiency.Dynamic Array FunctionsYou'll learn to master dynamic array functions like SEQUENCE, RANDARRAY, SORTBY, UNIQUE, FILTER, and SORT. These functions allow you to organize and manage data dynamically, making your tasks more efficient and adaptable.Lookup & Reference FunctionsDiscover the power of XLOOKUP, FLASHFILL, and XMATCH for accurate data retrieval. These functions simplify the process of finding and matching data, reducing errors and saving valuable time.Text JoiningSeamlessly join text from multiple cells to present your data cleanly and readably. The TEXTJOIN function will be your best friend in achieving this.Date & Time FunctionsStreamline your scheduling with date and time functions like EOMONTH, NETWORKDAYS, and WORKDAY. These functions help you easily calculate due dates and manage project timelines.Advanced Logical FunctionsSimplify complex logical formulas with IFS and SWITCH. These advanced logical functions allow you to handle multiple conditions with ease, making your data analysis more sophisticated and precise.Statistical FunctionsDive into statistical functions to forecast trends, correlate data, and perform in-depth analysis. Functions like FORECAST, CORREL, and TREND will provide valuable insights for data-driven decisions.This course is your ticket to saving time, working smarter, and mastering Excel's hidden capabilities.Enhance your Excel skills, boost your efficiency, and become an Excel expert with our comprehensive training.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: SEQUENCE

Lecture 2 Sequence: Inputs Simplified

Lecture 3 Getting Started: Basic Applications

Lecture 4 Generating Dynamic Date Ranges

Lecture 5 Creating a Calendar

Lecture 6 Generating Sequential Time Intervals

Section 3: RANDARRAY

Lecture 7 Ranadarray: Inputs Simplified

Lecture 8 Getting Started: Basic Applications

Lecture 9 Creating Strong Passwords.

Lecture 10 Randomized Team Generation

Section 4: SORTBY

Lecture 11 Sortby Function Tutorial: Organize Your Data Like a Pro.

Lecture 12 Excel Sortby Function: Essential Inputs Explained.

Lecture 13 Multi-Criteria Data Sorting.

Lecture 14 Dynamic Sorting with User Input.

Section 5: UNIQUE

Lecture 15 Unique Function: Simplify Your Data

Lecture 16 Essential Inputs Explained–Part I

Lecture 17 Essential Inputs Explained–Part II

Lecture 18 Finding Unique Combination.

Lecture 19 Dynamic Dropdown List.

Section 6: FILTER

Lecture 20 Getting Started with the Filter Function in Excel

Lecture 21 Basics of Using the Filter Function.

Lecture 22 Combining Multiple Criteria.

Lecture 23 Handling No Matching Data.

Section 7: SORT

Lecture 24 Inputs Explained

Lecture 25 Comprehensive Guide to SORT Function

Section 8: XLOOKUP

Lecture 26 Deep Dive into XLOOKUP: Understanding Inputs

Lecture 27 Basic XLOOKUP Applications: A Beginner's Guide

Lecture 28 TWO Way Lookup

Lecture 29 Handling Missing Values

Lecture 30 Approximate Match

Lecture 31 Wildcard Lookup

Lecture 32 Finding the Last Matching Value

Lecture 33 Conditional Lookup

Section 9: FLASHFILL

Lecture 34 Seamless Merging Using Flash Fill.

Lecture 35 Quick & Easy Name Separation with Flash Fill

Lecture 36 Crafting Names from Email Addresses with Flash Fill.

Section 10: XMATCH

Lecture 37 Essential Inputs Explained.

Lecture 38 Basic & Reverse Order Lookup

Lecture 39 Wild Card searches.

Section 11: TEXTJOIN

Lecture 40 Comprehensive Guide on Text Join Function

Section 12: EOMONTH

Lecture 41 EOMONTH Function Explained: Practical Applications

Section 13: NETWORKDAYS, WORKDAY & VSTACK

Lecture 42 VSTACK: Stack Your Data with Ease

Lecture 43 Efficiently Calculating Workdays with NETWORKDAYS.

Lecture 44 Simplifying Date Calculations with WORKDAY

Section 14: IFS

Lecture 45 Excel IFS Function: Simplifying Conditional Logic for Beginners

Lecture 46 Taking Conditional Formulas to the Next Level.

Section 15: SWITCH, AND & OR

Lecture 47 Basic Uses of AND & OR Functions

Lecture 48 Advanced Uses of AND & OR Functions

Lecture 49 Excel SWITCH Function: Streamlining Conditional Formulas

Lecture 50 Applications of SWITCH for Dynamic Pricing.

Lecture 51 Unlocking the Full Potential of the SWITCH Function in Excel.

Section 16: SUMIFS & COUNTIFS

Lecture 52 SUMIF & COUNTIF Functions Explained

Lecture 53 Excel SUMIFS & COUNTIFS: Advanced Data Analysis Techniques

Section 17: PERCENTILE.EXC & PERCENTILE.INC

Lecture 54 Understanding Percentile Functions: PERCENTILE.INC vs. PERCENTILE.EXC

Lecture 55 Practical Applications of Excel's Percentile Functions

Section 18: TREND

Lecture 56 Understanding Its Inputs for Accurate Forecasting.

Lecture 57 Using the TREND Function in Everyday Analysis.

Section 19: CORREL

Lecture 58 CORREL Function Essentials: Insights and Applications.

Section 20: FORECAST.

Lecture 59 Comprehensive Analysis of FORECAST.LIN and FORECAST.ETS Functions.

Lecture 60 FORECAST.ETS.CONFINT Function Explained: Detailed Guide and Applications.

Lecture 61 Mastering FORECAST.ETS.SEASONALITY: From Basics to Practical Applications.

Lecture 0 Course Recap and Next Steps

This course is designed for all Excel users, from students to employees, to help you achieve your tasks efficiently and intelligently