إنشاء حساب
الرئيسية
الكورسات
Finance & Accounting
Excel for Accountants & Financial Analysts – Data Analysis, PivotTables, Power Query & Financial Modeling
Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604

Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604

Excel for Accountants & Financial Analysts – Data Analysis, PivotTables, Power Query & Financial Modeling

محتوى الكورس

جميع الدروس
416 درس
22:28 Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar
51:24 Excel for Accountants: Power Query & PivotTables to Import & Clean Data and Build Reports
37:02 Excel for Accountants: Formulas, Functions & Formatting to Build Account Templates (37 Examples)
35:38 PivotTables & Slicers Made Easy! 4 Amazing Examples for WAAT Accounting Seminar August 26, 2016
18:51 All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX – 28 Examples! - 365 MECS 08
44:08 Excel & Power BI Data Analysis Complete Class in One Video - 4 Hours - Download Files - 365 MECS 04
44:10 Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards
32:45 Excel For Accountants: VLOOKUP & PivotTables Complete Lessons: Basic to Advanced: CWU Seminar
01:03 10 Amazing Excel Lookup Formulas for WAAT Accounting Seminar August 26, 2016, VLOOKUP & More
19:49 Excel 2013 Accounting Tricks for Excel CPE Credit at Poodle Dog Restaurant (50 Examples)
18:02 Excel Magic Trick 744: Break Even Analysis Formulas Chart & Plotting Break Even Point On Chart
04:47 Excel 2013 PivotTables from A to Z for the Northwest Accounting Educators 2015 Conference
22:24 Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression - Ron's Class
07:10 ACCTG 455: Excel Finance Class 84: Undoing Accrual Accounting to Get Cash Flows For Estimating NPV
40:00 Excel Accounting Schedule of Expected Cash Collections Using A Set Of Assumptions / Formula Inputs
09:20 Excel Magic Trick 1129: Aging Accounts Receivable Reports Using Slicer, Excel Table, Page Setup
06:51 Excel Magic Trick 1130: Aging Accounts Receivable Reports Using Advanced Filter & Page Setup
09:36 Excel Magic Trick 1133: Aging Accounts Receivable Reports: PivotTable & Unique Identifier
26:34 Excel Magic Trick 1128: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula
47:41 Excel for Accounting and Finance - Northwest Accounting Educators Conference 2012 - NAE 2012
52:08 Excel 2010 - 20 New Excel 2010 Features - Northwest Accounting Educator's Conference 2011
07:19 Excel Magic Trick #132: Borders For an Accounting Template
10:58 Excel Magic Trick 745: Allocating Indirect Expenses to Calculate Departmental Net Income Accounting
17:25 Excel 2010 Statistics 48: Accounting & Finance Examples of Expected Value & Standard Deviation
02:18 Excel Magic Trick 739: Three Ways To Do Double Underline in Excel
30:17 ACCTG 455: Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis
38:26 ACCTG 455: Excel Finance Class 11: Finance Cash Flow From Accounting Information
06:03 Excel Magic Trick 695: Allocate Total Costs across Categories Including Extra Pennies
10:51 Excel Magic Trick 607: Match 3 Lists: Matching Accounting Documents PO, Receiving & Invoice
03:15 Excel Magic Trick 366: Lookup Adding For Accounting Estimate
18:34 Excel Busn Math 41: Payroll Deductions With Ceilings (FICA)
13:26 Highline Excel 2013 Class Video 49: Break Even Analysis Formulas & Chart, Plotting Break Even Point
03:47 Excel Magic Trick 1074: Multiply Quantity Times Debit or Credit: 3 Formulas Examples.
05:50 Excel Magic Trick 1078: Total Cost Based On Per Minute Charge & Excel Time Values Nearest 15 Seconds
03:21 Excel Magic Trick 1077: Floating Cell In Excel? Watch Window to See Formula Anywhere in Workbook
06:55 Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable
12:07 Power BI Desktop: Build Data Model, Get Data, DAX Formulas, Visualizations, Publish 2 Web (EMT 1366)
10:40 Excel Magic Trick 1410: Calculate Closing Balance for Each Month from Balance Transaction Table
40:45 Power BI for Accountants: Complete Introduction to Power BI Desktop to Build Reports & Dashboards
10:35 Excel Magic Trick 1455: Convert Text Month Criteria to Upper & Lower Dates for SUMIFS Function
19:11 MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop
21:19 MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries
06:46 Excel Magic Trick 1515: Yearly Income Statement Using SUMIFS Function, and NO Merge & Center
19:09 MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel
39:40 Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)
07:44 Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518
09:16 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520
13:02 Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528
09:57 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521)
12:31 Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530)
04:00 MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions
19:35 MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing
08:30 VLOOKUP To Get Complete Record: ROWS, COLUMNS or SEQUENCE Function? EMT 1532
07:56 VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function?
08:08 EMT 1535: Average Daily Revenue: SUMIFS with INDIRECT? or SEQUENCE? Inside AVERAGE
10:50 EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts
04:39 Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue
48:28 MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples)
05:46 Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array).
06:00 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column
07:09 Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS
07:09 Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?!
26:40 E-DAB 06: The Magic of Power Query to Import, Transform & Load Data
45:21 E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?
44:42 E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards
37:37 E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations
14:37 E-DAB-10: Excel & Power BI Together! Import, Publish and Share Reports & Visualizations
06:20 Excel Magic Trick 1544: FILTER Array Function to Filter Between Upper & Lower Text Number Limits
01:10 Excel Table NOT Automatically Add New Column or Rows? Option Setting to Fix This. Magic Trick 1547
02:12 COUNTIFS in Power Query? Excel Magic Trick 1549
03:11 COUNTIFS in DAX for Power Pivot or Power BI? COUNTROWS Function. Excel Magic Trick 1550
11:07 MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query
04:59 MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table
07:46 Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND
06:17 MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH
10:51 MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model
13:38 MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
17:28 MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship
10:20 MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas
21:48 Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554
03:32 Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555
00:54 Create Column of Month End Dates in Excel - Excel Magic Trick 1556
01:10 Keyboard Shortcut to Open Smart Tags in Excel, Word & PowerPoint (Excel Magic Trick 1557)
03:27 Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change
04:20 Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales
05:32 Excel Magic Trick 1560: Half Year Running Totals in PivotTable
01:08 Jump To Any Excel Sheet – 7 Methods in One Minute – Excel Magic Trick 1562
02:51 Last Working Day Of Month – Excel Formula – Excel Magic Trick 1563
04:11 Unique Invoice / Vendor List with Items Listed Horizontally - Excel Dynamic Array Formula- EMT 1575
07:25 Power Query M Code Group By Formula to Transform Invoice Table - Excel Magic Trick 1576
09:30 Power Query - Group Suppliers, Join with Line Feed From Multiple Text Files - Excel Magic Trick 1580
01:29 Extract Data From Cell with Flash Fill - Excel Magic Trick 1582
01:48 Extract Date from End of Description with Excel Worksheet Formula - Excel Magic Trick 1583
08:51 Count Number of Saturdays in Month - 5 Different Formulas!- Excel Magic Trick 1587
25:02 Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600
03:56 3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602
04:14 Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601
03:13 Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603
03:29 Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604
03:27 Sum Last Digits for All Numbers - Excel Magic Trick 1605
04:22 DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607
07:48 Dynamic Array & Old Array Formulas to Create Student Classes Report - Excel Magic Trick 1608
03:47 Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613
09:32 Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620
09:44 Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622)
03:46 Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625
18:34 Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626)
04:23 VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627
15:43 Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621
13:23 MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables
02:37 Count NOT “Apple” with Excel Formula & Conditional Formatting - Excel Magic Trick 1630
10:46 Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629.
09:00 Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631.
04:03 Dynamic Inventory Running Total Excel SUMIFS Formula Based on Transaction Records (EMT 1632)
05:32 Excel Formula for Discounted Sales: Standard Formula or Spilled Arrays? Excel Magic Trick 1636
03:32 TEXTJOIN & MID? LEFT, 2 MID, RIGHT? Excel Formulas to Insert Dashes into Text Excel Magic Trick 1637
03:44 Power Query to Insert Dashes into Text. Flash Fill too! Excel Magic Trick 1638
17:24 Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634
02:51 Which Lookup Formula is Fastest? Excel Magic Trick 1631 Part 02
02:36 REPLACE Function to Insert a Dash Into Text. Flash Fill Too. Excel Magic Trick 1639
06:45 Flash Fill, Array Formula or Power Query? To Insert Dash Between Text & Number. EMT 1641
01:11 excelisfun YouTube Birthday Party: 12 Years @ YouTube. Feb 15, 2008 – Feb 15, 2020.
08:55 Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643
06:47 Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644.
06:35 OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645
08:05 Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647
05:28 Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648
04:26 Create a Dynamic Lookup Table using INDEX & LOOKUP Functions. Excel Magic Trick 1649
05:03 Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650.
04:17 Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651
05:42 Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652
03:33 Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653
04:31 INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654
03:09 Excel Music Video: UNSTOPPABLE Office 365 Excel. Old School Formulas v. New School Formulas EMT 1655
11:34 COUNTIFS 6 Criteria Counting Cross Tab Report. Change Cell Reference Every 3 Columns Too! EMT 1656
05:35 PivotTables Are Easy: 6 Criteria Cross Tabulated Counting Report. Excel Magic Trick 1657.
09:56 Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658.
18:33 Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659
00:57 Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662
22:22 Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660.
08:18 Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661
06:49 Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663
10:42 Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664
08:49 Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665.
08:26 Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667
06:08 Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.
12:18 Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670
07:28 SORTBY, UNIQUE, INDEX and SUMIFS Functions: Dynamic Spilled Array Reports. Excel Magic Trick 1671
06:38 Lookup 2nd Smallest Number. 2nd Biggest too. UNIQUE or FREQUENCY function? Excel Magic Trick 1672
07:01 LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673
06:07 Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674
06:01 Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675.
04:52 Convert SAP Dates to Real Dates in Excel. Excel Magic Trick 1676
01:51 Replace & Text To Columns to Convert Text Dates to Real Dates. Excel Magic Trick 1677
11:50 Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678.
03:38 Excel Table Column Formulas and Spilled Arrays? Excel Magic Trick 1679
06:02 Excel Conditional Formatting Weekend & Holiday Date for Row in Table. Excel Magic Trick 1680.
14:32 LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681.
05:10 Append Two Number Columns and Sort. Excel Magic Trick 1682.
17:11 Dueling Excel #191: Net Working Hours Spanning Midnight & Weekend with Mr Excel & Excelisfun
07:59 Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683.
02:01 SPLIT, JOIN and ARRAYFORMULA Functions in Google Sheets to Split Text & Add Numbers. GS 1. EMT 1684.
05:08 FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685.
11:21 Dynamic Excel Amortization Table. Microsoft 365 Spilled Array Magic! Excel Magic Trick 1686.
07:07 List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687.
04:47 List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688.
06:59 Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689.
08:08 Create Excel Database and Data Entry Form. Excel Magic Trick 1690.
09:56 Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691.
13:30 FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693.
05:20 XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694.
09:38 Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695.
03:56 Excel FILTER based on list, not individual values? Easy! Excel Magic Trick 1696.
06:11 OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697.
03:44 How to Rank in Power Query. EMT 1698 by excelisfun.
18:53 Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699.
05:59 Biggest Sale for Each Product: PivotTable, Formulas or Power Query? Excel Magic Trick 1700.
09:20 Basics of SUMIFS & PivotTables for Monthly Sales Report. Excel Magic Trick 1701.
15:02 Basics of Excel Spilled Array Formulas to create Monthly Sales Report. Excel Magic Trick 1702.
24:50 Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703.
01:51 Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.
09:11 MOD function & Number.Mod Functions. Why They Give Different Answers. Excel Magic Trick 1705.
05:26 LAMBDA Excel Function. LET & LAMBDA together to make Single Cell Reports. Excel Magic Trick 1706
14:38 12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707
05:15 Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708.
06:56 Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709
08:35 Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710
01:56 Excel Magic Flashing Christmas Tree. Plus, BIG LET Surprise!!! Excel Magic Trick 1711
14:09 INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712.
09:24 Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713
13:09 Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.
02:02 Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715
04:52 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716
06:57 Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717
03:32 INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718
07:19 Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719
07:02 PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720
05:04 Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721
01:18 Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2
05:06 Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722
04:12 Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723
04:27 Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724
15:43 Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725
04:50 Moving Annual Total with DAX Measure. Excel Magic Trick 1726.
05:34 Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.
07:08 4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729.
12:17 PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730
06:10 Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731
04:35 Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732
03:00 Create PivotTable in Excel Online. Excel Magic Trick 1733.
04:38 Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.
03:27 Organizational Data Types in Excel M365 & Power BI. Excel Magic Trick 1735
05:30 Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data
06:21 Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.
36:04 Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts
16:25 Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!
16:13 Excel Data Analysis Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals
58:02 Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas
09:45 Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737.
11:44 Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738.
05:56 SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739
11:18 Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740
02:43 Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741
11:38 Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742
10:33 OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
06:16 Average Excluding Min and MAX Values. TRIMMEAN function. 6 Formula Examples. EMT 1744
10:15 11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745
09:05 IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746
16:31 Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747
06:59 Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748
16:30 7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749
03:04 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750
04:43 Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751
09:14 Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752
01:58 Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753
04:46 Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754
04:29 Import OneDrive File or Folder using Power Query. EMT 1755
02:29 Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756
05:26 VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758
04:14 Excel Hack Video: Power Query to fix files in Windows Explorer? Excel Magic Trick 1759
04:33 VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760
02:09 INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2.
03:46 Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761
08:19 Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762
12:37 Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763
10:14 Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764
05:24 Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765
11:09 Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766
09:49 Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767
02:18 Excel Flashing Christmas Tree 2021- Happy Holidays Old School Formula Method. EMT 1768
05:34 SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769
06:35 Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770
07:13 FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771
02:07 Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772
02:48 Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773
06:21 Sum Top 3 Values When There Is Missing Data – 3 Unbelievable Solutions (LAMBDA too) EMT 1775
06:05 Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method - EMT 1776
10:51 COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777
03:49 Power Query: Extract Records For Invoices 1 to 30 Days Past Due - EMT 1778
11:33 3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779
05:34 HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780
11:30 HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781
18:35 14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782
08:29 Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783
03:38 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784
10:20 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785
06:29 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786
18:07 Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787
12:14 DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788
03:26 TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789
04:07 Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790
06:59 XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791
12:05 Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792
08:39 Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793
03:02 Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795
07:50 Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796
04:04 Excel Formula to make First a 1, Second a 2, Third a 3, and so on. 6 Formula Examples. EMT 1797
07:18 Create Sequence of Time Values in Excel for Stock Market Price Data – Excel Magic Trick 1798
04:41 FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799
03:52 Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800
03:24 FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801
03:28 Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802
03:29 XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804
05:22 Spilled 2-Way Lookup Commission Report using LAMBDA and BYROW Functions. EMT 1803
08:06 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805
04:06 Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806
07:37 Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807
04:39 Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808
01:19 Excel Sparkling Christmas Tree with Changeable Ornaments with LAMBDA function! EMT 1809
04:00 Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810
09:47 Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811
02:45 Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shorts
03:38 Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts
01:55 Remove All Excel Format to Help Fix Reports and Data Errors. Excel Magic Trick 1814 #Shorts
01:25 Save Time in Excel: Copy Only Excel Format with Format Painter. Excel Magic Trick 1815 #Shorts
00:59 Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts
00:45 excelisfun @ YouTube for 15 Years! Birthday Party!
05:38 Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817
01:34 Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_
06:04 Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818
16:06 Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819
49:33 Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13
03:38 Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14
22:02 7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15
33:49 Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16
00:36 Word Replace Feature for Special Characters: Replace All Hard Returns with 2 Hard Returns. #Short
03:53 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820
02:54 Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822
02:53 Excel Formula To Randomly Lookup Pictures or Any Item. Excel Magic Trick 1823
07:33 Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824
05:59 Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825
06:55 Formula to Calculate Hours Worked in Excel & DAX: Day or Night Shift! Excel Magic Trick 1826
08:54 3 Power Query Formulas: Hours Worked for Day & Night Shift from Time Values. Excel Magic Trick 1827
02:49 LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828
03:03 LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2
03:05 Federal Income Tax Calculation: LOOKUP Function Beats VLOOKUP & XLOOKUP! EMT 1828 Part 3
03:34 LOOKUP Beats XLOOKUP For Single Cell Revenue Calculation. SUMPRODUCT Too! EMT 1829
02:09 LOOKUP Beats XLOOKUP For Horizontal / Vertical Lookup. Excel Magic Trick 1830
03:27 Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831
03:35 Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832
04:36 XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833
09:03 Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834
03:30 Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835
06:10 FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837
04:17 Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function?
05:42 Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836
05:15 Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838.
04:02 Excel Formula: Extract City Name from Description. Excel Magic Trick 1839
07:46 Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840
08:29 FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841
03:33 FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842
02:23 FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843
28:33 GROUPBY Excel Worksheet Function. Single Cell Reports Made Easy! 11 Examples. EMT 1844
03:07 2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2
19:34 Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845
02:29 ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846
04:30 Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847
05:50 Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848
05:41 Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849
03:02 Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850
02:58 Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851
01:08 Append Tables in Excel. Excel Magic Trick 1852
02:14 Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853
03:23 Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854
05:52 Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856
03:09 Generate Random Data Sets with Dates & Sales Numbers: RANDARRAY Function. Excel Magic Trick 1857
02:48 PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859
03:10 Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858
05:59 GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855
03:38 Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860
01:56 UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861
03:26 1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862
06:00 GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863
02:52 Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864
13:32 Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865
11:30 Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866
05:45 GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870
06:54 BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871
13:36 Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872
03:24 FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874
04:42 No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875
02:33 Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876
02:21 PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877
02:30 Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68
00:42 Increase All Numbers by a Multiple of 10: Excel Paste Special Multiply Magic!! Short Excel Trick 69
02:23 Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70
00:46 Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71
02:35 Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878
01:22 PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879
02:11 GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks?
51:23 MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!
28:49 MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples.
04:21 Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882
02:45 GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883
01:59 The Beauty Of Power Query! One Quick Example : )
01:23 File Explorer Skills To Be Good In Excel? 100% Yes! File Extensions & F2 Trick! EMT 1885
03:00 Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886
03:42 INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888
03:56 Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889
03:08 Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890
06:09 COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891
17:12 Excel Formula to UnPivot!? with Magic From the Functions: TOCOL, IFS, CHOOSEROWS & More! EMT 1887
17:44 Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887
02:51 Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892
06:26 XLOOKUP, LEFT, TEXTBEFORE, & LOOKUP Functions & Math Tricks to Calculate Discounted Sales! EMT 1893
03:22 Create Random Dates with Excel Functions. Excel Magic Trick 1894
01:51 Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895.
02:13 Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896
04:40 Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897
08:20 Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898
04:54 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899
13:29 PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900
24:46 COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901
24:47 Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902
05:11 Excel TEXTSPLIT function to Split Values By Delimiter & More! Excel Magic Trick 1904
02:34 Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905
05:35 Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906
03:40 Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907
07:43 The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908
04:25 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909
07:25 Magic Data Validation List using Dynamic Range Reference or Spilled Range Operator!! EMT 1910
08:45 Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911
12:11 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912
10:16 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913
07:54 PivotTable New Features (Spill Error & Auto Refresh) and PivotTable Basics Revealed. EMT 1914
05:09 2 Excel Formulas to Add Sequential Numbers Each Time a New Row Is Added To a Table. EMT 1915
10:10 Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916
09:41 Part 2: Power Query Unpivot Cross Tab Table with 2 Column Variables. An Easier Way! EMT 1916 Part 02
18:18 Build Power Query Custom Function: Convert Multiple Csv Cross Tab Tables into Single Table EMT 1917.
15:21 Power Query Nested Functions in Custom Column: Convert Multiple Csv Files into One Table. EMT 1918
13:18 Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919
02:44 excelisfun Flashback Friday 6: Sparkling Christmas Tree in Excel! Build Conditional Formatting Tree
07:47 Complete Lesson in Excel Text Formulas that use References to Dates, Money & Arrays. EMT 1920.
11:12 Excel Formula for Accounting Bank Reconciliation with IF, ISNUMBER & SUM Functions. EMT 1921.
10:54 Excel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation. EMT 1922.
00:55 Last Video From Mike "excelisfun" Girvin on Feb 16, 2026, 18 years at YouTube!!! Go Team!!!