3 Steps to Create cool dashboards in excel. Posted on September 5th, 2006 in Analytics , Learn Excel - 12 comments Dashboards are very common business monitoring tools, but creating them in excel with all the bells and whistles is not so easy. So here is a quick 1-2-3 on how to do it. Lets take a sample of 2 consecutive year sales figures for 7 regions. The colums have Region name, 2004-05, 2005-06 figures and finally YoY Growth percentages.
The lame dashboard should look something like this: But may be we can make it little better. What are the things that are going up / down / remaining constantThe chart should look simple and not cluttered; meaning, there cant be multiple columns to present information. So, a cool dashboard would look something like the below one: Well, how to get it in 3 steps? Type the following formula in the cell F5 and drag it to apply to all the cells [Click on the image to see bigger version of the formula]Select the range F5:F11, goto Format->Conditional Formatting and enter the following values there: KPI (Key Performance Indicator) Dashboards in Excel - Tutorial [Part 1 of 6] Posted on August 20th, 2008 in All Time Hits , Charts and Graphs , Featured , Learn Excel - 212 comments Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert.
This 6 Part Tutorial on KPI Dashboards Teaches YOU: Creating a Scrollable List View in Dashboard Add Ability to Sort on Any KPI to the Dashboard Highlight KPIs Based on Percentile Add Microcharts to KPI Dashboards Compare 2 KPIs in the Dashboards Using Form Controls Show the Distribution of a KPI using Box Plots Dashboards have become quite popular in the last few years and in spite of all the Business Intelligence software products that provide dashboards, a lot of dashboards are still implemented with Microsoft Excel. What is a Dashboard? According to Stephen Few, one of the world-wide leading authorities on visualization and dashboard design, a dashboard is a visual display of the most important information […] which fits entirely on a single computer screen […] (Information Dashboard Design, 2006) The solution.
Faster Cheaper Better: The 9 Levers for Transforming How Work Gets Done: Amazon.ca: Michael Hammer, Lisa Hershman. New Manager Mistakes. Managing can be a little difficult at first. A recent poll found that more than 50% of managers received NO training before starting the job. Here is a list of the most common mistakes new managers make so you can avoid making them too. (If you think I missed one, use the "Readers Respond" link at the bottom to add a new one.) 1. Yellow Dog Productions/The Image Bank/Getty Images If you were just promoted to Production Manager, you may feel you know everything about production. 2. Trust me, everyone in your group knows who the new manager is. 3. Don't re-invent the wheel. 4. Maybe you didn't ask for the promotion. 5. Maybe you worked alongside these people for years. 6.
Since he/she just promoted you, surely he/she understands how busy you are and won't need any of your time, right? 7. You can no longer avoid problems or hope they will work themselves out. 8. 9. The people in your group will be under pressure from every direction. 10. The Worst New-Manager Mistakes | BNET. Last Updated Mar 17, 2010 2:20 PM EDT If the mistakes you've made as a rookie manager make you cringe, you're not alone. Many people struggle with the transition to overseeing their colleagues — and they usually don't get much help from their employers.
Last year the Institute for Corporate Productivity surveyed hundreds of employees to determine how well their companies helped people make the switch to management. The results were dismal: More than 60 percent rated their firm's performance as "fair;" 16 percent said it was "poor. " So that leaves managers to learn from their mistakes, which is, of course, often the best way to improve. My mistake: I let an employee intimidate me.
When I first started managing in 1994, I oversaw a salesperson who was old enough to be my mom. Now if I have a problem like that, I take immediate corrective action, instead of losing sleep over it. . — Anne Brush Zimos, 43, manager of a design services team at IBM in Armonk, N.Y. More advice for new managers: New Managers: How to Survive Office Politics | BNET. Showing your bosses that you're ready to take on new projects isn't just a matter of stellar performance or demonstrating initiative — though these things certainly help. You also need to prove to the top brass that they can trust you in subtler ways. Many new managers over-explain to direct reports why they must take on a particular task and in doing so, pass along information from their bosses that was better kept confidential. To establish trust with your supervisor, err on the side of keeping your conversations quiet and, when in doubt, ask if the content is for general consumption.
"You'll be on the hook for sharing that information," says Ceniza-Levine. You'll also gain points by acknowledging that your bosses are privy to certain information that you don't have. Even with solid backing from the top, you won't be able to get anything done if your team isn't behind you. Voice of Experience My mistake: 'I hid in my office' Additional writing by Adriana Gardella. Valve Bag Filler. Since we began, we have been committed to providing superior customer support to our client base worldwide. Our aftermarket parts department is an integral part of that ongoing commitment. Our overriding goal is to keep our customers operations running smoothly and profitable. We have developed an extensive on-line library of illustrated parts pages as an interactive tool between you and our customer service department to quickly, accurately and easily identify the part or parts you are looking for even if you don’t know the part number you are looking for.
The Choice Approach to Parts Support - AKA How we earn it Our commitment to you is four fold: we will be ready and waiting to serve you when you call on us, we will have on-line tools available to quickly and accurately help identify the parts you need, we will deliver them to you in a timely manner acceptable to you and provide an unparalleled level of technical knowledge you won’t find anywhere else. Where-not-to-buy-airline-tickets: Personal Finance News from Yahoo! Finance. Shoppers looking for the cheapest airfare can learn something from stand-up comedians: It's all about timing. Ticket prices are highest on weekends, on average, according to online travel agencies, fare trackers and airline pricing executives. When's the best time to buy? Travel experts have long said Tuesday is when sales are most often in place, which is true. An analysis of domestic fares shows that Wednesday also has good -- and occasionally better -- ticket prices.
Though prices fluctuate frequently and the ups and downs of airline prices can frustrate and anger consumers, airline pricing actually does follow a cycle during the week. Two weeks ago, a Chicago-Atlanta round-trip ticket for April travel dates cost $209 on Tuesday and Wednesday on American and Delta, but then $301 for the next four days. [More from WSJ.com: Top U.S. "Like bread, fares get sort of stale toward the end of the week," said Bob Harrell, a fare consultant who has tracked airline pricing for years. Consignment Inventory: What is it and When Does It Make Sense to Use It. By Dave Piasecki © Copyright. Content on InventoryOps.com is copyright-protected and is not available for republication.
Let’s start with a simple definition: Consignment Inventory is inventory that is in the possession of the customer, but is still owned by the supplier. In other words, the supplier places some of his inventory in his customer’s possession (in their store or warehouse) and allows them to sell or consume directly from his stock. The key benefit to the customer should be obvious; he does not have to tie up his capital in inventory. Where Consignment Works Best. A supplier has a product or group of products that he believes will sell if he can get them in front of end-users. For a more specific example, consider a bicycle manufacturer that produces a wide range of bicycles ranging in price from a couple hundred dollars to several thousand dollars. I consider this the classic consignment model because it is the best-case scenario for applying the consignment inventory model. David Seah | Design, Development, Productivity, Empowerment, Inspiration.