# Software Tips & Reviews

• #### Microsoft Excel: Protect Cells With Formulas

Problem: You have to key-in data in a large number of cells in a month end financial statement, as shown in Fig. 608. You don’t want to accidentally key-in a number in a cell with a formula. How can you protect just the formula cells?
By  July 6, 2011

• #### Microsoft Excel: Match Customers Using VLookup

Problem: You have a list of month-to-date sales by customer. You have a second list with new sales from today, as shown in Fig. 554. How can you add the sales from the new list to the old list?
By  July 6, 2011

• #### Microsoft Excel: Make Any Logo Into an Autoshape

Turn your business logo into an Excel AutoShape with these easy steps.
By  July 6, 2011

Problem: You have figured out a particularly confusing formula in Excel, as shown in Fig. 1146. You want to add a note to the worksheet to remind yourself how the formula works.
By  July 6, 2011

• #### Microsoft Excel: Learn To Use Boolean Logic Facts To Simplify Logic

Problem: If you have to enter multiple IF conditions, having a good understanding of logical operators will help you to simplify the formula.
By  July 6, 2011

• #### Microsoft Excel: Join Two Autoshapes

In Excel, you can group AutoShapes to make it easier to move them to a new location.
By  July 6, 2011

• #### Microsoft Excel: How To Minimize Overlap Of Pie Chart Labels

Problem: On a three-dimensional pie chart with several small pie slices, the labels for the smaller pie slices will often overwrite each other, as shown in Fig. 1089. Improve the look of the chart.
By  July 6, 2011

• #### Microsoft Excel: How To Calculate Sales Over Quota

Problem: In the spreadsheet shown in Fig. 253, enter a formula to calculate the excess of sales over quota on a record-by-record basis.
By  July 6, 2011

• #### Microsoft Excel: Group Dates By Months

Your 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 month, it’s still the 5th of the month. You can see by looking at the cell‘s formula...
By  July 6, 2011

• #### Microsoft Excel: Force Certain Comments To Be Always Visible To Provide A Help System To Users Of Your Spreadsheet

Problem: You are sending out a worksheet to managers and division vice presidents in order to get their budget for next year. You need to include specific instructions for many of the cells in the worksheet.
By  July 6, 2011
showing 41-50 of 198    < Previous  |  page: 3 4 5 6 7 ...  |  Next >