August 9th, 2009 Arthur
Are you struggling to organize your wedding with stacks of folders and notebooks stuffed with pricing sheets and handwritten guest lists? Step out of the dark ages and into modern wedding planning. This easy-to-use Excel spreadsheet tutorial will teach you how to make your wedding planning efficient, organized, and most importantly, stress free.
The first step […]
June 20th, 2008 Arthur
= VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Let’s say you sell books for a living. You want to keep an inventory of books you are selling, and you charge different amounts based on the type of book; whether the book is paperback, hard cover, or a best seller. You charge $10 for a paperback book, $25 for a […]
June 3rd, 2008 Arthur
So let’s say you have a several columns of data and create a new column that has a forumla. And you want that new forumla to carry through the entire series in a column like this:
Now typically this is not a problem is you are just trying to copy C5 to a few rows but […]
March 15th, 2008 Arthur
Having difficulty unhiding the top most rows or the left most columns? Here is a simple way of doing is without remembering shortcuts. Here is a simple example.
You first need to make sure that you can see the rows and columns. Goto Tools>Options>View Tab and then make sure there is a check mark […]