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

#PivotTables

Showing: 52 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
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
ExcelIsFun

The Magic of Excel - Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & More

1 rewiews
Discover Excel's powerful features: formulas, PivotTables, charts, and more. Learn essential skills to boost efficiency and data analysis capabilities for work, school, and personal projects.
Add to list
14 Lesons
1 hour 2 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 Formulas & Functions, PivotTables, Slicers & Charts

0 rewiews
Comprehensive guide to Excel's powerful features: formulas, functions, PivotTables, charts, and data analysis tools. Master essential skills for efficient spreadsheet management and insightful data visualization.
Add to list
46 Lesons
1 hour 14 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 - Cross Tabulation, Visualizations, and Logical Tests, Simpson’s Paradox

0 rewiews
Master cross tabulation, visualizations, and logical tests in Excel. Learn to create insightful reports, understand Simpson's Paradox, and effectively analyze data relationships using PivotTables and charts.
Add to list
22 Lesons
33 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Statistical Analysis - Frequency Distributions & Visualizations for Categorical Data

0 rewiews
Learn to create frequency distributions and visualize categorical data using Excel. Master PivotTables, column/bar charts, and advanced techniques for effective data presentation and analysis.
Add to list
23 Lesons
34 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 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

Data Model & DAX Formulas - Quantity Frequency Distribution by Year & Country

0 rewiews
Learn to create a Data Model with DAX formulas for PivotTable frequency distributions, including conditional formatting and big data handling in Excel.
Add to list
15 Lesons
29 minutes
On-Demand
Free-Video
ExcelIsFun

Excel for Accountants - VLOOKUP & PivotTables - Complete Lessons from Basic to Advanced

0 rewiews
Comprehensive tutorial on VLOOKUP and PivotTables for accountants, covering basic to advanced techniques. Includes practical examples, efficiency tricks, and number formatting tips for Excel mastery.
Add to list
19 Lesons
1 hour 33 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

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 - Comprehensive PowerPivot, Data Model, DAX & Reporting Example

0 rewiews
Comprehensive guide to PowerPivot: Import big data, build data models, create DAX measures, and generate insightful reports. Master advanced Excel analytics for business intelligence.
Add to list
34 Lesons
1 hour 1 minute
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 Pivot - Big Data, Data Modeling, DAX & Dashboards

0 rewiews
Aprenda a modelar dados, criar fórmulas DAX e construir dashboards usando Power Pivot. Importe dados SQL, crie tabelas de datas e explore recursos avançados para análise de negócios eficiente no Excel.
Add to list
25 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

Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

0 rewiews
Learn to create effective data visualizations in Excel using tables, charts, conditional formatting, and dashboards. Master techniques for clear, impactful data presentation and analysis.
Add to list
13 Lesons
55 minutes
On-Demand
Free-Video
ExcelIsFun

PivotTables & Slicers - Create Dashboards & Summary Reports

0 rewiews
Master PivotTables, Slicers, and dashboards in Excel. Create cross-tab reports, frequency distributions, and custom calculations for effective data analysis and visualization.
Add to list
15 Lesons
29 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

Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions

0 rewiews
Comprehensive guide to Excel Power Pivot, DAX formulas, and functions. Learn data modeling, building relationships, and creating advanced calculations for powerful business intelligence dashboards.
Add to list
42 Lesons
2 hours 4 minutes
On-Demand
Free-Video
ExcelIsFun

Ctrl - Shift - Enter- Excel Array Formulas - Extract Unique Lists & Sorting Formulas

0 rewiews
Learn advanced Excel techniques for extracting unique lists, sorting data, and creating efficient array formulas to solve complex data analysis problems and enhance spreadsheet functionality.
Add to list
12 Lesons
55 minutes
On-Demand
Free-Video
ExcelIsFun

Excel for Accounting - Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

0 rewiews
Master Excel for accounting with advanced formulas, PivotTables, macros, and charts. Learn efficient techniques for data analysis, reporting, and visualization to enhance your financial workflow.
Add to list
98 Lesons
2 hours 44 minutes
On-Demand
Free-Video
ExcelIsFun

Hack Data Model, Date Table & DAX Measures Without Buying Power Pivot

0 rewiews
Master advanced Excel techniques: build data models, create DAX measures, and use functions like CALCULATE and TOTALYTD. Learn to optimize PivotTables and implement variables for efficient data analysis.
Add to list
17 Lesons
36 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

Average, Moving Average at Different Granularity - DAX or Excel Formulas

