www.getreporthelp.com
A good chart can “land” you the client, separate you from other vendors, or make your message to management extremely persuasive. This VIDEO shows you EXACTLY how to create good Microsoft Excel charts. Here is part 1 of a 3 part series on how to create compelling charts in Excel.
When you have to present Excel data, the last thing you should do is take a screen shot of the data and make it into a PowerPoint slide. The chart should tell a story that can be understood in 5 – 10 seconds. If you take longer than that, your audience will ignore you and focus on trying to understand the chart. Knowing your data is the critical step. Follow these simple steps for charting your data.
I broke my own rule this week. In a moment of desperation I began plugging values into cells, sorting and sifting through data trying to get this data table populated. It was brutal. Luckily, I’ve built enough procedures and processes that this type of thing doesn’t happen often. But it reminds me of the purpose of this site
Here are some tips that I’ve been sharing on Twitter. When you use these kinds of tricks in your regular processes can save you hours of work. There’s no reason to be spending more than 10 minutes on any task. Use these tricks and spend less time on boring stuff, and allow you to focus on what you want to.
If you are working for more than 10 minutes on any one process in Excel, YOU ARE WASTING YOUR TIME! I was working on a process that was requiring a bunch of manual moving, copy, and pasting and my little mental timer went off…
I’ve heard that Microsoft Excel built in so many redundant processes, in an effort to make it easy for anyone to find a way to perform a function, that any function can be done eight ways.? So I was thinking of how many ways you can save a spreadsheet in Excel: Click on the disk Click File / Save Control + S on the keyboard Try to close the document…