إنشاء حساب
الرئيسية
الكورسات
Finance & Accounting
Excel for Accountants & Financial Analysts – Data Analysis, PivotTables, Power Query & Financial Modeling
Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670

Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670

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!!!