Someone in another department set up a spreadsheet with 100’s of time values. Instead of using Excel time formats, they entered each cell as text with …
Continue ReadingProblem: You need to order pizza for the department staff meeting. The pizza joint has two deals. You can buy three Medium (12”) pizzas for $15 or two …
Continue ReadingThe IRS allows a reasonable number of deductions for expenses associated with maintaining a home office. Learn about which deductions are allowed and …
Continue ReadingBunco is a quick, fun dice game that is very popular in certain circles. In this guide, Mr. Excel shows how easy it is to create a Bunco game in …
Continue ReadingProblem: In the previous example, you used the RANK function to find the relative rank order of four writers, as shown in Fig. 377. Now you want to …
Continue ReadingWith just a few quick steps, you can easily create a dice roller in Excel. This tool can be used in conjunction with other games, or you can even use …
Continue ReadingExcel is great at making calculations but sometimes you only need to keep the results of a formula and erase the columns upon which the calculations …
Continue ReadingThinking about making a major purchase, but not sure if you can afford the monthly payment? Mr. Excel shows how to calculate a loan payment in Excel, …
Continue ReadingDid you know you can set up a simulator and play craps in Excel? Follow these simple steps and you can be throwing virtual dice … and look like …
Continue ReadingProblem: Instead of random numbers, you need to create random letters.
Continue ReadingLearn how to use Excel’s RAND function to generate random numbers.
Continue ReadingProblem: You have a field that may contain numbers or text. You need the numeric entries to sort with the text entries. Instead, Excel always sorts …
Continue Reading