formula

Episode 370 – AutoShape Formulas

               

Rather than static text in the AutoShape, use a formula to add dynamic text to an AutoShape. Episode 370 shows you how to create a shape that shows off the total of all sales made today. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute(…)

Episode 348 – Max or If

               

Calculate Sales over Quota using either the IF or MAX functions. Episode 348 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 160 – Get characters after the Dash

               

Yesterday’s podcast showed how to use LEFT and FIND to get all of the characters before a dash. What if you need all of the characters after the Dash? There are a couple of options. The first option discussed in the episode is to combined MID, FIND, and LEN to get the characters. Alternatively, you(…)

Learn Excel from MrExcel