Microsoft Excel Masterclass: Beginner to Advanced Training

This video dives into the advanced features of Excel that can help streamline your workflows and make more informed decisions based on data.

This video explains a few basic Excel functions, for example, SUM, MIN, MAX, and AVERAGE.

This video provides a practical understanding of cell referencing.

In this video, the instructor continues explaining cell referencing and named ranges.

This video covers the Name Manager tool in Excel.

This video explains how to use the LOWER, UPPER, and PROPER text functions

This video provides a practical understanding of the LEFT, RIGHT, MID, and CONCATENATE functions.

The video explains the TRIM function with examples.

The video dives into the LEN function and provides an example to show how it works.

This video provides an explanation of the SEARCH function with an example.

This video shows how to use math functions like ROUNDUP, ROUNDDOWN, and ROUND.

This video explains the MROUND function in detail by showing an example.

This video explains how to use the SUMPRODUCT and POWER functions.

This video provides a practical understanding of the MOD function.

This video explains date and time functions, for example, DATEVALUE, NOW, and TIMEVALUE, with the help of examples.

This video explains other date and time functions, for example, WEEKDAY and MONTH.

The video provides a practical understanding of the DATEDIF function.

This video explains the DATE function with the help of an example.

This video offers a detailed understanding of the TIME function.

This video provides a practical understanding of the IF function.

This video explains the nested IF function.

This video provides a practical understanding of two logical functions — OR and AND.

This video dives into SUMIF, AVERAGEIF, and COUNTIF and provides examples.

This video provides a practical understanding of SUMIFS, COUNTIFS, and AVERAGEIFS.

This video explains the VLOOKUP function with the help of an example.

This video provides another example of VLOOKUP to improve learners’ understanding of the Excel function.

This video dives into the fourth parameter in VLOOKUP.

This video explains the HLOOKUP function.

This video explains how to use the LOOKUP function and how it differs from the VLOOKUP and HLOOKUP functions.

This video explains the INDEX function with the help of an example.

This video provides a practical understanding of the MATCH function in Excel.

This video explains two-way lookup with the INDEX and MATCH functions.

This video helps in understanding how to utilize the ISERROR and IFERROR functions for error handling purposes.

This video explains the CHOOSE function in Excel.

This video helps learners understand how to utilize the INDIRECT function with the help of an example.

This video provides another example of using the INDIRECT function to help individuals better understand it.

This video explains the OFFSET function in Excel with the help of an example.

This video explores the XLOOKUP function from a theoretical standpoint and explains how it differs from VLOOKUP.

This video shows how the XLOOKUP function works with the help of a practical example.

This video continues to explain the XLOOKUP function and explores the match mode and search mode.

This video explains how to use the XLOOKUP to do a two-way lookup.

This video explains the data validation feature in Excel.

This video shows some examples of data validation to help build a practical understanding.

This video improves one’s understanding of how data validation works.

This video explains how to create a cascading list using data validation and the INDIRECT function.

This video shows how to use the advanced filter in Excel.

This video explains how to work with more features of the advanced filter tool in Excel.

This video shows how to apply the advanced filter using wildcard characters.

This video shows how to apply the filter with complex criteria.

This video shows how to use certain functions with the advanced filter.

This video shows number and text custom formatting.

This video dives into different types of advanced custom formatting using numbers and texts.

This video shows how to custom format dates.

This video provides an introduction to conditional formatting and how to do it based on text and duplicate values.

This video shows how to do conditional formatting on a numerical cell.

This video explains the different types of formatting that one can apply to cells based on conditions.

This video provides an understanding of conditional formatting based on complex rules.

This video provides an introduction to what-if analysis and how it works.

This video explains the goal seek tool in what-if analysis.

This provides a practical understanding of a scenario manager, which is another what-if analysis tool.

This video dives into the meaning of pivot tables, their uses, components, and advantages.

This video explains how individuals can create pivot tables in MS Excel.

This video provides a clear understanding of how to work with pivot tables.

This explores the grouping capabilities of pivot tables.

This video explains how data is filtered in Excel with the help of pivot tables.

This video dives into calculated fields and calculated columns.

This video shows how to filter data using timelines and slicers.

This video explains the process of creating pivot tables from multiple ranges in different worksheets.

This video provides practical understanding of how to use the GETPIVOTDATA function

This video shows how to get the other values using the PIVOTDATA function.

This video explores the visual representation of data utilizing sparklines.

This video provides a practical understanding of pivot charts.

This video continues the explanation regarding pivot charts.

This video talks about the drill down feature of pivot tables.

