1
Excel Magic Trick 401: Quarterly Comparative Report - Pivot Table (PivotTable)
6:10
2009-10-08
2
Excel Magic Trick 402: Monthly Comparative Report - Pivot Table
3:52
2009-10-08
3
Excel Magic Trick 403: March End Quarterly Comparative Report - Pivot Table
8:32
2009-10-08
4
Excel Magic Trick 404: Quarterly Comparative Report SUMIFS function
6:47
2009-10-08
5
Excel Magic Trick 405: Quarterly Comparative Report SUMPRODUCT function
4:41
2009-10-08
6
Excel Magic Trick 610: Pivot Table Year Over Year Sales Calculation From Daily Transactional Data
5:38
2010-05-27
7
Excel Magic Trick 611: Array Formula Year Over Year Sales Calculation From Daily Transactional Data
6:25
2010-05-27
8
Excel Magic Trick 612: Pivot Table Year Over Year Sales Calculation From Dates Listed As Text
5:56
2010-05-27
9
Excel Magic Trick 617: Fiscal Years Not Ending Dec 31 - Total Sales & Year Over Year Formulas
7:32
2010-06-04
10
Excel Dynamic Chart #9: 4 Week Chart Dynamic Formula & Dynamic Data Validation Formula
10:41
2009-12-11
11
Mr Excel & excelisfun Trick 38: Weekly Report Formula or Pivot Table?
8:47
2009-11-27
12
Excel Magic Trick 442: Summarize Monthly Sales With Daily Transactional Dates - 5 Methods
10:29
2009-11-19
13
Excel Magic Trick 679: Adding Yearly Totals From Monthly Data - Date Formatting Trouble (2 Examples)
7:15
2010-07-28
14
Excel Magic Trick 786: Dynamic 5 Week Chart Example When Formulas Better Than PivotTable
10:50
2011-05-21
15
Excel Magic Trick 872: Calculate Quarters From Date:3 Methods
3:51
2012-02-24
16
Mr Excel & excelisfun Trick 120: Summarize By Week and Month, Monthly Totals, Weekly Totals
9:22
2013-04-19
17
Excel Magic Trick 997: Add Daily Sales with Text Day Criteria: 3 or 4 Day Abbreviation Convention
11:36
2013-05-31
18
Excel Magic Trick 1062: SUMIFS: Year Over Year Sales Calculations From Transactional Data Set
7:23
2014-01-04
19
Excel Magic Trick 1065: SUMIFS: Month Over Month Sales Calculations From Transactional Data Set
6:51
2014-01-09
20
Excel Magic Trick 1066: PivotTable: Month Over Month Sales Calculations From Transactional Data Set
2:23
2014-01-09
21
Excel Magic Trick 1103: Formulas for Quarters, Fiscal Quarters & Fiscal Years
8:51
2014-04-25
22
Excel Magic Trick 1128: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula
26:34
2014-07-13
23
Excel Magic Trick 1129: Aging Accounts Receivable Reports Using Slicer, Excel Table, Page Setup
9:20
2014-07-15
24
Excel Magic Trick 1130: Aging Accounts Receivable Reports Using Advanced Filter & Page Setup
6:51
2014-07-15
25
Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable
6:55
2014-07-15
26
Excel Magic Trick 1203: 2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change
9:09
2015-05-26
27
Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report
13:34
2017-04-15
28
Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records
5:26
2017-04-15
29
Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records
5:26
2017-04-15
30
Excel Magic Trick 1406: Calculate Moving Average with AVEARGEIFS & EOMONTH Functions
7:05
2017-04-17
31
Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables
12:46
2017-04-19
32
Mr Excel & excelisfun Trick 181: Month To Date: PivotTable or Excel Formulas?
13:18
2017-04-21
33
Excel Magic Trick 1456: PivotTable & Slicer to Create 8 Year Sales Report by Product & Month
4:35
2017-08-21
34
Excel Magic Trick 1471: Array Formula: Add Daily Rainfall 5 AM to 5 AM Next Day: (Most Automatic)
37:16
2017-12-13
35
Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS
7:09
2019-02-14
36
MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH
6:17
2019-05-23
37
Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change
3:27
2019-07-05
38
Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales
4:20
2019-07-07
39
Excel Magic Trick 1560: Half Year Running Totals in PivotTable
5:32
2019-07-08
40
DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561)
11:06
2019-07-09
41
Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651
4:17
2020-03-23
42
Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652
5:42
2020-03-24
43
Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658.
9:56
2020-04-03
44
Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667
8:26
2020-05-09
45
LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673
7:01
2020-06-22
46
Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674
6:07
2020-06-29
47
Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675.
6:01
2020-07-01
48
List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687.
7:07
2020-09-07
49
List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688.
4:47
2020-09-09
50
Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689.
6:59
2020-09-11
51
FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693.
13:30
2020-10-05
52
Excel FILTER based on list, not individual values? Easy! Excel Magic Trick 1696.
3:56
2020-10-18
53
Biggest Sale for Each Product: PivotTable, Formulas or Power Query? Excel Magic Trick 1700.
5:59
2020-11-13
54
Basics of SUMIFS & PivotTables for Monthly Sales Report. Excel Magic Trick 1701.
9:20
2020-11-16
55
Basics of Excel Spilled Array Formulas to create Monthly Sales Report. Excel Magic Trick 1702.
15:02
2020-11-19
56
Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703.
24:50
2020-11-23
57
12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707
14:38
2020-12-09
58
Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724
4:27
2021-02-15
59
Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725
15:43
2021-02-18
60
Moving Annual Total with DAX Measure. Excel Magic Trick 1726.
4:50
2021-02-23
61
3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779
11:33
2022-03-16
62
HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781
11:30
2022-03-18
63
Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787
18:07
2022-03-28
64
DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788
12:14
2022-03-31
65
PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859
2:48
2024-03-25
66
GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855
5:59
2024-02-29
67
1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862
3:26
2024-07-28
68
GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863
6:00
2024-08-04
