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

#Microsoft Excel

#Excel Dashboards #Excel VBA
Showing: 402 courses
Simon Sez IT

Microsoft Office Tutorial - Learn Excel, PowerPoint and Word

16 rewiews
Comprehensive tutorial covering Excel, PowerPoint, and Word essentials. Learn fundamental skills, formatting techniques, and practical applications for enhanced productivity in Microsoft Office.
Add to list
100 Lesons
9 hours 5 minutes
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
Simon Sez IT

Microsoft Excel Tutorial for Beginners

5 rewiews
Comprehensive Excel tutorial covering essential features, formulas, and functions. Ideal for beginners, with hands-on exercises to build practical skills in spreadsheet creation and data management.
Add to list
42 Lesons
3 hours 3 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
ExcelIsFun

Excel & Business Math - MEDIAN Function for FICA Social Security & Medicare Payroll Deductions

3 rewiews
Learn to calculate FICA payroll deductions using Excel's MEDIAN function, focusing on Social Security and Medicare taxes. Master tax calculations with changing rates and create employee payroll tables.
Add to list
7 Lesons
39 minutes
On-Demand
Free-Video
Stanford University

How to Avoid the Biggest Risks in Risk Management

1 rewiews
Discover strategies to minimize uncertainties, protect your organization, and build a thriving risk management culture with Stanford Professor Sam Savage's insights on common pitfalls and blind spots in risk modeling.
Add to list
14 Lesons
55 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
Skillademia

Microsoft Excel Course for Beginners

2 rewiews
Comprehensive Excel tutorial covering basics to advanced features. Learn data manipulation, formulas, formatting, and practical applications for effective spreadsheet solutions.
Add to list
26 Lesons
4 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
Great Learning

ChatGPT for Excel - Increase Your Productivity by 10X with ChatGPT for Excel

2 rewiews
Explore how ChatGPT enhances Excel productivity through intelligent suggestions, task automation, and complex calculation assistance, unlocking new possibilities for users of all levels.
Add to list
5 Lesons
1 hour
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

Microsoft Excel

1 rewiews
Master Excel essentials: data handling, formatting, graphing, and problem-solving tools. Learn through practical examples and case studies to enhance your spreadsheet skills for various applications.
Add to list
45 Lesons
4 hours 30 minutes
On-Demand
Free-Video
Teacher's Tech

Microsoft Excel Tutorial - Beginners Level 4

1 rewiews
Learn advanced Excel techniques including conditional formatting, data validation, drop-down menus, and slicers to enhance data analysis and visualization skills.
Add to list
8 Lesons
25 minutes
On-Demand
Free-Video
ExcelIsFun

Excel and Business Math - Future Value, Present Value and Periodic Payments for Annuities

1 rewiews
Aprenda a calcular valor futuro, valor presente e pagamentos periódicos para anuidades e fluxos de caixa irregulares usando Excel. Inclui exemplos práticos e diagramas.
Add to list
13 Lesons
51 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

Actuarial Science Subject CM1- Actuarial Mathematics 1

1 rewiews
Comprehensive actuarial mathematics course covering time value of money, interest rates, life tables, assurance contracts, and complex conditions with practical Excel applications.
Add to list
25 Lesons
18 hours
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
ExcelIsFun

M Code Class from Basic to Advanced - Power Query Excel & Power BI, Custom Functions

1 rewiews
Comprehensive tutorial on M Code in Power Query for Excel and Power BI, covering basics to advanced topics like custom functions, data types, and lookups. Ideal for mastering data manipulation.
Add to list
34 Lesons
1 hour 42 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
Technology for Teachers and Students

Excel for Beginners - The Complete Course

1 rewiews
Comprehensive Excel tutorial covering basics to advanced features. Learn spreadsheet terminology, data entry, formulas, functions, formatting, charts, and publishing options in just 55 minutes.
Add to list
8 Lesons
55 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
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
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

Connecting Plotly Graphs to Dash Components

0 rewiews
Learn to create interactive data visualizations by connecting Plotly graphs with Dash components. Master various chart types and enhance user interaction in your Python-based dashboards.
Add to list
11 Lesons
4 hours 30 minutes
On-Demand
Free-Video

Plotly Dashboards

0 rewiews
Learn to create interactive dashboards and data visualizations using Plotly and Dash. Master various chart types, components, and styling techniques for building powerful web applications with Python.
Add to list
74 Lesons
1 day 4 hours
On-Demand
Free-Video
Great Learning

Excel Tips and Tricks

