Register Blogs Advertise with usHelp Desk Today's Posts Search

Unread

How To Get Rid of Boring Comments in Excel Reports

Posted 8th April 2012 at 09:26 AM by ddalgleish

If you're sending out Excel statements to your affiliates, you can add comments to explain some of the details.



But don't limit yourself to those boring yellow rectangles. To really catch people's attention, you can change the comment shape and color.



How to Change...
ddalgleish's Avatar
Excel Expert
Posted in Uncategorized
Views 892 Comments 0 Go to first new comment ddalgleish is offline
Unread

Prevent Data Entry Errors in Excel

Posted 1st April 2012 at 11:44 AM by ddalgleish

When you're running a business, Excel is a great tool to keep track of sales and expenses.

However, if you're entering lots of data into a worksheet, it's easy to make a typing mistake, or put information into the wrong cell.

To help prevent data entry errors, you can create drop down lists in the Excel sheet. These are made with the data validation feature.



Then, if you or your assistant are...
ddalgleish's Avatar
Excel Expert
Views 589 Comments 0 Go to first new comment ddalgleish is offline
Unread

Get Product Prices From a Lookup Table

Posted 26th March 2012 at 05:07 PM by ddalgleish

If you're keeping track of your online product sales in Excel, you can use the built-in features to make the data entry easier.

For example, on one worksheet, you can store a table with your product names, and the product prices.



Use a Formula to Find the Price

In another sheet, enter the name of the product that you just sold. Then, use Excel's VLOOKUP function...
ddalgleish's Avatar
Excel Expert
Views 688 Comments 0 Go to first new comment ddalgleish is offline
Unread

Make an Excel List Easier to Read

Posted 17th March 2012 at 12:33 PM by ddalgleish

If you're selling items online, you can usually export the sales date, and open the exported file in Excel.

Hopefully your list of sales will be very long! That's good for your bank account, but a long list can be hard to read on the computer screen.

To make the list easier to read, you can do two things:

  1. Create an Excel table, and use the built-in styles, to add bands of color
  2. Add lines to separate the dates, to quickly show where the sales dates start
...
ddalgleish's Avatar
Excel Expert
Views 575 Comments 0 Go to first new comment ddalgleish is offline


All times are GMT -6. The time now is 01:30 PM.