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