Software Tips & Reviews

• 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...
By  July 6, 2011

• 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.
By  July 6, 2011

• 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.
By  July 6, 2011

• 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.
By  July 6, 2011

• 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.
By  July 6, 2011

• 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?
By  July 6, 2011

• 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?
By  July 6, 2011

• 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...
By  July 6, 2011

• 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.
By  July 6, 2011

• 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.
By  July 6, 2011
showing 21-30 of 198 < Previous   |   page: 1   2   3   4   5  ...   |   Next >