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

#Spreadsheets

#Power Pivot #PivotTables #Macros #Pivot Tables #VLOOKUP #XLOOKUP #VLOOKUP Function #Array Formulas #Calculated Columns #AVERAGEIFS #COUNTIFS #MATCH function #Pivot Charts #HLOOKUP #INDEX function
Showing: 379 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

Microsoft Access Tutorial - Beginner to Advanced Training

4 rewiews
Comprehensive tutorial covering Microsoft Access fundamentals to advanced techniques, including database creation, table management, relationships, macros, and multi-user considerations for efficient data handling.
Add to list
50 Lesons
6 hours 53 minutes
On-Demand
Free-Video
HackerSploit

ChatGPT for Cybersecurity

5 rewiews
Explore ChatGPT's applications in cybersecurity, from pentesting and shell generation to blue team strategies. Learn to leverage AI for enhanced security practices and automation.
Add to list
12 Lesons
40 minutes
On-Demand
Free-Video

MS-Excel

4 rewiews
Comprehensive Excel training covering basics to advanced features, including formulas, functions, charts, pivot tables, and keyboard shortcuts for enhanced productivity.
Add to list
103 Lesons
10 hours
On-Demand
Free-Video
Learnit Training

Google Sheets Advanced Tutorial

4 rewiews
Master advanced Google Sheets techniques: data sorting, filtering, charts, pivot tables, functions (IF, VLOOKUP, SUMIF), macros, and more. Enhance your spreadsheet skills for efficient data analysis and visualization.
Add to list
25 Lesons
1 hour 35 minutes
On-Demand
Free-Video
Simon Sez IT

The Ultimate MS Excel Crash Course - Microsoft Excel 2016 Tutorial for Beginners

2 rewiews
Comprehensive 6-hour tutorial covering Excel basics to advanced functions. Learn data entry, formatting, formulas, VLOOKUP, charts, and more. Includes hands-on exercises for practical skill development.
Add to list
39 Lesons
6 hours 2 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
Great Learning

Data Analytics Using Excel

1 rewiews
Master Excel for data analytics: clean, analyze, and visualize data using functions, pivot tables, and charts. Gain practical skills for data-driven decision-making and career advancement.
Add to list
11 Lesons
1 hour 23 minutes
On-Demand
Free-Video
Mr Tompkins EdTech

Microsoft Excel - A Teachers Guide to Creating Dynamic Gradebooks-E-Markbooks

1 rewiews
Learn to create dynamic gradebooks in Excel with features like named ranges, VLOOKUP, XLOOKUP, and student summary pages. Perfect for teachers seeking efficient grading solutions.
Add to list
4 Lesons
30 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

Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More

1 rewiews
Comprehensive payroll solution using advanced Excel functions like SUMIFS, MROUND, MOD, and VLOOKUP. Learn to calculate hours, deductions, and taxes efficiently.
Add to list
18 Lesons
29 minutes
On-Demand
Free-Video
Simon Sez IT

The Ultimate Excel Tutorial - Beginner to Advanced

1 rewiews
Comprehensive Excel mastery: from basic formulas to advanced techniques like VBA macros, covering data cleaning, pivot tables, and dynamic arrays for enhanced productivity.
Add to list
6 Lesons
5 hours 43 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
Simon Sez IT

How to Analyze Data in Excel Spreadsheets

1 rewiews
Learn essential Excel skills for data analysis: data entry, formatting, formulas, functions, and referencing. Practical exercises included for hands-on experience in spreadsheet manipulation and analysis.
Add to list
7 Lesons
50 minutes
On-Demand
Free-Video
Learnit Training

Excel Beginner Tutorial - From Basics to Advanced Features

1 rewiews
Comprehensive tutorial covering Excel basics to advanced features, including formulas, functions, data management, charts, and automation techniques for improved efficiency and data analysis skills.
Add to list
23 Lesons
1 hour 39 minutes
On-Demand
Free-Video
Learnit Training

Google Docs Advanced Tutorial

1 rewiews
Master advanced Google Docs features: tables, styles, images, charts, collaboration tools, and more. Enhance your document creation skills with practical tutorials on formatting, organizing, and sharing content effectively.
Add to list
39 Lesons
1 hour 34 minutes
On-Demand
Free-Video
Simon Sez IT

Pivot Table Excel Tutorial

1 rewiews
Learn to create, analyze, and visualize data with Excel Pivot Tables. Master data cleaning, formatting, grouping, and advanced features like Pivot Charts and Slicers in this comprehensive tutorial.
Add to list
15 Lesons
52 minutes
On-Demand
Free-Video

