Главная
Study mode:
on
You
History
Saved
In progress 0 courses
compleat 0 courses
#Art & Design #Adobe #ChatGPT #GitHub

#Power Query

Showing: 78 courses
ExcelIsFun

Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools

14 rewiews
Learn Excel data analysis using Power Tools: formulas, PivotTables, Power Query, Power Pivot, and Power BI. Create reports, dashboards, and visualizations for effective business decision-making with real-world datasets.
Add to list
11 Lesons
6 hours
On-Demand
Free-Video
Simon Sez IT

Data Cleaning in Excel - Text Functions and Power Query

7 rewiews
Learn essential data cleaning techniques in Excel using text functions and Power Query. Master importing, formatting, and manipulating data for accurate analysis and improved efficiency.
Add to list
17 Lesons
1 hour 8 minutes
On-Demand
Free-Video
ExcelIsFun

How to Build Excel Dashboard - PivotTable, Chart, Conditional Formatting

3 rewiews
Learn to create an Excel dashboard using Power Query, PivotTables, charts, and DAX measures. Master data modeling, conditional formatting, and dynamic updates for effective data visualization and analysis.
Add to list
20 Lesons
36 minutes
On-Demand
Free-Video
Simon Sez IT

Excel Power Query - Power Query Tutorial for Beginners

1 rewiews
Learn Power Query in Excel: import, transform, and combine data from multiple sources. Master essential techniques for efficient data analysis and manipulation.
Add to list
16 Lesons
1 hour 49 minutes
On-Demand
Free-Video

PowerBI

3 rewiews
Learn to harness PowerBI for business intelligence, from installation to advanced data transformation techniques using Power Query, enhancing your data analysis skills.
Add to list
12 Lesons
2 hours 30 minutes
On-Demand
Free-Video
Microsoft

Azure Data Factory Power Hour - Latest Updates and Demos

0 rewiews
Exclusive Azure Data Factory updates and demos, including Power Query integration, managed virtual networks, Teams notifications, and user-assigned managed identities for enhanced data integration capabilities.
Add to list
8 Lesons
1 hour 1 minute
On-Demand
Free-Video
ExcelIsFun

Text Formulas & Functions in Excel Worksheet and Power Query

0 rewiews
Comprehensive tutorial on Excel text functions and Power Query, covering formulas, data extraction, error handling, and data cleaning techniques for efficient spreadsheet management.
Add to list
37 Lesons
34 minutes
On-Demand
Free-Video
ExcelIsFun

Date & Time Formulas & Functions in Excel Worksheet and Power Query

0 rewiews
Aprenda fórmulas e funções avançadas de data e hora no Excel e Power Query, incluindo cálculos de dias úteis, atributos fiscais e manipulação de períodos para análises eficientes.
Add to list
25 Lesons
51 minutes
On-Demand
Free-Video
ExcelIsFun

Excel & Power BI Data Analysis Complete Class in One Video

0 rewiews
Comprehensive guide to data analysis using Excel and Power BI, covering essential tools and techniques for importing, transforming, visualizing, and sharing data effectively.
Add to list
40 Lesons
3 hours 44 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Statistical Analysis - Introduction to Probability, Power Query & Pivot Table Example

0 rewiews
Aprenda os fundamentos de probabilidade em Excel, incluindo experimentos aleatórios, espaço amostral, combinações e permutações. Aplique conceitos em exemplos práticos de negócios usando Power Query e Tabelas Dinâmicas.
Add to list
33 Lesons
44 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Statistical Analysis - 5-Number Summary - Box & Whiskers Chart - Power Query & Array Formulas

0 rewiews
Aprenda a criar análises estatísticas avançadas no Excel usando Power Query, fórmulas de matriz e gráficos Box & Whiskers para visualizar e interpretar conjuntos de dados complexos.
Add to list
23 Lesons
26 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Statistical Analysis - Location, Mean, Median, Mode, Moving Average, Skew & More

0 rewiews
Comprehensive guide to Excel statistical analysis, covering mean, median, mode, moving averages, and skew. Includes practical examples using Power Query, PivotTables, and dynamic arrays for data visualization and interpretation.
Add to list
25 Lesons
40 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions

