Goldnfiber | Apparel Merchandising Blog

Largest collection of Apparel Merchandising, Fashion Merchandising Notes, Tutorials, Tips, Experiences, Resources, Books, Jobs and Others

Techniques

Use spreadsheet and become smarter in report making!

Report making is one of the important tasks for office executives or managers. Top management always desires clear report with a pivot table and graph chart from the subordinate so that they could understand the real situation by watching the report at a glance. He who wish to complete their report clearly and quickly to present high officials, they should have sound knowledge of spreadsheets like MS Excel, Google Doc or Open office for making various reports. If you can learn report making task perfectly, it will help you to manage your daily job more efficiently than your other colleagues. It is one of the regular functions for most of the garment officials in the garment’s industry. Not only garment officials but also other officials have to prepare report in their profession. In my practical experience, I have seen that expertise on MS Excel is a perfect tool to focus your report. Well formulated reports are easy to understand to all to take quick decision.

pivot table
If you are asked to compile summarized report regarding daily production output (DPO) of a manufacturing company where you have to show line wise, buyer wise, style wise, day wise, month wise output and diagnosis profit or loss in a diverse format, it would be a rough and time killing assignment. If management urges you to do such task, I realize that it is one kind of mental torture upon you. So, how could you get rid of this hassle and swift your daily task?
Got expertise on the spreadsheet may help you to prepare various kinds of reports. There are numerous features in a spreadsheet like pivot table, vlookup, filter, macros, graph chart and thousands of useful shortcut keys assist you to manage your task swiftly.
In this article, I am not going to teach you spreadsheet but just let you know the tremendous features exist in this software that is very helpful to prepare business or official reports. You can accrue it by reading attach file (Excel manual) and continuous practice. I will show an example that I use for making daily production output. Pivot table is a useful feature to make a meaningful report, and it is not very difficult. But many of us do not know how to use pivot table.
Please download a pivot table chart from attaching link where I have shown you how to make a pivot table clearly. Dropbox link: https://dl.dropboxusercontent.com/u/93939424/GF/Excel%20Intermediate%20level%20exercise%20file.xlsx
I have also attached another drop box link where exists a manual on spreadsheet to learn excel perfectly: https://dl.dropboxusercontent.com/u/93939424/GF/Excel%20Manuals%20for%20Practice.zip
I have also attached another drop box link where exists an Intermediate level exercise file on spreadsheet to learn excel perfectly: https://dl.dropboxusercontent.com/u/93939424/GF/XYZ-Daily%20output%20report%20as%20on%2020150228.xlsx
Please download the attach file and practice as much as to enhance your skill. Please note without regular practice you cannot improve your efficiency.

Leave a Reply

Theme by Anders Norén