MrExcel Excel Videos

Sher has data with text months such as Jan'20, Feb'20, and so on. How can you sort those months by date? Today, a trick from Sam Radakovitz using text months as a custom list and then sorting by a custom list.

New in Office Excel, Word, and PowerPoint. Right-click any object and choose Save As Picture. This feature seems so natural, it is hard to believe it has not been there for decades. Same SmartArt as a picture. Save a chart as a picture. Save Cutout Randy as a picture. Also in this episode, using a Linked Picture to be able to save part of the grid as a picture.

Sowmiya needs to highlight entire row with highest value with different data sets.. for eg coulmn A having id numbers , id 1 and 2 etc.. column b having lead count.. coloumn C having dates. Id1 taken lead count 6, 9 , 10 in different dates.. id number 2 having lead count 15 , 10 , 9 in different dates. I need to highlight unique highest values for each id. Output I need is to highlight the row id1 against lead count 10 and id 2 against 15 which is the highest value

Product Planner at YouTube asks: How can I automatically increase times in a column by 10 minutes each?

A question from Foxy on YouTube: What Excel formula will convert a date to the Week Number of the Month? It should never show more than a max of 5 weeks. Download the practice file: 2350_Practice_File.xlsx

Siva has a cell with comma delimited numbers. How can you add 500 to each number in the cell? In this episode of the Dueling Excel podcast, Bill uses a tiny VBA macro from Excel MVP Brad Yundt. Mike builds a killer formula using the LET function in Excel.

For my Excel friends, try out our new captions in 20 languages. For YouTube Creators, here is how we are creating captions. How does this compare to your method? We find that the Google Translate API works far better than the YouTube Automatic Subtitles. Both processes are owned by Google. Why doesn't YouTube use the better algorithm from Google?

Rob on Twitter asks: If I'm using a table, and one of the columns has a formula in it, is there a way to automatically include that formula when I insert a new row? In episode 2349, I show two different ways that this *should be* working and a couple of things that could cause it to break.

Just like the Guess Your Age booth at the Carnival, Excel can guess your age from your given name. In episode 2348, we will take a look at the Wolfram Alpha data types for Given Name, Fictional Character, Amusement Parks, Notable Texts, and Authors.