Excel is great at formulas, but how do you enter a math equation in Excel? Today's podcast looks at an equation with Square Root, Exponents, Pi, and e that need to be entered in Excel.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Excel has always included a color chooser icon and dropdown for both fill color and font color. In the past, you could open the dropdown to choose a new color, or click the icon to use the previously selected color. Suddenly, you have a new Windows 8 laptop and the behaviour has changed - when you click the icon, it opens the dropdown and forced you to choose the last color again! It turns out that a new default setting on Windows 8 laptops is causing the problem. Learn how to go back to a normal 2-control color chooser.
Bill still has laryngitis, so @TomUrtis offers up a quick tip on how to get help on that Excel function you are entering.
You have a product category in A and then 6 products in B:G. The goal is to get 7 rows for each category, first with the category name, and then 6 rows concatenating the product name with the subproduct. This Dueling Excel podcast solves the problem with some VBA and with a formula.
Erin from California shows an unusual way to enter VLOOKUP in today's episode. At least, MrExcel thinks it is unusual. Have you ever seen anyone enter their VLOOKUP this way?
Center Across Selection is superior to Merge and Center in every way, but is there a keyboard shortcut to apply Center Across Selection? In this episode of the podcast, we visit the Cell Styles dropdown in Excel to see if it can shorten the keystrokes needed to apply Center Across Selection.
You have 100 sales leads in column A. You need to randomly assign those leads to 10 sales reps, but you want everyone to have the same number of leads. Bill works through two different methods in this episode.
Inviting all SoCal Excellers to an after-work meetup in Santa Monica California on Wednesday July 31, 2013. If you can't attend, virtually drop by with Twitter hastag #XLSoCal
Melika tweets that the colors used in the Cell Styles Dropdown in Excel 2013 have changed. What happened to the purple that used to be there? In Episode 1761, see how to quickly bring the Excel 2010 colors back. Easy to do, once you know where they hid the selection.
