Channel Avatar

ExcelMoments @[email protected]

6.2K subscribers - no pronouns :c

A place for all levels of Microsoft Excel users to brush up

Videos Shorts Posts Playlists
Extract All dates (dd-mmm-yy) from a string /paragraph with REGEX Sort data first by Month and then Year #shorts ALT+Function keys shortcuts in Excel #shorts GROUPBY with PERCENTOF Function (% sales per person) #ahorts Wildcard Match - what column contains an "@" #shorts Find Previous using "FIND" dialog in Excel #shorts Enter Key+Shift/CTRL behaviour in excel #shorts Optional Arguments in Excel Lambda #shorts Using Wildcards to Filter in Excel #shorts Extract Data from Picture/Image-Excel #shorts Filter Data in Excel Trick- NO MOUSE #shorts Shorter running totals with SCAN in Excel #shorts Formatting hours above 24 in Excel #shorts GROUPBY images in PIVOT TABLE Excel #shorts GROUPBY Function with Images in Excel #shorts Adjusting Min and Max dates for Excel Chart Axis #shorts Random Dates using RANDBETWEEN in Excel #shorts Waterfall Charts in Excel - Fix Totals Excel Intersection Operator for 2-way Lookup Sum and Ignore errors in Excel #shorts Excel 2-way Lookup with nested XLOOKUP #shorts GROUPBY function-dynamic subtotals in excel #shorts Return to location after hyperlink click #shorts Dense Rank - Rank with duplicates, no skips in Excel #shorts SUM TILL SELECTED ITEM+XLOOKUP #shorts Stop hyperlinks changing colour when clicked Excel #shorts TEXTSPLIT with Multiple delimiters Excel #shorts Filter the Top N Students/Scores Excel #shorts WRAPROWS Function-Quickly convert 1 column to multiple in Excel #shorts Hyperlink to a named macro in VBE #shorts Hyperlink Function to link Sheets (# symbol magic) #shorts Custom format Data Labels #shorts Formula for Nth day of the year #shorts Text Function Multiple formats #shorts Reverse/Flip an excel range -Excel Formula #Shorts Reverse strings/list in Python Excel #shorts FIELDVALUE function -Dynamic array Data types #shorts Get the nth Name from multiple names #shorts Get the NTH working day of the year Excel #shorts Excel Xlookup to return first and last instance-one formula #shorts MROUND and RANDBETWEEN for "relatable" numbers - Excel #shorts Get first n items from range - TAKE Function #Shorts Get first and last name in Excel-one formula #shorts Concatenate with ARRAYTOTEXT Excel Function | #shorts EOMONTH array formula - workaround last word in a cell Excel -Multiple Delimiters #Shorts unique no blanks Excel #shorts count how many times a character appears in a string excel #shorts
Next Page