Pivot table - Filter Data Tricks - Right Click Filter

A job interview question on Excel #excel #excelinterview

Copy paste visible cells only F5 vs. Alt ; #excel #exceltips

Calculate total when text and numbers are in one cell #excel #exceltips

Randomly select from a list for me - RANDBETWEEN 😁 #excel #excelformula #exceltips

Translate Function - become a multilingual person😁 #excel #excelfunctions

Excel Stacked Column Chart 🤓 #excel #excelgraphs #shorts

Sort horizontally - sort from left to right 😆#excel #exceltips

xLookup for tax rates calculation #excel #excelfunctions #excelformula

DSUM formula - calculate total match multiple criteria #excel #excelfunctions #excelformula

Challenge: enter weekday dates for the year - shortcut ALT H F I S #excel #exceltips

Running Total - from MTD to YTD #excel #excelfunctions #exceltips

Roman Formula #excel #excelfunctions

Power Query unpivot columns #excel #excelpowerquery

Shortcuts ALT H 6, ALT H 5, and remove multiple levels of indent #excel #exceltricks

Is my Excel calculation or formula gone wrong? #excel

SUM formula #excel #excelfunctions

Custom Lists - Sort month from Jul to Jun #excel #exceltips

Shortcut test #excel #excelshortcuts

Excel Convert Function - From a unit to a unit #excel #excelfunctions

Excel Remove All Spaces #excel

Fill a series of numbers in merged cells #Excel

Excel Headings gone missing!

Delete OBJECTS in one go - F5, ALT S, B, ENTER, DELETE #Excel #exceltips

Fill Down, Fill Up (F5, CTRL+ENTER) #Excel #exceltips