VB Scripting Beginner's Basics for Catia V5

2 rewiews
Learn VB scripting basics for CATIA V5 automation. Create macros, use control statements, loops, and operators. Develop practical skills through hands-on examples like calculator applications and prime number identification.
Add to list
50 Lesons
6 hours
On-Demand
Free-Video
Derek Banas

Lisp Tutorial

1 rewiews
Comprehensive introduction to Lisp programming, covering syntax, functions, data structures, object-oriented concepts, and file operations. Ideal for beginners seeking a solid foundation in Lisp.
Add to list
33 Lesons
1 hour 15 minutes
On-Demand
Free-Video

C Technical Interview Questions and Answers

0 rewiews
This video tutorial series increases your technical programming skills and your logical ability in application development. These videos are explained using the syntax of C language but it is useful to all the programming languages.
Add to list
110 Lesons
9 hours
On-Demand
Free-Video
Cal Poly Pomona

Introduction to Excel VBA Programming

0 rewiews
Learn Excel VBA programming essentials: macros, variables, functions, loops, and user forms. Master data manipulation and automation techniques for enhanced spreadsheet functionality.
Add to list
52 Lesons
5 hours
On-Demand
Free-Video
Loves Data

Google Sheets Tutorial for Beginners 2024 - Step-by-Step

0 rewiews
Master Google Sheets essentials: create spreadsheets, import data, format cells, use functions, apply filters, visualize data, and collaborate effectively in this comprehensive beginner's guide.
Add to list
17 Lesons
20 minutes
On-Demand
Free-Video
Teacher's Tech

Excel Shortcuts for Beginners - Essential Tips to Boost Productivity

0 rewiews
Master essential Excel shortcuts to boost productivity and streamline your workflow. Learn navigation, data manipulation, formatting, and advanced features for efficient spreadsheet management.
Add to list
7 Lesons
15 minutes
On-Demand
Free-Video
Simon Sez IT

How to Build and Design Charts and Dashboards in Excel

0 rewiews
Master Excel data cleaning, custom formatting, and chart creation to transform raw information into visually impactful dashboards and presentations.
Add to list
3 Lesons
2 hours 20 minutes
On-Demand
Free-Video

Apache Airflow

0 rewiews
Comprehensive tutorials on Apache Airflow covering DAGs, operators, Kubernetes Executors, Docker, AWS integration, and more. Ideal for mastering workflow automation and orchestration.
Add to list
34 Lesons
6 hours
On-Demand
Free-Video
Great Learning

Pivot Table in Excel

0 rewiews
Learn to create, customize, and utilize Pivot Tables in Excel for efficient data summarization and analysis. Master various tools and techniques for powerful data insights.
Add to list
12 Lesons
28 minutes
On-Demand
Free-Video

Excel Skills

0 rewiews
Enhance data analysis skills with time-series plots, matrix-to-vector conversion, vlookup, histograms, text data import, and correlation techniques in Excel.
Add to list
6 Lesons
30 minutes
On-Demand
Free-Video

LaTeX Tutorials

0 rewiews
Master LaTeX for stunning math documents: equations, tables, figures, theorems, and graphics. From beginner to advanced, covering thesis writing and essential packages.
Add to list
5 Lesons
2 hours 30 minutes
On-Demand
Free-Video

Learn Microsoft Word

0 rewiews
Master Microsoft Word essentials: document creation, formatting, tables, images, and advanced features. Enhance productivity with practical skills for efficient word processing and document management.
Add to list
95 Lesons
6 hours
On-Demand
Free-Video
The Organic Chemistry Tutor

Excel 2016 Tips, Tricks, Shortcuts, Functions & Formulas

0 rewiews
Master Excel 2016 with 30 essential tips, tricks, shortcuts, functions, and formulas. Boost productivity and efficiency in data management, analysis, and visualization.
Add to list
30 Lesons
1 hour 2 minutes
On-Demand
Free-Video
Teacher's Tech

How to Use Formulas and Functions in Microsoft Excel

0 rewiews
Learn essential Excel formulas and functions, from basic math to advanced techniques like VLOOKUP and conditional functions, enhancing your data analysis and productivity skills.
Add to list
13 Lesons
26 minutes
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

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 - Learn Central Limit Theorem by Building Sampling Distribution of Xbar

0 rewiews
Explore the Central Limit Theorem through practical Excel exercises, learning to build sampling distributions and apply statistical concepts for informed business decision-making.
Add to list
21 Lesons
50 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 - 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 Data Analysis - Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More