0 rewiews
Master PivotTables and Power Query for creating frequency distributions from various data types. Learn efficient techniques for data import, transformation, and analysis in Excel.
Add to list
34 Lesons
36 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Data Analysis - PivotTables, Power Query, Formulas and Charts

0 rewiews
Learn essential Excel data analysis techniques using PivotTables, Power Query, formulas, and charts. Master importing data, creating reports, and visualizing trends for effective business insights.
Add to list
15 Lesons
36 minutes
On-Demand
Free-Video
ExcelIsFun

Excel for Accountants - PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts Seminar

0 rewiews
Comprehensive Excel seminar for accountants covering essential functions, PivotTables, data analysis, and Power Query. Enhance your skills with practical examples and real-world applications.
Add to list
14 Lesons
2 hours 22 minutes
On-Demand
Free-Video
ExcelIsFun

Standard Deviation with Criteria - Power Query, PivotTable, or Array Formula

0 rewiews
Learn advanced Excel techniques for calculating standard deviation using Power Query, PivotTables, and array formulas. Master data analysis with practical examples and step-by-step guidance.
Add to list
6 Lesons
26 minutes
On-Demand
Free-Video
ExcelIsFun

Import Multiple Excel Files & Sheets into Excel - Power Query Get & Transform

0 rewiews
Learn to import and combine multiple Excel files and sheets using Power Query, create PivotTables, and automate data updates for efficient analysis and reporting.
Add to list
7 Lesons
30 minutes
On-Demand
Free-Video
ExcelIsFun

MIN & MAX Functions for Alphanumeric - Text Values Report

0 rewiews
Learn 8 methods to find MIN and MAX alphanumeric values in Excel, including VLOOKUP, array formulas, AGGREGATE, MINIFS/MAXIFS, Power Query, and SQL, with practical examples and explanations.
Add to list
10 Lesons
32 minutes
On-Demand
Free-Video
ExcelIsFun

Backwards One to Many Relationship Report - Excel, Power Query or SQL?

0 rewiews
Learn advanced Excel techniques for calculating average GPA across related tables using array formulas, DAX, Power Query, and SQL. Master data analysis skills for complex relationships.
Add to list
6 Lesons
31 minutes
On-Demand
Free-Video
ExcelIsFun

Time Between Starting College & Taking 1st Geology Class - 6 Methods

0 rewiews
Learn six Excel methods to calculate time between starting college and taking first geology class, from basic functions to advanced Power Query solutions.
Add to list
7 Lesons
27 minutes
On-Demand
Free-Video
ExcelIsFun

Data Analysis Fundamentals - PivotTables, Power Query & Data Model

0 rewiews
Master Excel data analysis with PivotTables, Power Query, and Data Model. Learn sorting, filtering, and advanced techniques to handle large datasets efficiently and create insightful reports.
Add to list
37 Lesons
1 hour 43 minutes
On-Demand
Free-Video
ExcelIsFun

Basic Excel Business Analytics - Clean & Transform Data - Formulas, Flash Fill, Power Query, Text To Columns

0 rewiews
Aprenda técnicas avançadas para limpar e transformar dados no Excel, incluindo fórmulas, Flash Fill, Power Query e Text to Columns, preparando-os eficientemente para análise.
Add to list
14 Lesons
30 minutes
On-Demand
Free-Video
ExcelIsFun

Running Total in Column - Power Query, DAX or Worksheet Formula?

0 rewiews
Learn to create running totals in Excel using worksheet formulas, Power Query, and DAX. Master expandable ranges and cumulative calculations for overall and monthly totals.
Add to list
11 Lesons
31 minutes
On-Demand
Free-Video
ExcelIsFun

Two Fact Tables - DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table

0 rewiews
Learn techniques to convert two fact tables into one using Excel formulas, DAX in Power Pivot, and Power Query in Power BI. Master data modeling and analysis skills for improved business reporting and decision-making.
Add to list
52 Lesons
1 hour 5 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query - Reduce Data Model Size, Transformations to Columnar Database Size

0 rewiews
Learn strategies to optimize data model size using Power Query transformations, enhancing efficiency for big data analysis and business intelligence with columnar databases.
Add to list
24 Lesons
25 minutes
On-Demand
Free-Video
ExcelIsFun

Data Modeling - VLOOKUP, Power Query or Power Pivot?

