| 0001 INDEX MATCH MATCH.xlsx | INDEX MATCH MATCH in Excel (How to do 2-dimension lookup) |
| 0003 Remove blank rows.zip | Remove blank rows in Excel |
| 0004 Change image based on cell.zip | How to change images based on cell values (3 ways) |
| 0005 Apportion value across cells.zip | Apportion a value across cells with VBA |
| 0006 Convert color codes Downloads.zip | How to convert color codes (RGB, HSL, HSV, Hex, Long, CMYK) |
| 0007 Add suffix or prefix with VBA.zip | How to add a prefix or suffix to every cell using VBA |
| 0008 Power Query running total.xlsx | Power Query – Running Total |
| 0009 VBA Tables and ListObjects.zip | VBA Tables and ListObjects |
| 0010 Percent of total in Power Query.xlsx | How to calculate Power Query Percent of total or category |
| 0014 Power Query absolute and relative references.xlsx | Power Query – Absolute and relative references |
| 0015 Top 10 using formulas.xlsx | How to calculate Top 10 with formulas in Excel |
| 0016 VBA Protect and Unprotect Sheets.zip | VBA protect and unprotect Sheets (25+ examples) |
| 0017 VBA Arrays.zip | VBA Arrays |
| 0018 Dynamic Array UDFs.zip | Dynamic arrays and VBA user defined functions (UDFs) |
| 0019 Save Excel as PDF with VBA.zip | How to save Excel as PDF with VBA (10 examples) |
| 0020 Interpolate with Excel.xlsx | How to Interpolate in Excel: 4 simple ways |
| 0021 Power Query Source File Path.zip | Change the Power Query source based on a cell value |
| 0022 Automated Goal Seek.zip | How to automate Goal Seek in Excel with VBA Macro (2 ways) |
| 0023 Split delimited cells into rows.zip | Power Query – Split delimited cells into rows |
| 0024 Power Query Combine rows into a single cell.zip | How to combine rows in Power Query |
| 0027 Switch chart between monthly and quarterly.zip | Switch chart between monthly and quarterly |
| 0028 Drop down lists in Excel.xlsx | How to add a drop-down list in Excel (3 easy ways) |
| 0030 Loop through selected sheets with VBA.zip | Loop through selected sheets with VBA |
| 0032 UNIQUE function in Excel.zip | UNIQUE function in Excel (How to + 6 Examples) |
| 0033 SORT function in Excel.zip | SORT function in Excel (How to + 6 Examples) |
| 0034 SORTBY function in Excel.zip | SORTBY function in Excel (How to + 6 Examples) |
| 0035 FILTER Function in Excel.zip | FILTER function in Excel (How to + 8 Examples) |
| 0036 SEQUENCE function in Excel.zip | SEQUENCE function in Excel (How to + 5 Examples) |
| 0037 RANDARRAY function in Excel.xlsx | RANDARRAY function in Excel (How to + 4 Examples) |
| 0038 Dynamic arrays with other Excel features.xlsx | How to use dynamic arrays with other features (7 scenarios) |
| 0039 Dynamic array formula techniques.xlsx | Advanced dynamic array formula techniques (3 methods) |
| 0040 Combining tables in a PivotTable.zip | How to create a PivotTable from multiple Tables (easy way) |
| 0041 VBA copy move delete and manage files.zip | VBA code to copy, move, delete and manage files |
| 0042 VBA copy insert move delete pictures.zip | How to Insert, Move & Delete Pictures with VBA |
| 0043 Power Query Date Formats.zip | Power Query date format (How to + 5 tricky scenarios) |
| 0045 CHAR function in Excel.xlsx | CHAR function in Excel |
| 0046 INFO function in Excel.xlsx | INFO function in Excel |
| 0047 Excel VBA guide to Pivot Tables.zip | Excel VBA for Pivot Tables |
| 0049 List of all possible combinations.zip | How to list all possible combinations from multiple lists (2 ways) |
| 0050 Sankey diagrams in Excel Complete.xlsx | How to create a Sankey diagram in Excel |
| 0051 Split cells in Excel.zip | How to split cells in Excel: 4 simple ways |
| 0052 Insert file path into cell with Browse button.zip | Browse for file path with VBA: insert value into cell |
| 0053 GETPIVOTDATA vs CUBE Functions Start.xlsx | GETPIVOTDATA vs CUBE functions |
| 0057 Forecast with Seasonality FORECAST.ETS.xlsx | How to forecast seasonality in Excel (the easy way) |
| 0060 Use Office Scripts with Power Automate.zip | Use Office Scripts with Power Automate |
| 0063 Calculate CAGR in Excel.xlsx | How to calculate CAGR in Excel (5 easy ways) |
| 0065 Clear old items in PivotTable.zip | Clear old items from a PivotTable filter list |
| 0066 Rename columns in Power Query.zip | Rename columns in Power Query when names change |
| 0067 Create step chart in Excel.zip | How to create a step chart in Excel |
| 0069 Fan Chart in Excel.zip | Create a fan chart in Excel |
| 0070 Date and time of refresh.zip | Get the refresh date & time in Power Query |
| 0071 Power Query Filter All.zip | Filter All in Power Query |
| 0073 Save PDFs based on a list.zip | Excel – Create multiple PDFs based on a list |
| 0074 Slopegraphs in Excel.zip | Create Slopegraphs in Excel |
| 0075 Running Totals in Excel Tables.zip | Running total in an Excel Table |
| 0076 Data Validation with Tables.zip | How to use Excel Table within a data validation list |
| 0089 Get data into Power Query.zip | How to get data into Power Query – 5 common data sources |
| 0090 Refresh Power Query.zip | Refresh Power Query in Excel: 4 ways + advanced options |
| 0091 Edit Queries.xlsx | Use the Power Query editor to update queries |
| 0103 Using Parameters.zip | Power Query Parameters: 3 methods |
| 0104 Power Query Append.zip | Power Query Append: Quickly combine many queries into 1 |
| 0107 Power Query Combined Files.zip | Get data from folder in Power Query: combine files quickly |
| 0109 Get data from current workbook.xlsx | How to get data from the Current Workbook with Power Query |
| 0110 Unpivot data.xlsx | How to unpivot in Excel using Power Query (3 ways) |
| 0111 Lookup Data Example.xlsx | Power Query: Lookup value in another table with merge |
| 0113 Show hidden data in Excel chart.zip | How to show hidden data in Excel chart |
| 0115 Power Query if statement.xlsx | Power Query If statement: nested ifs & multiple conditions |
| 0116 Power Query Group By.xlsx | How to use Power Query Group By to summarize data |
| 0117 Power Query Custom Functions.xlsx | How to use Power Query Custom Functions |
| 0118 Reference another workbook.zip | How to reference another workbook without opening: 5 DANGERS! |
| 0119 Looping through Data Validation list.zip | How to loop through each item in Data Validation list with VBA |
| 0122 Excel Table absolute reference.xlsx | Excel Table absolute reference for cells, columns, and rows |
| 0123 Close VBA UserForms.zip | How to close VBA UserForm: Hide vs Unload |
| 0126 Formula.Firewall in Power Query.zip | How to fix the Formula.Firewall error in Power Query (2 ways) |
| 0128 Dynamic chart labels.zip | How to create dynamic chart legends in Excel |
| 0132 Office Script UserForms.zip | How to create user forms in Office Scripts (4 ways) |
| 0134 Commentary Writing Formula.xlsx | Automatic commentary writing formula in Excel – Amazing LAMBDA |
| 0137 Power Query filter by list.zip | How to filter by a list in Power Query (4 methods) |
| 0138 Any macros from button.zip | How to run any macro from one button (magic macro) |
| 0139 QR Code in Excel.zip | How to create QR codes in Excel for FREE (3 easy ways) |
| 0140 PQ Sheet or Table Names Change.zip | Power Query: Get data when sheet/Table names change (2 ways) |
| 0141 Expand Columns Dynamically.zip | How to expand columns dynamically in Power Query |
| 0142 Create Sheets from PivotTable Items.zip | How To Create Sheets For Each Item In PivotTable Field |
| 0143 Run macros from Power Automate Desktop.zip | How to run Excel macros from Power Automate Desktop |
| 0144 Number format for finance.xlsx | Excel number formats for accounting & finance you NEED to know |
| 0146 Filter by a list.xlsx | How to FILTER by a list in Excel (including multiple lists) |
| 0147 Number Formats inside the TEXT function.xlsx | How to create dynamic text in Excel (TEXT + Number Formats) |
| 0148 Waffle Chart in Excel.xlsx | How to make Waffle Charts in Excel: The EASIEST way |
| 0149 Waffle Chart Complete.xlsx | How to make Waffle Charts in Excel that work EVERYWHERE! |
| 0150 Power Query connect file list.zip | Power Query: How to Combine files based on a list |
| 0152 Transform Nested Table.zip | How to transform nested tables in Power Query (without coding) |
| 0153 Find and replace multiple values.xlsx | How to Find & Replace multiple words in Excel: REDUCE & SUBSTITUTE |
| 0154 Fiscal Month Year Quarter in Power Query.xlsx | How to add fiscal Month, Quarter or Year Column in Power Query |
| 0156 Replace values based on a list.xlsx | Power Query: How to multiple replace values based on a list |
| 0157 Multiple PDFs Office Scripts and Power Automate.zip | How to create Multiple PDFs from Excel (Office Scripts + Power Automate) |
| 0158 Rename Columns Example.zip | Power Query: Rename columns in nested tables from list (without errors) |
| 0159 Cross Filtering Visuals in Excel.zip | How to make cross filter visuals in Excel (amazing interactive visuals) |
| 0165 Special Characters Cheat Sheet.pdf | How to insert Special Characters (Cheat Sheet Download) |
| 0166 Advanced VLOOKUP.pdf | How to use VLOOKUP
VLOOKUP: How to calculate faster
How to VLOOKUP to the left
VLOOKUP: Change the column number automatically
VLOOKUP with multiple criteria
Using wildcards with VLOOKUP
How to VLOOKUP row and column
Automatically expand the VLOOKUP data range
VLOOKUP: Lookup the nth item (without helper columns)
VLOOKUP: List all the matching items
Advanced VLOOKUP Cheat Sheet |
| 0167 Map Template.zip | Creating custom Map Charts using shapes and VBA |
| 0168 Bulk Email Template.zip | Automatic e-mail template for Excel |
| 0169 Excel 4.0 Macro Functions Reference.pdf | Using Excel 4 Macro Functions |
| 0170 Chart Min Max based on cell value.zip | How to set chart axis based on a cell value |
| 0171 Dynamic chart title with formatting.zip | Create dynamic chart titles with custom formatting |
| 0172 Sort ListBox After Load.zip | Sorting ListBoxes with VBA |
| 0173 Hide or Disable UserForm Close Button.zip | Hide or disable a VBA UserForm [X] close button |
| 0174 Unstacking Data Column.xlsx | Power Query – Unstacking data in a column |
| 0178 Resize VBA UserForm.zip | Resize a UserForm with VBA or Windows API |
0179 Cell Range Basics.xlsx
0179 Cell Range Basics Cheat Sheet.pdf | Cell ranges: 99% of users don’t know this |
| 0180 VBA Swap ranges.zip | How to easily swap ranges in Excel (1 click) |
| 0181 Chart Data from Power Query.zip | How to create Chart Data from Power Query |
| 0183 Excel v Power Query Function Comparision.pdf | Text functions – Excel & Power Query comparison |
| 0184 Power Query Reconciliation.zip | Automate Reconciliations with Power Query |
| 0186 Add manual info to a query.zip | How to add manual information to a query (commentary & references) |
| 0187 Spill multiple filter functions.zip | How to spill multiple FILTER functions in Excel |
| 0188 Promote headers before expand.zip | Promote headers in nested tables before expanding columns (2 ways) |
| 0189 SUMIFS with arrays.zip | How to use SUMIFS with arrays (Excel problem solved!) |
| 0191 Quarter from dates.zip | Calculate quarter from dates in Excel (inc non-standard calendars) |
| 0192 Dynamic dumbbell dot plot.zip | How to make a Dumbbell Dot Plot in Excel (100% dynamic) |
| 0193 EOMONTH Function in Excel.zip | EOMONTH function in Excel (How to + 8 examples) |
| 0194 Dynamic jitter plot.zip | How to create a Jitter Plot in Excel (100% dynamic) |
| 0195 Slicer with PIVOTBY, GROUPBY & FILTER.zip | How to use slicers with PIVOTBY, GROUPBY & FILTER in Excel |
| 0198 Table slicers for user interactivity.zip | How to use Table slicers for advanced interactivity in Excel |
| 0199 Change number format.zip | Change number format based on a cell value in Excel |
| 0200 Don’t trust data validation.zip | Don’t trust data validation in Excel |
| 0202 Create multiple folders.zip | How to create multiple folders at once with Excel |
| 0205 VBA Copy File.zip | How to copy files with VBA in Excel |
| 0206 Weighted Average in Excel.xlsx | How to calculate Weighted Average in Excel (4 easy examples) |
| 0207 Auto refresh Power Query.zip | Auto refresh Power Query in Excel |
| 0210 Convert text to formula.zip | How to convert text to a formula in Excel |
| 0212 Power Query M code tricks.zip | 10 awesome Power Query tricks you need to know! (YouTube) |
| 0213 Data structure.zip | The #1 Excel formula issue – Data structure (YouTube) |
| 0214 FILTER function tricks.zip | FILTER Function tricks to go beyond the next level (YouTube) |
| 0215 PQ Calendar Table.zip | Power Query Calendar Table – Financial & Non-Standard Calendars (YouTube) |
| 0217 IMAGE function techniques.zip | Awesome IMAGE function techniques you need to know (YouTube) |
| 0218 Change category – keep history.zip | Change category while keeping history (YouTube) |
| 0219 Dynamic Array in Table.zip | Using dynamic arrays in a Table (YouTube) |
| 0220 BYROW MAP SCAN REDUCE Comparison.zip | Advanced Excel Functions | BYROW vs MAP vs SCAN vs REDUCE (YouTube) |
| 0223 Combine Tables – PQ v VSTACK.zip | Power Query Vs VSTACK: Combine Tables in an Excel workbook (YouTube) |
| 0224 Remove passwords.zip | How to remove Excel passwords (Blog)
Easy way to unlock Unlock Excel and VBA without a Password (YouTube) |
| 0225 Financial Reporting from Trial Balance.zip | Super fast Financial Reporting from Trial Balance (YouTube) |
| 0226 Static to Dynamic.zip | Static to dynamic: Excel formulas for reducing manual work (YouTube) |
| 0228 Coalesce in Power Query.zip | Power Query Secrets: Use coalesce (??) to handle null values (YouTube) |
| 0229 Stop nested IF.zip | STOP using nested IF statements! Use these functions instead (YouTube) |
| 0230 AND OR Broken.zip | The AND Function in Excel is Broken – Here’s How to Fix It! (YouTube) |
| 0231 Running total by row.zip | Advanced Formula Magic: Running total by row with dynamic arrays in Excel (YouTube) |
| 0232 Quick Variance Analysis.zip | SUPERFAST Variance Analysis with Power Query & Dynamic Arrays in Excel (YouTube) |
| 0233 XLOOKUP.zip | Ultimate XLOOKUP Guide: 10 Tips You Need to Know! (YouTube) |
| 0234 Dependent drop-down lists.zip | Easiest Multi-Level Drop-Down Lists in Excel! (YouTube) |
| 0235 Sort slicers.zip | Slicer Sorting Simplified: The quick and effective way that actually works! (YouTube) |
| 0236 XLOOKUP spilling – array of arrays.zip | XLOOKUP Spilling Secret: How to fix the array of arrays problem! (YouTube) |
| 0237 SUPERXLOOKUP.zip | Better than XLOOKUP? Try SUPERXLOOKUP (YouTube) |
| 0238 Even easier dependent drop down lists.zip | Even easier than easiest – Multi Level Dependent Drop Down Lists (Coming Soon) |
| 0239 Excel Dirty Secrets.zip | Excel’s dirty little secrets – 5 things it does you don’t expect! (YouTube) |
| 0240 DOUBLEXLOOKUP.xlsx | DOUBLEXLOOKUP… the Excel function you’ve been waiting for! (YouTube) |
| 0241 Multi-column lookups.zip | Excel Multiple Column Lookups: Which Method is Best? (YouTube) |
| 0242 Function Library.zip | Supercharge Excel: Build Your Custom Function Library in Minutes! (YouTube) |
| 0245 Truth About Filter.zip | The TRUTH about Filter – Advanced filter techniques (YouTube) |
| 0246 Complete report with 1 formula.zip | Complete report in Excel with just ONE formula! (YouTube) |
| 0247 Dynamic total row.zip | Dynamic array total rows that move automatically? Watch this! (YouTube) |
| 0248 Conditional formatting formulas.zip | Excel Conditional Formatting Formulas – Format Like a Pro (YouTube) |
| 0249 Allow Edit Ranges.zip | Allow ONLY 1 person to edit a cell (YouTube) |
| 0250 Rolling totals with dynamic arrays.zip | The BEST Way to Calculate Moving Averages in Excel with Dynamic Arrays (YouTube) |
| 0251 Flexible Functions.zip | Using Flexible Functions in Excel (YouTube) |
| 0252 Budget vs Actual – GROUPBY & PIVOTBY.zip | Budget vs Actual with GROUPBY & PIVOTBY (YouTube) |
| 0253 GROUPBY with multiple tables.zip | GROUPBY with Multiple Tables in Excel – The Ultimate Guide! (YouTube) |
| 0254 Blank row between items.zip | Dynamically insert blank row between items in Excel (YouTube) |
| 0255 GROUPBY with dynamic breakdown.zip | GROUPBY in Excel with dynamic drill down (YouTube) |
| 0256 Period, YTD & Projection with GROUPBY.zip | How to calculate Period, YTD and Full Year Projection (YouTube) |
| 0257 Keep Blanks.zip | Stop Excel calculating blank cells as zero (YouTube) |
| 0258 TRIMRANGE + Trim Refs.zip | New Excel Function: TRIMRANGE (YouTube) |
| 0259 Sort Custom Order.zip | Custom Sorting with Excel formulas – Taking SORTBY to the next level! (YouTube) |
| 0260 PQ Transform Sample Sheet.zip | Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query (YouTube) |
| 0261 PQ Unstack Comparison.zip | The FASTEST Way to Unstack Data in Power Query – 3 Methods Compared (YouTube) |
| 0262 Automate Power Query with VBA.zip | Automate Power Query with VBA – Taking Power Query to the Next Level (YouTube) |
| 0263 Unpivot with formulas.zip | Unpivot with Formulas in Excel… No Power Query!! (YouTube) |
| 0264 Transform Sample Sheet.zip | Combine multiple sheets in Power Query with a Transform Sample Sheet (Blog) |
| 0264 SCAN function.zip | SCAN Solves Advanced Excel Problems in a Single Cell (YouTube) |
| 0265 Flexible Filter.zip | Excel’s Ultimate FILTER Hack (YouTube) |
| 0266 PQ Combine Files Different Names.zip | Power Query Trick: Combine Excel Files with DIFFERENT Sheet Names! 🔥 (YouTube) |
| 0267 Remove blanks.zip | The NEW way to remove blanks (YouTube) |
| 0268 PQ Remove Null Columns.zip | Power Query Trick: Instantly Remove All Null Columns! 💥 (YouTube) |
| 0269 Office Scripts – PDF & Email.zip | New Excel Features: Bulk send email & create PDFs directly in Excel (without VBA) (YouTube) |
| 0270 PERCENTOF in GROUPBY.zip | Don’t Use the PERCENTOF Function in Excel Until You Watch This! (YouTube) |
| 0271 Every of every combination.zip | All Combinations from Two Tables in Excel (YouTube) |
| 0272 Fill Down Replace Blanks.zip | The NEW way to fill down over blanks in Excel (YouTube) |
| 0274 LAMBDA made easy.zip | LAMBDA Explained in Simple Terms (YouTube) |
| 0275 List.Buffer.zip | List.Buffer: This One Power Query Function Will Speed Up Your Refresh (YouTube) |
| 0276 Zero Click Dream.zip | How I Made Excel Do My Work (Achieve the Zero Click Dream) (YouTube) |
| 0277 PQ Column Rename.zip | Avoid Power Query Failures: The Smart Way to Manage Column Names (YouTube) |
| 0279 PQ Stop Adding Unnecessary Steps.zip | Reduce Steps in Power Query – Tips Only the Pros Know! (YouTube) |
| 0280 Fastest Approximate Match.zip | Approximate Match in Power Query – The FASTEST Way Revealed! (YouTube) |
| 0281 GROUPBY Custom Heading.zip | The Excel team kept this SECRET… GROUPBY does more than we think! (YouTube) |
| 0282 Dynamic Slicer Reporting.zip | Excel Slicers WITHOUT PivotTables? The Disconnected Table Trick (YouTube) |
| 0283 GROUPBY Month Name Order.zip | Excel GROUPBY Month Sorting Problem Solved: Sort Months the Right Way (YouTube)
Coming 2nd October |
