46 тысяч подписчиков
180 видео
00182 Partial Match POWER QUERY
00181 Extract largest number inside a cell
00180 Data Disaster GET & TRANSFORM solution
00179 Data Disaster non normalized data
00178 Retrieve Code Based on 2 Criteria
00177 Variable Sized Groups In Each Column
00176 Normalize & Pivot Taco Orders
00175 YouTube Transcript Excel Template
00173 Dynamically Combine Data from Excel Tables
00174 Ranking Values into Tiers
00172 Unique Values for Drop Down List
00171 Create Christmas Lights Using Excel Sheets
00151 Custom Formats, VBA and Nerds!
00154 Unstack Data Challenge With Oz
Video 00040 Data Validation Cleanup in Excel
00166 Count Groups Above or Below Targets
00168 Deb's Spreadsheet Day Formula Challenge
00165 Show Col Header for Matrix Value (Leila's Challenge)
Video 00094 Find 1st negative value and how long to recuperate amount
Video 00106 Reward Points Tracker
00167 Sliding Formula Ranges
00142 Horizontal list to Vertical list (layered transpose)
Video 00079 Find the 2nd upper case letter in a name
Video 00140 Get Address for Largest Value
Video 00135_Cali Data Cleanup_July 30 2015
00159 Create unique and sorted text list
00169 Ankur Shukla's Solution to Deb's Challenge
Video 00015 Pivot Table: How to use a PIVOT FILTER
Video 00097 Reverse the series and chart legend
00141 Formula Auditing Maestro
