| Videos with tag Excel | All | Novice | Advanced | Expert |
Learn Excel Episode 1049: Tracing Error
You have a large formula which is generating an error. To find which reference in the formula is causing the problem, use the Evaluate Formula tool to step through the formula. Episode 1049 will sh... read more »
| Level: any | Jul 03, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1048: Shift-Tab
Episode 1048 will show you a cool way to speed data entry using a combination of the tab and enter keys. While I have discussed this before on the podcast, using shift-tab makes the trick a bit coo... read more »
| Level: any | Jul 02, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1047: Rounding Co...
After yesterday’s podcast about ASTM E29 rounding, I produce a function in VBA that will correctly do the bankers rounding algorithm in Excel. Episode 1047 shows you how. read more »
| Level: any | Jul 01, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1046: ASTM E29 Ro...
If you have to round 0.5, do you think it should round to 0 or 1? I bet that you learned in school that it should round to 1. However, this will introduce errors. Episode 1046 talks about the error... read more »
| Level: any | Jun 29, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1045: Dueling: Pe...
Izhak asks how to add a scrollbar to a worksheet for selecting a percentage. In this dueling Excel podcast Episode 1045, Bill and Mike will show you two ways to solve the problem. read more »
| Level: any | Jun 27, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1044: Multi-Colum...
Isabel asks how to use Ctrl+F to find a row where three criteria are true. Rather than use Ctrl+F, Episode 1044 suggests using a Filter. read more »
| Level: any | Jun 26, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1043: Parsing Var...
Dawn's file has name in A and address in B. Except: the address field in column B contains the name again. Episode 1043 shows how to parse the variable-length name out from column B. read more »
| Level: any | Jun 25, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1042: Indian Pay ...
Another question from Gopal. New India Pay Commission guidelines suggests that pay should be rounded to increments of 10. If the amount over the last 10 is less than or equal to 0.99, then round do... read more »
| Level: any | Jun 23, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1041: Future IF
Mario has built a great nested IF formula for assigning points to soccer games. However, the formula is calculating 1 point for both teams for all unplayed games. In Episode 1041, I take a look at ... read more »
| Level: any | Jun 23, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1040: Dueling: Fr...
In this dueling Excel podcast, Bill and Mike look at ways to do a frequency distribution. Episode 1040 shows you how. read more »
| Level: any | Jun 20, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |

Recent Videos RSS

Add to Favorites
