I love making complex spreadsheets for my clients. My favorite spreadsheet is the Order Sheet I made for my client that has a factory. Instead of hand writing data and adding the numbers manually. I designed a individual Ordersheet for each order that comes in and all the Order Taker has to do is place the amount in the right spaces. The individual orders appears in the Dailysheet where all the orders show minus the inventory count (which is manual typed in at the beginning of the week). The numbers are carried forward to the next day. There is also a space for the Supervisor to compare the actual stock to the stock written. At the end of the week all the Dailysheets are shown in the Weeklysheet and than so on to the Monthlysheet. This speadsheet gives my client a more accurate count of their inventory and saves Ordertaker time and energy.
My favorite Excel functions are Condition Formating, Find & Replace and Sort and Filter.
Some information below:
Conditional Formating: http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel
Find & Replace: http://support.microsoft.com/kb/288291
Sort and Filter: http://office.microsoft.com/en-us/excel-help/CH010064845.aspx
If you are having any trouble with Excel feel free to email me at karima@urbanadmininc.com.
No comments:
Post a Comment