0 rewiews
Master Power Pivot and DAX formulas for advanced Excel data analysis. Learn data modeling, relationships, and visualization techniques to create powerful reports and dashboards.
Add to list
50 Lesons
1 hour 16 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

DAX Formulas for Running Total and % of Running Total & Other DAX Tricks

0 rewiews
Master advanced DAX formulas for running totals, percentages, and data modeling in Excel. Learn to create relationships, use functions like CALCULATE and FILTER, and handle regular and irregular increments.
Add to list
19 Lesons
41 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

Extract Records With Multiple Contains - Partial Text Criteria: 4 Examples

0 rewiews
Learn advanced Excel techniques for extracting records with multiple contains criteria, using array formulas, functions like SEARCH and MMULT, and exploring matrix multiplication concepts.
Add to list
9 Lesons
38 minutes
On-Demand
Free-Video
ExcelIsFun

Average of Customer Total Sales by Product - Formulas, DAX or Array Formula?

0 rewiews
Learn advanced Excel techniques for calculating average customer sales by product using formulas, array formulas, and DAX measures in Power Pivot. Compare methods and optimize performance.
Add to list
11 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

Power BI Desktop - Build Data Model, Get Data, DAX Formulas, Visualizations, Publish to Web

0 rewiews
Comprehensive tutorial on building data models, creating DAX formulas, and designing visualizations in Power BI Desktop. Learn to import data, establish relationships, and publish interactive reports online.
Add to list
51 Lesons
1 hour 12 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

How to Build Data Model and DAX Formulas in Power Pivot

0 rewiews
Master data modeling and DAX formulas in Power Pivot for Excel 2016. Learn to create relationships, calculated columns, and measures for powerful data analysis and visualization.
Add to list
22 Lesons
1 hour 5 minutes
On-Demand
Free-Video
ExcelIsFun

Lookup Functions and Formulas in Excel 2016 - Comprehensive Lessons with 20 Examples

0 rewiews
Comprehensive tutorial on Excel lookup functions with 20 practical examples, covering VLOOKUP, HLOOKUP, INDEX, MATCH, and LOOKUP for data retrieval and analysis.
Add to list
23 Lesons
1 hour 19 minutes
On-Demand
Free-Video
ExcelIsFun

Conditional Calculations with Excel Formulas - Comprehensive Lessons

0 rewiews
Comprehensive guide to conditional calculations in Excel, covering AND/OR functions, SUMIFS, array formulas, and more. Ideal for mastering complex data analysis techniques.
Add to list
21 Lesons
1 hour 23 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

Excel 2016 IFS Functions - Compare and Contrast IF and IFS Functions

0 rewiews
Learn to use Excel 2016's IFS function for complex conditional logic, comparing it with IF and VLOOKUP. Explore practical examples and advanced techniques for efficient data analysis and formula creation.
Add to list
9 Lesons
28 minutes
On-Demand
Free-Video
ExcelIsFun

Build Database with Excel Table Feature and VLOOKUP to Get Invoice Detail

0 rewiews
Learn to create dynamic databases in Excel using Tables, master VLOOKUP for invoice details, and explore advanced features like structured references and data validation.
Add to list
16 Lesons
26 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

Basic Excel Business Analytics - Introduction to PowerPivot & Data Modeling

0 rewiews
Comprehensive introduction to PowerPivot and data modeling in Excel, covering key concepts, DAX functions, and best practices for building efficient and effective data models for business analytics.
Add to list
29 Lesons
36 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

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples

0 rewiews
Comprehensive guide to Excel's XLOOKUP function, covering 27 examples from basic usage to advanced techniques like dynamic column retrieval and array formulas.
Add to list
29 Lesons
25 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 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

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

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

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

IF or VLOOKUP Function for Assigning Categories with Excel Formula - 8 Examples

0 rewiews
Learn advanced Excel techniques for assigning categories using IF and VLOOKUP functions. Master data organization, formula creation, and efficient lookup methods for various scenarios.
Add to list
9 Lesons
30 minutes
On-Demand
Free-Video
ExcelIsFun

Aging Accounts Receivable Reports on Multiple Sheets With Array Formula

0 rewiews
Learn to create automated Aging Accounts Receivable Reports using Excel's array formulas, table features, and structured references. Master advanced functions like COUNTIFS, AGGREGATE, and INDEX for efficient data extraction and reporting.
Add to list
12 Lesons
27 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

Ctrl - Shift - Enter- Excel Array Formulas - Formulas to Extract Records With Criteria