0 rewiews
Learn data modeling techniques using VLOOKUP, Power Query, and Power Pivot for efficient data analysis in Excel. Explore methods for handling multiple tables and creating effective PivotTable reports.
Add to list
17 Lesons
45 minutes
On-Demand
Free-Video
ExcelIsFun

The Magic of Power Query to Import, Transform & Load Data

0 rewiews
Learn to import, clean, and transform data using Power Query in Excel. Master techniques for efficient data handling, report creation, and automated updates.
Add to list
10 Lesons
27 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Spreadsheet Formulas - Old School or Dynamic Arrays?

0 rewiews
Learn to use Excel formulas for data analysis, comparing traditional methods with dynamic arrays. Master SUMIFS, COUNTIFS, and AVERAGEIFS for creating effective summary reports.
Add to list
15 Lesons
30 minutes
On-Demand
Free-Video
ExcelIsFun

Power BI Desktop Comprehensive Introduction - Power Query, DAX, Dashboards, Publishing

0 rewiews
Comprehensive Power BI Desktop tutorial covering data import, DAX formulas, dashboard creation, and report publishing. Master essential skills for effective data analysis and visualization.
Add to list
50 Lesons
1 hour 20 minutes
On-Demand
Free-Video
ExcelIsFun

Mysteries of VLOOKUP Function Revealed - Amazing Examples

0 rewiews
Comprehensive tutorial on VLOOKUP function in Excel, covering 15 examples from basic to advanced usage, including exact and approximate matches, dynamic tables, and error handling.
Add to list
18 Lesons
1 hour 9 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query Complete M Code Introduction - Values, Let, Lookup, Functions, Parameters, More

0 rewiews
Comprehensive introduction to M Code in Power Query, covering values, expressions, functions, and advanced techniques for efficient data manipulation and analysis.
Add to list
14 Lesons
1 hour 7 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query Group By Feature and Table.Group Function - Examples

0 rewiews
Learn Power Query's Group By feature with five practical examples, including calculating totals, standard deviation, joining names, and ranking sales.
Add to list
14 Lesons
31 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query - 6 Types of Joins, 6 Types of Merges - 9 Examples

0 rewiews
Explore Power Query's 6 types of joins and merges through 9 practical examples, enhancing your data analysis skills in Excel with step-by-step guidance.
Add to list
14 Lesons
38 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query - Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook

0 rewiews
Master Excel's Power Query to efficiently append tables, handle recursion issues, and manipulate data using advanced functions like Excel.CurrentWorkbook and Table.ColumnNames.
Add to list
39 Lesons
28 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query - Import Multiple Excel Files and Combine into Proper Data Set

0 rewiews
Learn to import and combine multiple Excel files using Power Query, create a unified dataset, and build dynamic PivotTable reports with automated updates when new files are added.
Add to list
21 Lesons
32 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query Introduction - Importing & Transformation Data in Excel & Power BI Desktop

0 rewiews
Comprehensive introduction to Power Query for data importing, cleaning, and transformation in Excel and Power BI Desktop, with practical examples and hands-on exercises.
Add to list
6 Lesons
57 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data

0 rewiews
Transform invoice data into a star schema using Power Query, creating a single fact table for improved reporting and analysis in Power BI Desktop.
Add to list
21 Lesons
26 minutes
On-Demand
Free-Video
ExcelIsFun

Introduction to Power Query & Power Pivot Data Model in Excel 2016

0 rewiews
Learn to clean data, create PivotTables, and use Power Query and Power Pivot in Excel 2016. Master data transformation, import large datasets, and build efficient data models for advanced analysis.
Add to list
8 Lesons
50 minutes
On-Demand
Free-Video
ExcelIsFun

Excel for Accountants - Power Query & PivotTables to Import & Clean Data and Build Reports

0 rewiews
Learn to import, clean, and analyze data using Power Query and PivotTables. Master techniques for efficient data management, creating insightful reports, and optimizing file size in Excel for accounting purposes.
Add to list
11 Lesons
51 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query Count & Extract Customer Names for 8 Sales Coupon Groups

0 rewiews
Learn advanced Power Query techniques to analyze customer coupon usage across multiple stores, including counting and extracting customer names for various coupon groups.
Add to list
22 Lesons
27 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set

