An Excel Pro

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

Excel Shortcuts CELL ALIGNMENT (ALT H A+T,M,B,L,C,R) #excel #exceltips #excelshortcuts

Excel Shortcuts to ADD/REMOVE/SHOW/HIDE notes #excel #excelshortcuts

Pivot table - Filter Data Tricks - Right Click Filter #Excel #exceltips

Excel Shortcuts to GROUP DATA - ALT+SHIFT+RIGHT ARROW #excel #excelshortcuts

Pivot table - group ungroup date #Excel #excelhacks

Delete every other row - MOD(ROW(),2) #Excel #exceltips

How to hide the ribbon to save space - DOUBLE CLICK #Excel #exceltips

Excel Formula Return first day/last day of the month EOMONTH (DATE, MONTHS) #excel #excelformula

Excel Formula Calculate difference between dates =DATEDIF(START, END, "UNIT"), #excel #excelformula

Excel Shortcuts FLASH FILL ALT A F F or CTRL E #excel #excelhacks #exceltips

Excel Basic Ctrl Shortcuts TEST - CTRL C; CTRL X; CTRL V; CTRL D; CTRL R; CTRL Z; CTRL Y

Get YEAR, MONTH, DAY from A DATE =Year(), Month(), Text(Month()*29,"mmm"), Day() #excelformula

Return value of last non-empty cell LOOKUP #Shorts #Excel #excelformula

Zoom In and Zoom Out (10%-400%)? Shortcuts to zoom 100% ALT W J #Excel #shorts

CONCATENATE, & Operator, CHAR(10), CONCAT #Shorts #Excel #excelformula

Excel Formula Subtotal 9 vs. Subtotal 109 #Shorts #Excel #excelformula

Return the largest, second largest value - Large (Array, k) - Excel Formula #exceltips #shorts

Excel Basic Ctrl Shortcuts TEST | #excel #excelshortcuts

Can't name worksheet 'History" - Excel Fun Fact #Excel #shorts

Move to Cell A1 in a second - shortcuts CTRL HOME? #Excel #shorts

Formula doesn't work PART 1 - Check cell formats! #Shorts #Excel

Spot difference between data - Conditional Formatting - Duplication (ALT H L H D) #Excel #shorts

Quickest way to insert bullet points ALT 7 (Use Numeric Keypad for 7) #Excel #shorts #exceltips

Excel Shortcuts: clear contents DELETE; clear formats ALT H E F; clear both ALT E A A | #excel

Excel Shortcuts: get rid of a table (convert to range) ALT J T G | #shorts #excel

Excel Shortcuts: insert a table ALT N T or CTRL T #shorts #excel #excelshortcuts