0 rewiews
Learn advanced Excel and DAX techniques for calculating averages and moving averages at different granularities, enhancing your data analysis skills for more accurate financial reporting.
Add to list
15 Lesons
28 minutes
On-Demand
Free-Video
ExcelIsFun

RANKX DAX Function and More - Ranking Profit for Products within Manufacturer

0 rewiews
Aprenda a usar a função RANKX DAX para classificar lucros de produtos por fabricante em PivotTables do Excel. Domine técnicas avançadas de análise de dados e fórmulas DAX.
Add to list
17 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
ExcelIsFun

Excel Basics - PivotTable Power - Amazing PivotTable Reporting Tricks - Slicers to Show Values As

0 rewiews
Master advanced PivotTable techniques in Excel, including slicers, custom calculations, and data analysis. Learn to create powerful reports and gain insights from complex datasets.
Add to list
24 Lesons
40 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More

0 rewiews
Learn to leverage Excel's Table feature for dynamic ranges in VLOOKUP, PivotTables, charts, and more. Master efficient data management and analysis techniques for improved productivity.
Add to list
12 Lesons
37 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Basics - IF Function Made Easy and IS Functions Too - Epic Examples

0 rewiews
Master Excel's IF and IS functions with 14 practical examples, enhancing your data analysis and decision-making skills for various business scenarios.
Add to list
16 Lesons
54 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Basics - PivotTables & SUMIFS Function to Create Summary Reports

0 rewiews
Learn to create summary reports using PivotTables and SUMIFS function in Excel. Master data analysis techniques, proper data set creation, and efficient report formatting for regional, daily, and sales rep summaries.
Add to list
10 Lesons
33 minutes
On-Demand
Free-Video
Simon Sez IT

Microsoft Excel PivotTables Explained

0 rewiews
Learn to create, manipulate, and format PivotTables in Excel 2021/365. Master data analysis techniques, including field pivoting, grouping, and custom layouts for effective data visualization.
Add to list
12 Lesons
49 minutes
On-Demand
Free-Video
Learnit Training

Excel 2019 Power User Tutorial

0 rewiews
Advanced Excel techniques for data analysis, including VLOOKUP troubleshooting, INDEX MATCH, PivotTables, array formulas, conditional formatting, charts, and macros. Ideal for power users seeking efficient problem-solving methods.
Add to list
19 Lesons
1 hour 16 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

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
Learnit Training

Excel 2019 Power User Tutorial

0 rewiews
Advanced Excel techniques for data analysis, including VLOOKUP troubleshooting, INDEX MATCH, PivotTables, array formulas, conditional formatting, and macros. Ideal for users seeking to enhance efficiency and problem-solving skills.
Add to list
18 Lesons
1 hour 15 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

PivotTables for Quick and Easy Reports - 34 Advanced Techniques

0 rewiews
Master PivotTables with 34 advanced techniques for efficient data analysis and reporting. Learn to handle large datasets, create custom calculations, and generate insightful visualizations in Excel.
Add to list
34 Lesons
44 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
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
PASS Data Community Summit

End-to-End SQL Server PowerPivot

0 rewiews
Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative business intelligence within familiar Microsoft tools.
Add to list
1 Lesons
1 hour 31 minutes
On-Demand
Free-Video
PASS Data Community Summit

PowerPivot - A Cool Reporting Tool

0 rewiews
Explore PowerPivot for Excel to combine diverse data sources, create analytics, and overcome Excel limitations. Learn to import, pivot, and visualize data for self-service business intelligence.
Add to list
1 Lesons
1 hour 6 minutes
On-Demand
Free-Video
PASS Data Community Summit

End-to-End SQL Server PowerPivot

0 rewiews
Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative BI solutions with scheduled data refreshes and IT management.
Add to list
1 Lesons
1 hour 31 minutes
On-Demand
Free-Video
PASS Data Community Summit

Modern Excel - The Supercomputer Hiding on Everyone’s Desktop

0 rewiews
Discover game-changing Excel tools for data-driven decisions. Learn multi-source import, rapid data shaping, portable formulas, and insightful reporting techniques to supercharge your spreadsheet skills.
Add to list
26 Lesons
1 hour 19 minutes
On-Demand
Free-Video
Simon Sez IT

Creating PivotTables and PivotCharts Dashboards with Slicers in Excel

0 rewiews
Learn to create interactive Excel dashboards using PivotTables, PivotCharts, and Slicers. Master data visualization techniques, customize slicer appearance, and integrate timeline slicers for date-based filtering.
Add to list
5 Lesons
29 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
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