0 rewiews
Learn to use Power Query in Excel for data cleaning, transformation, and analysis. Master importing, combining, and refreshing data from various sources to create proper datasets and pivot tables.
Add to list
24 Lesons
31 minutes
On-Demand
Free-Video
Simon Sez IT

Getting Started in Power BI - Microsoft Power BI Tutorial for Beginners

0 rewiews
Comprehensive introduction to Power BI, covering installation, data import, query merging, table relationships, and date handling. Learn to create dynamic dashboards and reports for data analysis and visualization.
Add to list
16 Lesons
1 hour 32 minutes
On-Demand
Free-Video
Data Science Dojo

Power BI Crash Course for Beginners

0 rewiews
Learn to import, analyze, and visualize data using Power BI Desktop. Master data cleaning, DAX, Power Query, and create insightful visualizations for effective business intelligence.
Add to list
6 Lesons
1 hour 10 minutes
On-Demand
Free-Video
ExcelIsFun

Visualizing Data and Building Dashboards in Excel & Power BI

0 rewiews
Comprehensive guide to data visualization and dashboard creation in Excel and Power BI, covering various chart types, PivotTables, Power Query, and advanced techniques for effective data presentation.
Add to list
22 Lesons
1 hour 42 minutes
On-Demand
Free-Video
ExcelIsFun

All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples

0 rewiews
Comprehensive guide to Excel lookup formulas, covering XLOOKUP, FILTER, XMATCH, INDEX, and more. Includes examples in Excel, Power Query, and DAX for exact and approximate matches.
Add to list
36 Lesons
1 hour 19 minutes
On-Demand
Free-Video
ExcelIsFun

Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More

0 rewiews
Master Excel's logical functions, formulas, and advanced features. Learn to create powerful data analysis tools using PivotTables, conditional formatting, and Power Query for efficient data management.
Add to list
34 Lesons
1 hour 48 minutes
On-Demand
Free-Video
Teacher's Tech

Intermediate Microsoft Excel Tutorial - How to Use Power Query

0 rewiews
Learn Power Query in Excel: Import, transform, and consolidate data efficiently. Master data cleaning, column manipulation, merging tables, and formula creation for streamlined data management.
Add to list
16 Lesons
37 minutes
On-Demand
Free-Video
Simon Sez IT

Microsoft Power BI Beginner to Intermediate Course - Data Visualization Training

0 rewiews
Comprehensive training on Power BI covering data import, query manipulation, visualization creation, and report design. Learn to create interactive dashboards and gain practical skills in business intelligence.
Add to list
45 Lesons
4 hours 44 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query Group By - Complete Lesson with 10 Examples

0 rewiews
Comprehensive tutorial on Power Query's Group By feature, covering basic to advanced applications with 10 practical examples for data analysis and calculations in Excel.
Add to list
18 Lesons
34 minutes
On-Demand
Free-Video
Teacher's Tech

Microsoft Power BI Desktop for Beginners - 4-Step Tutorial

0 rewiews
Comprehensive tutorial guiding beginners through Power BI Desktop, from installation to publishing. Learn data import, transformation, integration, and visualization techniques to create insightful dashboards.
Add to list
7 Lesons
28 minutes
On-Demand
Free-Video
ExcelIsFun

Microsoft Data Analysis Tools: Excel, Power Query, Power BI, Dataflow, DAX and M Code

0 rewiews
Comprehensive tutorial on Microsoft data analysis tools, covering Excel, Power Query, Power BI, and more. Learn formulas, data modeling, and visualization techniques for effective data analysis.
Add to list
14 Lesons
1 hour 46 minutes
On-Demand
Free-Video
ExcelIsFun

Microsoft Data Analysis Tools: Excel, Power Query, Power BI, Dataflow, DAX, and M Code

0 rewiews
Comprehensive tutorial on Microsoft data analysis tools, covering Excel, Power Query, Power BI, and more. Learn to import, transform, and visualize data using various techniques and formulas.
Add to list
14 Lesons
1 hour 44 minutes
On-Demand
Free-Video
SQLBits

Power Query in 20 Minutes - How it Works