0 rewiews
Enhance Excel proficiency with time-saving tips and tricks for data analysis, visualization, and efficient spreadsheet management. Learn essential features to boost productivity.
Add to list
19 Lesons
52 minutes
On-Demand
Free-Video
Great Learning

Excel Tutorial for Beginners

0 rewiews
Comprehensive tutorial covering essential Excel skills, from basic functions to advanced features like pivot tables and conditional formatting. Learn to analyze and visualize data effectively.
Add to list
11 Lesons
3 hours 49 minutes
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
Great Learning

Conditional Formatting in Excel - Excel Training - Excel Tutorial for Beginners

0 rewiews
Learn to enhance Excel data visualization with conditional formatting, including color scales, data bars, and icon sets. Master techniques for highlighting cells based on specific conditions.
Add to list
17 Lesons
46 minutes
On-Demand
Free-Video
Great Learning

Excel Formulas and Functions - Excel Tutorial for Beginners in 2021 - Great Learning

0 rewiews
Learn essential Excel formulas and functions for data analysis and visualization. Master basic concepts, explore top functions, and gain practical skills to enhance your spreadsheet proficiency.
Add to list
9 Lesons
34 minutes
On-Demand
Free-Video
Kimberly Brehm

Using Excel in Statistics

0 rewiews
Learn to leverage Excel for statistical analysis, from data display to hypothesis testing and regression, enhancing your data interpretation skills.
Add to list
11 Lesons
4 hours 30 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

Learn Microsoft Excel

0 rewiews
Master Excel essentials to advanced features: data entry, formulas, formatting, charts, pivot tables, and more. Gain practical skills for efficient spreadsheet management and data analysis.
Add to list
105 Lesons
7 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
Teacher's Tech

Microsoft Excel Tutorial - Beginners Level 1

0 rewiews
Comprehensive introduction to Excel basics, covering interface, data entry, formatting, formulas, functions, and charts for beginners to start using the spreadsheet tool effectively.
Add to list
21 Lesons
33 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

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 Worksheet Formulas & Models – Everything You Ever Wanted to Know

0 rewiews
Comprehensive guide to Excel formulas, covering various types, editing modes, and practical applications through real-world models. Ideal for mastering advanced spreadsheet techniques.
Add to list
25 Lesons
1 hour 11 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

Introduction to Microsoft 365 Excel and Conventions for Class

0 rewiews
Learn essential Microsoft 365 Excel basics, including file management, interface navigation, keyboard shortcuts, formulas, and data alignment. Master fundamental concepts for efficient spreadsheet creation and analysis.
Add to list
22 Lesons
28 minutes
On-Demand
Free-Video
ExcelIsFun

Linear Regression Made Easy - The Epic Full Story with All Details - Excel Statistical Analysis

0 rewiews
Comprehensive guide to linear regression in Excel, covering key calculations, formulas, and visualizations. Learn to interpret data, make predictions, and understand statistical concepts through practical examples.
Add to list
34 Lesons
1 hour 12 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Statistical Analysis - Hypothesis Testing - P-Value & Critical Value Methods - 1 Tail Upper

0 rewiews
Master hypothesis testing in Excel: learn 5-step process, P-value and Critical Value methods for one-tail upper tests. Practical example using realtor salary data enhances understanding of statistical concepts.
Add to list
12 Lesons
33 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 - Binomial Probability Distributions - BINOM.DIST.RANGE Function & Chart

0 rewiews
Master binomial probability distributions in Excel using BINOM.DIST.RANGE function. Learn formulas, create charts, and analyze real-world scenarios to enhance your statistical analysis skills.
Add to list
19 Lesons
32 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Statistical Analysis - Build Discrete Probability Distributions with Worksheet Formulas

0 rewiews
Learn to create discrete probability distributions using Excel formulas. Master expected value, standard deviation, charting, and applying these concepts to real-world business scenarios for data-driven decision-making.
Add to list
22 Lesons
29 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Statistical Analysis - AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions

0 rewiews
Master Excel's AND, OR, and NOT logical tests for COUNTIFS and FILTER functions. Learn to analyze data using Venn diagrams, mutually exclusive events, and probability concepts.
Add to list
19 Lesons
29 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 - Range, Variance, Standard Deviation, Coefficient of Variation

0 rewiews
Master Excel's statistical analysis tools for calculating range, variance, standard deviation, and coefficient of variation. Apply these measures to make informed business decisions and interpret financial data.
Add to list
12 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 - 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 & Skew for Quantitative Data

