#Aprilfools

TRIMRANGE & A4.:.A8 in Excel to exclude future rows

Multi select dropdown lists in Google Sheets & unpivot for analysis

Excel vs Google Sheets Podcast with the FP&A guy

Dimension & measure slicers in Power BI with field parameters

Enabling Power BI map visuals

Podcast: Why Excel will never die & tax tech

=TRANSLATE function in Excel

Filter and highlight based on list

Get Word data pasting properly! #Word #Productivity #paste #microsoftword

Auto subtotals in #excel #exceltips #exceltutorial

Check out Excel’s NEW checkboxes!

Join text in Excel, without CONCATENATE

Budget vs actuals chart in Excel with variance

Structured tables for Google Sheets

Fix cASiNg extra spaces & similar text NEW in #Excel online

REGEX in Excel and Google Sheets to fix messy text

Pivot Tables in Google Sheets. Novice to expert tips

VLOOKUP sucks: Excel non matches, duplicates, fuzzy match ++

Compare lists in Excel: 6 ways to find differences

#Excel’s Hide feature sucks, instead Group & line up + icons with this trick #exceltips #exceltricks

Reference a cell in Power Query for Excel or a parameter for Power BI

#Aprilfools #pranks in #Excel #exceltricks

Sum super fast in #Excel with alt = on multiple cells #excelformula #exceltips

CROSSJOIN to combine tables with all combinations for #Excel using #PowerQuery #PowerBI