Unlock Excel's hidden potential with powerful hacks. Learn to automate tasks, import data, and optimize your workflow. This course works with all Excel versions, making your work faster and more efficient.

Learn how to link text boxes to worksheet cells in Excel. Automate updates and make dynamic headers or callouts effortlessly. A simple trick to enhance interactivity and streamline your workflow.

Stop deleting empty rows manually. Learn a quick and efficient way to remove blank rows in Excel using 'Go To Special' and a simple shortcut. Save time and streamline your workflow.

Manually filling blank cells? There's a faster way. Learn how to quickly fill all empty cells in Excel with a specific value using 'Go To Special' and a simple shortcut.

Manually filling blank cells? There's a faster way. Learn how to quickly fill all empty cells in Excel with a specific value using 'Go To Special' and a simple shortcut.

Discover Excel’s hidden Camera Tool. Learn how to take live snapshots of data from multiple sheets, place them in one view, and keep them updated automatically for printing or dashboards.

Easily navigate large Excel workbooks with shortcuts. Use Ctrl + Page Up to move left and Ctrl + Page Down to move right between sheets. Save time and work efficiently.

Quickly switch between open Excel workbooks using Ctrl + Tab. Move seamlessly between multiple files without using your mouse. A simple shortcut to boost efficiency in Excel.

Add a dynamic average line to your Excel charts for better data comparison. Learn how to automate it using formulas, making visual analysis easy and efficient.

Use Excel's Clipboard to store multiple copied items and paste them anytime, even after exiting copy mode. A handy trick to streamline your workflow!

Create custom autofill lists in Excel for repetitive data entry and sorting! Save time by defining lists like North, South, East, West, or custom size orders for better sorting.

Learn quick calculations in Excel! Just select cells, and the status bar shows sum, average, and count instantly. Right-click the bar to add min/max for even more insights!

Learn Excel data entry shortcuts: Ctrl + ; for today's date, Ctrl + ' to copy the cell above, and Ctrl + Shift + ; for the current time. Speed up your workflow!

Learn to group worksheets in Excel: Hold Ctrl, select multiple sheets, make edits, and apply changes to all at once. Saves time when formatting or adding headers!

Learn to add a calculator to Excel: Go to Quick Access Toolbar > More Commands > All Commands, select Calculator, and add it. Now, launch it instantly from Excel!

Learn to use AutoCorrect to replace shortcuts with full text! Go to File > Options > Proofing > AutoCorrect Options, add a custom entry, and it works across Excel, Word, and Outlook!

Learn to use the hidden DATEDIF function to calculate the difference between two dates! Format: =DATEDIF(start_date, end_date, "D") for days, "M" for months, or "Y" for years!

Learn to use SUMPRODUCT to multiply and sum in one step! Just type =SUMPRODUCT(range1, range2), and Excel will do all the calculations for you—no extra formulas needed!

Learn how to use array formulas in Excel to perform calculations across multiple cells in one step. This module covers array-based calculations, including multiplication and discounts, using Ctrl + Shift + Enter for efficiency.

Learn to enhance your Excel skills by applying conditions to the SUMPRODUCT function. Learn how to filter data by category before summing, using an asterisk (*) as a separator for criteria-based calculations.

Learn how to use the OFFSET function in Excel to create dynamic ranges for calculations and charts. See how OFFSET helps update data selections automatically, making charts interactive.

Learn how to use Spin Control in Excel to dynamically update charts. See how to link a spin button to a cell, set limits, and create an interactive data display.

Learn how to import data from a website into Excel using Get Data from Web. See how to establish a live connection, refresh data, and manage external data sources efficiently.

Learn how to transpose data in Excel effortlessly. Convert rows into columns and vice versa using the Paste Special → Transpose feature. A quick and easy way to restructure your data.

Discover the power of the F9 key in Excel to evaluate and debug formulas instantly. Learn how to check partial calculations and audit formulas efficiently using this simple yet powerful trick.

Learn how to create and use Custom Views in Excel to save time when hiding and unhiding rows and columns. Easily switch between different views for efficient data analysis!

Discover the Excel Start Folder and how to use it to automatically open specific files every time Excel launches. A great time-saving hack for frequently used templates and macros!

Learn how to record and use macros in Excel to automate repetitive tasks. Save time by running multiple steps with a single click or shortcut key!

Learn a quick trick to convert text to numbers in Excel using Paste Special. Fix imported data issues and enable calculations instantly!

Learn how to use Flash Fill in Excel to quickly extract first names, last names, or domains from text. A must-know trick for data cleanup!