0 rewiews
Master frequency distributions and data visualizations in Excel, including column charts, histograms, and line charts. Learn to analyze discrete and continuous data, handle time series, and interpret skew in distributions.
Add to list
21 Lesons
29 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 Statistical Analysis - Comprehensive Worksheet Formula & Model Building

0 rewiews
Master Excel formulas and model building, from basic elements to advanced techniques like Dynamic Spilled Array Formulas. Learn efficient methods for data analysis and presentation in Microsoft 365 Excel.
Add to list
24 Lesons
43 minutes
On-Demand
Free-Video
ExcelIsFun

Big Data Analysis with Power Pivot & Power BI - Visuals & DAX Formulas

0 rewiews
Master advanced data analysis techniques using Power Pivot and Power BI, including data modeling, DAX formulas, and creating interactive visualizations for effective business insights.
Add to list
71 Lesons
58 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Data Analysis - Power BI Desktop, DAX Formulas, Relationships, Data Modeling & Visuals

0 rewiews
Comprehensive guide to Power BI Desktop: data import, DAX formulas, relationships, modeling, and visualizations. Learn to create powerful reports and dashboards for advanced Excel data analysis.
Add to list
67 Lesons
1 hour 16 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 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

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

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

Excel 2016 - Macro Recorder Basics & Copying VBA Code From Internet

0 rewiews
Learn to record macros, use absolute and relative references, convert data formats, and implement online VBA code in Excel 2016. Enhance your spreadsheet automation skills with practical examples and techniques.
Add to list
8 Lesons
41 minutes
On-Demand
Free-Video
ExcelIsFun

Highline Excel 2016 Class - Financial Functions: PMT, RATE, NPER and FV Examples

0 rewiews
Comprehensive guide to Excel's financial functions, covering PMT, RATE, NPER, and FV with practical examples for loans, investments, and retirement planning calculations.
Add to list
14 Lesons
41 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

Transform Data Sets Using Advanced Filter - Excel 2016

0 rewiews
Master Excel's Advanced Filter with 8 practical examples, from basic AND/OR criteria to complex formulas, unique lists, and professional report creation.
Add to list
9 Lesons
34 minutes
On-Demand
Free-Video
ExcelIsFun

Conditional Formatting to Visualize Data - Built-in and Logical Formulas

0 rewiews
Explore advanced Excel data visualization techniques using conditional formatting, including built-in features and logical formulas for effective data analysis and presentation.
Add to list
18 Lesons
44 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Charts to Visualize Data - Comprehensive Lesson with 11 Chart Examples

0 rewiews
Comprehensive guide to creating effective Excel charts, covering 11 types with practical examples and tips for data visualization without unnecessary clutter.
Add to list
16 Lesons
52 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

Excel Array Formulas - Comprehensive Lessons with 12 Examples

0 rewiews
Comprehensive guide to Excel array formulas, covering 12 practical examples from basic operations to advanced functions like SUMPRODUCT, TRANSPOSE, and FREQUENCY for efficient data analysis.
Add to list
20 Lesons
52 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 Fundamentals - Comprehensive Formula Lesson

0 rewiews
Comprehensive Excel formula tutorial covering 15 examples, including VLOOKUP, IF functions, array formulas, error tracking, and best practices for efficient spreadsheet creation.
Add to list
20 Lesons
55 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 - Basic Forecasting Methods & Measures of Forecast Error

0 rewiews
Explore essential forecasting techniques and error measures in Excel, including Naïve Method, Moving Average, and Exponential Smoothing. Learn to calculate and interpret forecast accuracy metrics for improved business analytics.
Add to list
12 Lesons
32 minutes
On-Demand
Free-Video
ExcelIsFun

Basic Excel Business Analytics - Forecasting with Linear Regression: Trend & Seasonal Pattern

0 rewiews
Learn advanced Excel forecasting techniques using linear regression for trend and seasonal pattern analysis, including FORECAST function and multiple regression with categorical variables.
Add to list
6 Lesons
25 minutes
On-Demand
Free-Video
ExcelIsFun

Basic Excel Business Analytics - Visualizing Data: Table & Chart Guidelines

0 rewiews
Aprenda diretrizes essenciais para visualização eficaz de dados em Excel, incluindo princípios de design de tabelas, tipos de gráficos e técnicas avançadas como formatação condicional e mapeamento 3D.
Add to list
28 Lesons
42 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

Basic Excel Business Analytics - Good Spreadsheet Model Design, Fixed Variable Cost Example

0 rewiews
Learn essential spreadsheet modeling techniques for business analytics, focusing on fixed and variable cost analysis using Excel. Gain practical skills in creating well-designed models for effective decision-making.
Add to list
8 Lesons
37 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