0 rewiews
Explore Power Query's internals and gain a deeper understanding of this increasingly prevalent tool in Power BI and Fabric technologies.
Add to list
1 Lesons
19 minutes
On-Demand
Free-Video
ExcelIsFun

Excel 365 for Teaching: Dynamic Arrays, XLOOKUP, Power Query and PivotTables

0 rewiews
Streamline teaching tasks with Excel 365: master dynamic arrays, XLOOKUP, Power Query, and PivotTables for efficient gradebooks, budgets, and data analysis.
Add to list
10 Lesons
52 minutes
On-Demand
Free-Video
SQLBits

Query Folding in Power Query: Importance for Performance

0 rewiews
Discover query folding's importance for Power Query performance and learn factors that can hinder its effectiveness.
Add to list
1 Lesons
21 minutes
On-Demand
Free-Video
Simon Sez IT

Advanced Excel 365 Training: Dynamic Arrays, Complex Lookups, and Power Tools

0 rewiews
Boost data analysis skills with advanced Excel 365 features. Master dynamic arrays, complex lookups, custom functions, Power Pivot, and Power Query for efficient data manipulation and management.
Add to list
38 Lesons
3 hours 8 minutes
On-Demand
Free-Video
PASS Data Community Summit

Business Analytics Marathon - Tools for Exploratory Data Analysis

0 rewiews
Explore essential tools for data analysis, including Power Query and Pivot Tables, with practical demos and insights into machine learning applications.
Add to list
12 Lesons
1 hour
On-Demand
Free-Video
PASS Data Community Summit

Create Amazing 3D Topographic Maps in Excel

0 rewiews
Create stunning 3D topographic maps in Excel using Power Query and 3D Maps. Learn practical applications and advanced techniques for data visualization and analysis.
Add to list
12 Lesons
1 hour 2 minutes
On-Demand
Free-Video
PASS Data Community Summit

Text Analytics API with Cognitive Services - Achieving AI Analytics

0 rewiews
Learn to analyze feedback using Azure Cognitive Services, transforming data from Dynamics 365 to create insightful models and gain valuable AI-driven analytics insights.
Add to list
10 Lesons
52 minutes
On-Demand
Free-Video
PASS Data Community Summit

Power Query and Power BI - Analytics

0 rewiews
Explore Facebook data analysis using Power Query and Power BI. Learn to extract insights from your feed trends and photo locations for personalized self-service business intelligence.
Add to list
1 Lesons
28 minutes
On-Demand
Free-Video
PASS Data Community Summit

Power Query: il tesoro nascosto dentro Power BI

0 rewiews
Scopri le potenzialità di Power Query per la trasformazione dei dati in Power BI, inclusi i fondamenti del linguaggio M e le migliori pratiche per ottimizzare il suo utilizzo.
Add to list
1 Lesons
1 hour 7 minutes
On-Demand
Free-Video
PASS Data Community Summit

Data Modeling and Prototyping in Power BI Desktop

0 rewiews
Explore rapid data modeling and prototyping using Power BI Desktop. Learn to connect, cleanse, and model data from various sources, creating quick reports for project approval without licensing costs.
Add to list
20 Lesons
1 hour 1 minute
On-Demand
Free-Video
PASS Data Community Summit

ETLs with PowerBI and Introduction to Power Query

0 rewiews
Aprende a realizar ETLs eficientes y domina Power Query en PowerBI para transformar y cargar datos de manera efectiva, mejorando tus habilidades de análisis y visualización.
Add to list
1 Lesons
59 minutes
On-Demand
Free-Video
Kevin Stratvert

How to Create Pivot Tables from Multiple Excel Worksheets

0 rewiews
Master the process of combining and analyzing data from multiple Excel sheets using Power Query and pivot tables to create powerful data summaries and insights.
Add to list
9 Lesons
13 minutes
On-Demand
Free-Video
Kevin Stratvert

Getting Started with Python in Microsoft Excel - A Beginner's Tutorial

0 rewiews
Discover how to leverage Python's powerful data analysis and visualization capabilities directly within Microsoft Excel, from basic syntax to advanced libraries like Pandas and Matplotlib.
Add to list
16 Lesons
20 minutes
On-Demand
Free-Video
SQLBits

Web Scraping Puppy Data with Microsoft Fabric - 1st Leg