0 rewiews
Master advanced Excel array formulas for efficient data extraction, including AND/OR criteria, INDEX, SMALL, and AGGREGATE functions. Optimize spreadsheet performance with practical examples and timing comparisons.
Add to list
23 Lesons
1 hour 14 minutes
On-Demand
Free-Video
ExcelIsFun

Ctrl - Shift - Enter - Excel Array Formulas - Boolean Logic, AND & OR Criteria, Convert TRUE FALSE

0 rewiews
Aprenda a usar fórmulas de matriz avançadas no Excel, incluindo lógica booleana, critérios AND e OR, e conversão de TRUE/FALSE para análise de dados eficiente.
Add to list
21 Lesons
27 minutes
On-Demand
Free-Video
ExcelIsFun

Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions

0 rewiews
Master Excel's dynamic ranges using INDEX and OFFSET functions. Learn to create flexible formulas, charts, and data validation lists that automatically adjust as data changes, enhancing efficiency and accuracy in data analysis.
Add to list
21 Lesons
1 hour
On-Demand
Free-Video
ExcelIsFun

Ctrl + Shift + Enter - Excel Array Formulas - SUMPRODUCT Function - Including Timing

0 rewiews
Comprehensive guide to SUMPRODUCT function in Excel, covering 21 examples with array formulas, timing comparisons, and efficient calculation techniques for data analysis and problem-solving.
Add to list
24 Lesons
45 minutes
On-Demand
Free-Video
ExcelIsFun

Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics

0 rewiews
Comprehensive tutorial on Excel array formulas, covering formula basics, advanced functions, and practical applications for efficient data analysis and problem-solving.
Add to list
15 Lesons
59 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

INDEX & MATCH Lookup Functions - Beginning to Advanced

0 rewiews
Comprehensive tutorial on INDEX & MATCH functions in Excel, covering 18 advanced techniques from basic lookups to complex array formulas for data extraction and manipulation.
Add to list
18 Lesons
1 hour 10 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

Logical Formulas - Count & Extract Customer Names for 8 Sales Coupon Groups

0 rewiews
Learn advanced Excel techniques for analyzing customer coupon usage across multiple stores, including logical formulas, array formulas, and functions like COUNTIFS, AND, OR, and INDEX.
Add to list
6 Lesons
31 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

Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions

0 rewiews
Learn to create reusable Excel invoices using advanced functions like VLOOKUP, IF, and data validation. Master invoice formatting, calculations, and automated invoice numbering for efficient business operations.
Add to list
13 Lesons
31 minutes
On-Demand
Free-Video
ExcelIsFun

Excel & Business Math - Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost

0 rewiews
Learn to calculate trade discounts and wholesale costs using Excel functions like VLOOKUP and IF. Master business terms and automate calculations for single and series discounts in retail and wholesale scenarios.
Add to list
10 Lesons
37 minutes
On-Demand
Free-Video
ExcelIsFun

Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction

0 rewiews
Learn to calculate federal income tax withholdings using VLOOKUP and MAX functions in Excel, with practical examples for different marital statuses and pay periods.
Add to list
10 Lesons
30 minutes
On-Demand
Free-Video
ExcelIsFun

Excel & Business Math - VLOOKUP Function for Incentive Pay: Commissions & Piecework

0 rewiews
Master VLOOKUP for incentive pay calculations, including piecework and commissions. Learn to create lookup tables and apply VLOOKUP for various business scenarios with 15 practical examples.
Add to list
17 Lesons
1 hour 21 minutes
On-Demand
Free-Video
ExcelIsFun

Array Formula - Add Daily Rainfall 5 AM to 5 AM Next Day - Most Automatic

0 rewiews
Learn advanced Excel array formulas to automate rainfall reporting with custom time periods. Master FREQUENCY, AGGREGATE, and SUMIFS functions for efficient data analysis and unique date extraction.
Add to list
9 Lesons
37 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 - Excel VLOOKUP Function Made Easy

0 rewiews
Master Excel's VLOOKUP function with 9 practical examples, from exact matches for product pricing to approximate matches for commission calculations, enhancing your data analysis skills.
Add to list
18 Lesons
40 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

Excel Lookup Formulas

0 rewiews
Master Excel lookup formulas like VLOOKUP, INDEX MATCH, and XLOOKUP. Learn advanced techniques for complex data retrieval, multi-criteria searches, and cross-sheet lookups to enhance your spreadsheet skills.
Add to list
19 Lesons
3 hours 30 minutes
On-Demand
Free-Video