Get a quick overview of Excel Power Pivot! Learn how it helps you work with large datasets, build relationships, and create complex calculations. Understand where Power Pivot fits in and how it enhances your data analysis workflow.

Wondering which Excel versions support Power Pivot? Learn how to activate it and discover the key differences between Power Pivot and Pivot Tables. See why Power Pivot is a game-changer for handling large datasets and complex calculations!

Learn how to create Pivot Tables using Excel tables and the Power Pivot data model! See how to load data, work with external sources, and generate reports efficiently. Master the basics before diving into advanced Power Pivot features!

Explore the Power Pivot interface in Excel! Learn about key features like the Manage button, Data Model, KPIs, and Relationships. Understand how to load, model, and prepare data before creating Pivot Tables. Get a complete overview of Power Pivot’s ribbons, settings, and views!

Learn how Power Query and Power Pivot work together in Excel! Understand how Power Query fetches and transforms data from external sources, while Power Pivot helps with data modeling, relationships, and calculations. See how these tools complement each other to create powerful data visualizations using Pivot Tables, Pivot Charts, and Power BI!

See Power Query and Power Pivot in action! In this practical demo, learn how to load external data into Power Query, transform it (remove columns, change data types, calculate age, and round values), and then load it into Power Pivot for data modeling. Finally, watch how to create a Pivot Table in Excel to generate insightful reports!

Learn to import data from Access into Power Pivot, filter fields before and after import, and manage data efficiently.

Learn about Data Model Manager, tables, relationships, and data tables in Power Pivot. Understand how data models improve reporting and reduce redundancy.

Learn to design a data model using Power Pivot. Create relationships between tables to generate reports without merging data manually.

Learn to create relationships in Power Pivot. Use drag-and-drop or the "Create Relationship" tool to link tables for accurate reports.

Understanding relationships in Power Pivot: Learn how primary and foreign keys connect tables, enabling meaningful reports. Normalization reduces redundancy!

Learn about DAX (Data Analysis Expressions) powers Power Pivot, enabling calculated columns & measures. Unlike Excel, DAX functions work on entire tables & relationships!

Learn DAX syntax in Power Pivot! Understand how to write DAX formulas, use fully qualified column names, follow naming rules, and create calculated columns. Master DAX for Power BI, Power Pivot & Excel!

Learn where to use DAX formulas in Power Pivot! Understand calculated columns, measures, and relationships between tables. See how to create and use them in Pivot Tables for dynamic data analysis.

Understand DAX operators! Learn about arithmetic, comparison, logical, IN, and text concatenation operators used in DAX formulas. Get ready to apply them in calculated columns and measures effectively.

Learn how to create calculated columns in Power Pivot using DAX formulas. Understand row-level calculations, text functions like LEFT, RIGHT, CONCATENATE, and SEARCH to derive new column values.

In this module, we discuss creating calculated columns using text functions like LEFT, MID, RIGHT, CONCATENATE, and SEARCH to extract and manipulate data from existing columns in a table.

Explore DAX measures in Power Pivot. Learn the difference between calculated columns and measures, how to create explicit and implicit measures, and how they dynamically generate values in a pivot table.

Learn about Key Performance Indicators (KPIs) in Power Pivot. Understand how KPIs provide visual performance measures, and see how to create and use them to evaluate sales targets and employee performance.

Learn how to use basic logical functions in DAX, such as IF, AND, OR, and ISBLANK. Understand how these functions can help you create calculated columns based on conditions, with practical examples like determining price remarks and mileage categories.

In this module, learn how to use the AND, OR, and ISBLANK functions in DAX to enhance your data analysis. Explore practical examples like creating vehicle remarks based on conditions and handling missing data with ISBLANK. See how to use these logical functions in pivot tables for dynamic reporting.

In this module, we explore the SWITCH function in DAX, which provides a simpler alternative to multiple nested IF statements. Learn how to use SWITCH to evaluate expressions and return specific results based on conditions, both with static values and more complex checks. Practical examples include creating weekday names from week numbers and categorizing delivery charges as low, medium, or high.

In this module, we learn about iterator functions in DAX, such as SUMX and MAXX, which iterate through each row of a table to evaluate expressions and apply aggregations like sum, max, or min.

In this module, we discuss the RANKX function, which ranks values in a table based on an expression. It offers options for ordering (ascending/descending) and handling ties (skip/dense)

Learn how to use filter functions like CALCULATE in Power Pivot to create dynamic measures, apply filters, and evaluate expressions based on specific conditions in this detailed tutorial.

