| Videos with tag Excel | All | Novice | Advanced | Expert |
Learn Excel Episode 1133: ADM Calcula...
Patricia called the other day with a problem which will be familiar to everyone who works in a public school district. The state pays the school for every student who is enrolled on the magic date ... read more »
| Level: any | Oct 30, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1132: Filling Qua...
The Excel fill handle is really cool with quarters. But wait....it can not do quarters and years. But wait...it can do them but in a hideous format. Episode 1132 asks - "Does anyone have a better w... read more »
| Level: any | Oct 28, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1131: Increase Ch...
Roger from Columbus Indiana passes along a cool trick for formatting all of the text in a chart at once. Episode 1131 shows you how. read more »
| Level: any | Oct 27, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1130: Sorta Indirect
Greg wants to set up dynamic validation, but he has a wrinkle....Once someone chooses from the first data set, he needs to append the word My before that answer to get to the name of the second dat... read more »
| Level: any | Oct 27, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1129: First Week ...
A dueling podcast...how to find the first week of the month. Mike and Bill show you various ways in Episode 1129. read more »
| Level: any | Oct 24, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1128: Love GetPiv...
The last in my series of podcasts about GetPivotData. Today, we see how to use GetPivotData to overcome all the bad stuff in a pivot table. Episode 1128 shows you how. read more »
| Level: any | Oct 22, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1127: Understand ...
Rather than turn off the evil GetPivotData like we did yesterday, how about trying to understand what GetPivotData actually does? Episode 1127 shows you how. read more »
| Level: any | Oct 21, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1126: Hate GetPiv...
99% of the people in my seminars hate GetPivotData. Most people outside of Microsoft hate GetPivotData. Today, in Episode 1126, as we've done before, we will take a look at how to turn off GetPivot... read more »
| Level: any | Oct 21, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1125: HLOOKUP Week!?
Don't use HLOOKUP...just turn the table back to a vertical table using the two methods shown in Episode 1125. read more »
| Level: any | Oct 20, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |
Learn Excel Episode 1124: Duel: 2-Way...
Mike & Bill take a look at various ways to do a 2-way lookup in this dueling Excel Episode 1124. read more »
| Level: any | Oct 16, 2009 | Votes: 0 | Dmytro Shteflyuk ![]() |
0 ![]() |

Recent Videos RSS

Add to Favorites
