My Popular Articles
- Microsoft Excel: Play Craps With Excel
- Microsoft Excel: Calculate a Growth Rate
- Microsoft Excel: Measure the Accuracy of a Sales Forecast
- Microsoft Excel: Add A Tooltip To A Cell
- Microsoft Excel: Draw an Arrow to Visually Illustrate That Two Cells Are Connected
- Microsoft Excel: Figure Out Lottery Probability
- Microsoft Excel: Copy a Formula While Keeping One Reference Fixed
- Microsoft Excel: Create a Multiplication Table
- Microsoft Excel: Calculate a Sales Commission
- Microsoft Excel: Add a Pop-Up Picture of an Item in a Cell
MEMBER PROFILE
-
Track Your Goals with Excel
In his book, Success Made Easy, retail guru Ron Martin suggests using a daily chart to track your progress towards a goal. His chart shows progress towards the goal as well as where you need to be to remain on track. In the image, the straight line is...Published on July 6, 2011 to Home Office
-
Microsoft Excel: You Change A Cell In Excel But The Forumlas Do Not Calculate
Problem: 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.Published on July 6, 2011 to Home Office
-
Microsoft Excel: Watch For Duplicates When Using VLookup
Problem: In previous chapters, you’ve used the VLOOKUP function to get sales from a second list into an original list. You need to be aware of how VLOOKUP handles duplicates in the lookup list.Published on July 6, 2011 to Home Office
-
Microsoft Excel: Use White Color for Fonts to Hide Data
Want to hide some of the data on your Excel spreadsheet to make it more visually appealing? Try this easy trick.Published on July 6, 2011 to Home Office
-
Microsoft Excel: Use Validation To Create Dependent Lists
Problem: You want to create two dropdown lists. The second list should be dependent on what is selected in the first cell.Published on July 6, 2011 to Home Office
-
Microsoft Excel: Use The Border Tab In The Format Cells Dialog
Problem: Borders drive you insane. How do you actually use the Border tab of the Format Cells toolbar, shown in Fig. 1289?Published on July 6, 2011 to Home Office
-
Microsoft Excel: Use Parentheses To Control Order Of Calculations
Problem: In what order does Excel perform calculations? Is 2+3*4 equal to 20 or 14?Published on July 6, 2011 to Home Office
-
Microsoft Excel: Use MapPoint to Plot Data on a Map
Microsoft MapPoint is an extra program you can buy from Microsoft. There's a North American and a European version. At $299 list price, it is pricey. You also might be able to pick up a copy on eBay for less than the list price. MapPoint allows...Published on July 6, 2011 to Home Office
-
Microsoft Excel: Turn Off Wrap Text in Pasted Data
Tired of cells not wrapping the way you want in Excel? Read on to learn a few tricks to fix this problem.Published on July 6, 2011 to Home Office
-
Microsoft Excel: Total Without Using a Formula
Need to quickly and easily sum up a total in Excel? With this trick, you don't even need to enter a formula.Published on July 6, 2011 to Home Office