In this module, we explore the FILTER function, which filters and returns a table based on specific conditions. Learn how it differs from CALCULATE and its impact on pivot table results.

In this module, we explore the ALL filter function, which removes any applied filters on a table or column, allowing you to calculate unfiltered totals. Learn how to use it in measures and pivot tables.

Learn about the RELATED function in Power BI to pull data from related tables. Understand how it works like VLOOKUP and integrates with table relationships for enriched data modeling.

Learn about the RELATEDTABLE function in Power BI to change context and evaluate table expressions with filters. Understand how it counts related rows based on table relationships.

Explore basic DAX date and time functions like DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, and more. Learn how they help in time intelligence calculations for data analysis.

Learn how to create a date table in Power Pivot to work with DAX time intelligence functions. Understand its importance for calculating comparisons like sales over different periods.

In this module, we explore time intelligence functions in DAX, specifically the Year-to-Date (YTD), Quarter-to-Date (QTD), and Month-to-Date (MTD) functions. These functions help in calculating cumulative values for a given period, making it easier to analyze data across time.

In this module, we explore the Dates in Period function, which is another time intelligence function in DAX. This function allows you to create a table of dates starting from a specified start date and spanning a specified number of intervals, which can be in days, months, quarters, or years.

In this module, we delve into the Dates Between time intelligence function in DAX, which is used to filter and calculate values over a specified range of dates.

This video explains why a date table is necessary for time intelligence functions.

Power Query in Excel helps import, clean, transform, and reshape data from various sources. Learn the 4 phases: connect, extract, transform, and load, plus techniques like append and merge for combining data.

Exploring Power Query Editor for data transformation and cleaning, including how to load, view, and modify data before loading it into Excel

Learn how to filter data, change data types, and remove columns using Power Query to clean and transform your data before loading it into Excel.

Learn how to apply transformations like uppercase conversion, trimming spaces, and replacing values. Also, explore how to edit steps and rename them for better clarity in Power Query.

Learn how to add new columns, format data, and use conditional functions in Power Query. Create new columns like "Age" from birth dates, and categorize employees into age groups. This module covers loading data into Excel, performing transformations, and generating reports using PivotTables.

In this module, you'll learn how to combine tables using various types of joins in Power Query, including inner, outer, and anti joins, with practical examples to clarify each type.

In this module, we dive into Power Query joins with practical demonstrations. You'll see how inner, outer, and anti joins work using employee and department data, showing different ways to merge tables.

In this module, we learned about Power Query append operation, which combines two queries into one by adding rows from the second query to the first based on matching column names.

In this module, we learned how to append data from employee Feb to employee Jan while maintaining department names by adjusting merge and append steps in Power Query.

In this module, we learned how to create custom calculations by adding calculated columns, such as total earnings and tax, using existing data in Power Query without altering the original dataset.

In this module, we learned about grouping records in Power Query, like summing salaries or counting employees by department or job, and how to perform advanced group by calculations for summary reports.

In this module, we explored pivoting and unpivoting data in Power Query. Pivoting turns row values into columns, while unpivoting reverses this process, converting columns back into rows.

In this module, we discussed how to clean data in Power Query. Data cleaning involves transforming raw data into a structured format for analysis. We covered removing unwanted rows, filtering out subtotals, filling null values, and unpivoting columns to prepare the data for analysis.

This module covers loading data from various sources into Excel using Power Query: SQL Server, CSV, web, XML, JSON, and Excel tables. Each source has unique formats for importing.

To load data from SQL Server into Excel, go to Power Query, select "From Database," choose SQL Server, enter server and database details, and load the desired table into Excel.

To load data from a CSV file into Excel, go to Power Query, select "From File," choose "From CSV," pick the file, and transform or directly load the data into Excel.

To load data from the web, copy the URL, go to Power Query, select "From Web," paste the URL, choose the relevant table, clean and transform the data, then load it into Excel.

To load data from XML, go to "New Query" > "From File" > "From XML," select the file, and Power Query will automatically convert the hierarchical data into a tabular format for Excel.

This module shows how to load JSON data into Excel using Power Query. JSON data is in key-value pairs, and Power Query automatically converts it into a table for easy manipulation.

This module teaches how to load and manipulate data from an Excel table using Power Query. You convert ranges into tables, load them into Power Query, and apply changes like adding calculated columns.

This video explains how to combine multiple files from multiple or the same sources in Power Query.

This video dives into date and time manipulation in Power Query.

This video continues explaining date and time manipulation in Power Query.

This video discusses some Power Query commands, for example, remove duplicate data, group data, and fix country-specific formatting.