MrExcel Excel Videos

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.

The CONVERT function isn't working with arrays. But the easy solution: Add a unary PLUS sign before the array reference.

Sanjeev needs a function like NETWORKHOURS() but there is no such function in Excel. Bill Jelen from MrExcel and Mike Girvin from ExcelisFun try different approaches for solving the problem.

When Data Types first debuted in Excel, the most-requested additions were Exchange Rates and Weather. Well, Wolfram Alpha didn't mention weather, but there is Weather History for many locations in the new data types.