Problem: If you have to enter multiple IF conditions, having a good understanding of logical operators will help you to simplify the formula.
Continue ReadingWhen you’re ready to let go of broken or unwanted printers, black and white Web cams, digital cameras, and old computers, don’t just toss them in the …
Continue ReadingYour data has invoice dates and need to group the data by month. You’ve learned how to make a date look like a month. When you make a date look like a …
Continue ReadingProblem: Your dataset shows the actual date for each invoice, as shown in Fig. 540. You want a formula to convert this to the last day of the month.
Continue ReadingThe Ultimate resource for Excel calculations. Taken from the fabulous book “Learn Excel from Mr Excel” - written by Bill Jelen, this table …
Continue ReadingProblem: You have a report of revenue by customer, sorted in descending order, shown in Fig. 428. Management will often argue that you should …
Continue ReadingYou entered the results of a running challenge for the students in your class. The results are from 2 min. 35 sec. to 3 min. and 15 sec. Totaling the …
Continue ReadingProblem: You change a cell in Excel but the formulas do not calculate. As shown in Fig. 468, cell D2 indicates that two plus two is not four.
Continue ReadingProblem: In what order does Excel perform calculations? Is 2+3*4 equal to 20 or 14?
Continue ReadingWant to know how a formula is being calculated every step of the way? The tools in Excel’s Formula Auditing group can help.
Continue ReadingEven though there may not be a predefined function in Excel that allows to calculate a growth rate, we can still use the application to solve these …
Continue ReadingOutlook 2007 adds the ability to consume RSS feed content. This article shows how to add and manage RSS feeds in Outlook 2007
Continue Reading