By Levels

Library

ExcelIsFun

236 Videos (Page 2/5)

7:59 Fast English (US)

Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet

ExcelIsFun - 8 years ago

6,085 views
12:11 Fast English (US)

Excel Magic Trick 1434: SAMPLE DAX Function to Take Random Stratified Sample from Data Set.

ExcelIsFun - 8 years ago

6,885 views
9:45 Fast English (US)

Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR

ExcelIsFun - 8 years ago

9,013 views
12:14 Conversational English (US)

Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc

ExcelIsFun - 8 years ago

4,125 views
5:41 Fast English (US)

Excel Magic Trick 1429: Power Query Ranking with Index, Grouping and MIN Function!!!

ExcelIsFun - 8 years ago

12,547 views
12:50 Fast English (US)

Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns

ExcelIsFun - 8 years ago

16,149 views
12:09 Fast English (US)

Excel Magic Trick 1417 Excel Functions Ranking Unit & Total Profit for Products within Manufacturer

ExcelIsFun - 8 years ago

5,543 views
14:01 Fast English (US)

Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too)

ExcelIsFun - 8 years ago

15,510 views
12:45 Fast English (US)

Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables

ExcelIsFun - 8 years ago

15,179 views
7:04 Fast English (US)

Excel Magic Trick 1406: Calculate Moving Average with AVEARGEIFS & EOMONTH Functions

ExcelIsFun - 8 years ago

30,713 views
5:26 Fast English (US)

Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records

ExcelIsFun - 8 years ago

242,796 views
13:33 Fast English (US)

Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report

ExcelIsFun - 8 years ago

23,744 views
12:47 Fast English (US)

Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments

ExcelIsFun - 8 years ago

5,117 views
12:11 Fast English (US)

Excel Magic Trick 1397 Part 2: Formulas: Monthly Revenue, Running Total & % Running Total & Chart

ExcelIsFun - 8 years ago

27,953 views
19:28 Fast English (US)

Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart

ExcelIsFun - 8 years ago

9,931 views
11:07 Conversational English (US)

Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)

ExcelIsFun - 8 years ago

14,122 views
5:12 Fast English (US)

Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item

ExcelIsFun - 8 years ago

6,508 views
16:33 Fast English (US)

Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total

ExcelIsFun - 8 years ago

10,043 views
7:33 Fast English (US)

Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total

ExcelIsFun - 8 years ago

35,436 views
9:06 Fast English (US)

Highline Excel 2016 Class 21: Power Query Import Multiple Excel Workbooks with Multiple Sheets

ExcelIsFun - 9 years ago

18,251 views
8:02 Fast English (US)

Highline Excel 2016 Class 14: VLOOKUP as Relationship in Power Pivot Data Model & Vice Versa

ExcelIsFun - 9 years ago

22,442 views
7:50 Fast English (US)

Highline Excel 2016 Class 12: Two Lookup Values in VLOOKUP? Helper Column or Array Formula.

ExcelIsFun - 9 years ago

21,980 views
9:02 Fast English (US)

Highline Excel 2016 Class 13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE

ExcelIsFun - 9 years ago

24,146 views
11:03 Fast English (US)

Highline Excel 2016 Class 07 Excel 2016 MAXIFS, MINIFS & IFS Functions for Conditional Calculations

ExcelIsFun - 9 years ago

22,285 views
9:42 Fast English (US)

Basic Excel Business Analytics #69: Monte Carlo Simulation for Baseball World Series

ExcelIsFun - 9 years ago

9,477 views
15:55 Conversational English (US)

Basic Excel Business Analytics #68: Monte Carlo Simulation Histogram for Construction Project Length

ExcelIsFun - 9 years ago

13,913 views
11:45 Conversational English (US)

Basic Excel Business Analytics #67: Monte Carlo Simulation for Marketing Analysis Binomial Variable

ExcelIsFun - 10 years ago

12,018 views
18:32 Conversational English (US)

Basic Excel Business Analytics #66: Monte Carlo Simulation for New Product, 3 Uncertain Variables

ExcelIsFun - 10 years ago

34,063 views
5:32 Conversational English (US)

Basic Excel Business Analytics #61: Find Alternative Optimal Solution For Transportation Problem

ExcelIsFun - 10 years ago

11,383 views
5:03 Conversational English (US)

Basic Excel Business Analytics #59: Linear Program Special Cases: Infeasible, Unbound, Alternative

ExcelIsFun - 10 years ago

5,156 views
11:34 Conversational English (US)

Basic Excel Business Analytics #62: Excel Solver: Maximize Portfolio Returns

ExcelIsFun - 10 years ago

12,694 views
12:54 Conversational English (US)

Basic Excel Business Analytics #60: Excel Solver: Minimize Transportation Costs, Integer Variable

ExcelIsFun - 10 years ago

52,095 views
16:37 Fast English (US)

Basic Excel Business Analytics #58 Excel Solver to Maximize Contribution Margin

ExcelIsFun - 10 years ago

14,411 views
7:25 Conversational English (US)

Basic Excel Business Analytics #63: Excel Solver Binary Variable Choose Projects Limited Resources

ExcelIsFun - 10 years ago

51,016 views
8:13 Fast English (US)

Basic Excel Business Analytics #55: Summary of 4 Basic Forecasting Methods & Mean Square Error

ExcelIsFun - 10 years ago

11,091 views
12:27 Fast English (US)

Basic Excel Business Analytics #53: Line Charts for Time Series Data

ExcelIsFun - 10 years ago

10,030 views
8:30 Fast English (US)

Basic Excel Business Analytics 52: LINEST, F.DIST.RT, T.DIST.2T & ABS Functions Test of Significance

ExcelIsFun - 10 years ago

6,072 views
4:45 Fast English (US)

Basic Excel Business Analytics #49: LINEST Array Function for Simple Linear Regression

ExcelIsFun - 10 years ago

6,887 views
15:57 Conversational English (US)

Basic Excel Business Analytics #45: Covariance and Correlation to Measure Linear Relationship

ExcelIsFun - 10 years ago

12,772 views
6:36 Fast English (US)

Basic Excel Business Analytics #48: Data Analysis Regression feature

ExcelIsFun - 10 years ago

32,038 views
15:46 Fast English (US)

Basic Excel Business Analytics #44: Intro To Linear Regression & Scatter Chart

ExcelIsFun - 10 years ago

11,198 views
13:33 Fast English (US)

Basic Excel Business Analytics #50: Introduction to Multiple Regression, Data Analysis Regression

ExcelIsFun - 10 years ago

10,731 views
18:28 Conversational English (US)

Basic Excel Business Analytics #46: Slope & Intercept for Estimated Simple Liner Regression Equation

ExcelIsFun - 10 years ago

10,527 views
9:48 Fast English (US)

Excel Magic Trick 1242: Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format

ExcelIsFun - 10 years ago

97,507 views
9:21 Fast English (US)

Mr Excel & excelisfun Trick 174: Clean & Transform GDP Data Set: Advanced Filter? Or Power Query?

ExcelIsFun - 10 years ago

5,405 views
10:52 Fast English (US)

Basic Excel Business Analytics #41: Excel 2016: Introduction to PowerPivot & Data Model

ExcelIsFun - 10 years ago

83,910 views
10:56 Fast English (US)

Basic Excel Business Analytics #38: PivotTable from 4 Million Records with Power Query & Data Model

ExcelIsFun - 10 years ago

17,306 views
12:19 Fast English (US)

Excel Business Analytics #39: Import Related Tables: Power Query Merge? Data Model Relationships?

ExcelIsFun - 10 years ago

23,651 views
1 2 3 4 > 5