0 rewiews
Explore CSS Selectors for web scraping in Power Query, m code, and PySpark Notebooks within Microsoft Fabric's Azure cloud environment.
Add to list
1 Lesons
22 minutes
On-Demand
Free-Video
SQLBits

Web Scraping Puppy Data with Microsoft Fabric - 2nd Leg

0 rewiews
Learn web scraping techniques using CSS Selectors in Power Query, m code, and PySpark within Microsoft Fabric to extract puppy data from websites.
Add to list
1 Lesons
22 minutes
On-Demand
Free-Video
SQLBits

Web Scraping Puppy Data with Microsoft Fabric - 2nd Leg

0 rewiews
Learn web scraping techniques using CSS Selectors in Power Query, m code, and PySpark within Microsoft Fabric to extract puppy data from websites.
Add to list
1 Lesons
22 minutes
On-Demand
Free-Video
SQLBits

Web Scraping Puppy Data with Microsoft Fabric - 1st Leg

0 rewiews
Explore CSS Selectors for web scraping in Power Query, m code, and PySpark Notebooks within Microsoft Fabric's Azure cloud environment.
Add to list
1 Lesons
22 minutes
On-Demand
Free-Video
ExcelIsFun

Lookup Manager Names in Column Headers to Create Report - Excel Magic Trick 1866

0 rewiews
Master Excel techniques to create reports by looking up manager names in column headers using functions like TOCOL, UNIQUE, IF, TEXTJOIN, and Power Query transformations.
Add to list
14 Lesons
12 minutes
On-Demand
Free-Video
ExcelIsFun

Approximate Match Lookup in Power Query - Amazing Functions for Power BI and Excel

0 rewiews
Discover powerful approximate match lookup techniques in Power Query using custom functions. Learn to create efficient solutions with Table.SelectRows and List.Accumulate for Excel and Power BI data analysis.
Add to list
7 Lesons
14 minutes
On-Demand
Free-Video
SQLBits

The Future of Version Control for Tabular Models

0 rewiews
Discover groundbreaking version control capabilities for tabular models, enabling seamless collaboration and efficient BI development workflows.
Add to list
33 Lesons
50 minutes
On-Demand
Free-Video
SQLBits

New Features in Power Query for Power BI, Fabric, and Excel

0 rewiews
Discover the latest Power Query features in Power BI Desktop, Fabric Dataflows, and Excel, enhancing data transformation capabilities.
Add to list
1 Lesons
54 minutes
On-Demand
Free-Video
Great Learning

Become a Power Query Master in Excel in Less Than One Hour

0 rewiews
Master Power Query in Excel: Learn to gather, clean, and transform data efficiently. Streamline your workflow, automate tasks, and optimize data preparation for analysis.
Add to list
8 Lesons
58 minutes
On-Demand
Free-Video
Great Learning

Excel Automation Essentials - Streamlining Workflows and Boosting Productivity

0 rewiews
Master Excel automation: functions, conditional formatting, AI tools, PivotTables, and Power Query. Boost productivity with advanced techniques like Excel Bot and GPT Excel.
Add to list
6 Lesons
47 minutes
On-Demand
Free-Video
ExcelIsFun

Master Power Query M Code and Data Shaping for Data Analysis

0 rewiews
Master Power Query M Code for advanced data shaping and analysis. Learn M Code values, expressions, data types, operations, custom functions, and key functions like Table.AddColumn and Table.Group.
Add to list
67 Lesons
1 hour 50 minutes
On-Demand
Free-Video
Simon Sez IT

Data Models, PivotTables, and Power Query in Excel - Advanced Data Analysis Techniques

0 rewiews
Master advanced Excel data analysis by combining PivotTables, data models, and Power Query to transform complex datasets into meaningful insights. Learn to create relationships, clean data, and generate powerful analytical reports.
Add to list
10 Lesons
48 minutes
On-Demand
Free-Video
Simon Sez IT

Cleaning Data and Building Reporting Dashboards in Excel - From Power Query to Interactive Visualizations

0 rewiews
Master data cleaning and visualization in Excel through Power Query, PivotTables, and interactive dashboard creation. Transform raw data into meaningful insights while automating your workflow.
Add to list
3 Lesons
2 hours 32 minutes
On-Demand
Free-Video