What kind of reporting executives prefer? One that can fit on a single page! And to be timely, clear, beautiful and above all accurate – that goes without saying! Reporting table usually consist of tables, charts, or a combination of these elements with help of several important filters. Excel allows you to easily create beautiful and functional dashboards. This way it can replace or at least to postpone the purchase of expensive specialized software.
ABC analysis is a method used for analysis and management of inventory. Depending on the share in the total value of the stock it distributes items in groups A, B or C. They make up about 70%, about 25% and about 5% of the total, respectively. Since items from Group A account for the largest share of the total value they require frequent and rigorous control. Items from the group B require something smaller, while items from the group C require the least control.
There are several ways to create Excel calendar. Also there are multiple templates that you can use for that purpose. The goal of this „recipe“ is helping you to understand practical application of some important date&time functions, and creating a calendar is an ideal opportunity to do so. When you learn how to generate dates and positions they should fit in you can use calendar for planning activities or tracking project realization.
Working in large companies, especially multinational corporations, often involves periodically sending the standardized Excel reports that are intended to provide management with information about the business. These are usually consolidated balance sheets and other reports that display key performance indicators, and the employees who should fill them have a task to enter data into ready-made templates.
Inventory is necessary but always dull (whatever kind of inventory you do). Since some time ago and I was a member of the Inventory Commission, this experience has served as an inspiration to write an article about a good way of using collaboration tools in Excel (Shared tables) to facilitate inventory process. This is also a good way to use Windows tablets that your company have bought. Most of the time they are only used for show off, and now they could have a real purpose.