Inventory Freight Calculation

April 30, 2009

To account for freight on incoming inventory, I allocate the freight charges proportionately over the inventory items by total value. Quickbooks doesn’t have a way to handle that, so I use a simple Excel spreadsheet to do the calculation.

The last entry is always the freight (or handling or whatever I want to distribute). I don’t [...]

0

Excel Formating Tips: Gridlines And Borders

April 29, 2009

This is probably the easiest way to highlight the active cell and it requires no VBA or even conditional formatting.
Look at this picture,
And this one,
And this one.
See the difference? By changing the borders, the active cell becomes surrounded by color. In fact, if you use double lines or [...]

0

Blogging In terms of Search Engine Optimization

April 11, 2009

In recent years, weblogs have grown from a band of sharp-tongued outlaws to the darlings of online marketing. From Stonyfield Farm Yogurt to the Republican National Committee, it seems that everyone has a blog, or two, these days. Whether you are an individual out to bring in an income through running ads on your site [...]

1