In our previous tip we showed you how to present data with PivotTable groupings and then add a column chart and convert that into a histogram. This week, we’ll show you how to create a real histogram by installing the Analysis ToolPak which provides you with a host of data analysis tools. Note: Download the […]

Continue reading

Never heard of a histogram? A histogram is a column chart that shows frequency data. For example, if you’re in sales and would like to analyze how frequently you sell certain quantities of goods, you can use a histogram. Note: Download the workbook to practice this exercise Applies To: Microsoft® Excel® 2010 and 2013 Download […]

Continue reading

Last week we shared a budget template to help you manage your finances. This week we want to show you how to use Icon Sets to see, at a glance, whether you’re over, below or on budget. In the template, you will see that we’ve used Icon Sets to illustrate the difference or variance between […]

Continue reading

It’s never too late to draw up a budget, especially in the current global economic climate. A budget is an invaluable tool to help you prioritize your spending and manage your money – no matter how much you have. Basically, a budget is an indication of expected income and expenses for a certain time frame.  […]

Continue reading

There are a so many keyboard shortcuts available for performing very common tasks, which can save you a lot of time. For example, there are keyboard shortcuts available for formatting cells. In some instances, there is more than one shortcut combination that can be used to perform one function, like these: Ctrl + 2 and […]

Continue reading

Grouped columns and rows (sometimes called Outline Data) are an alternative for hiding and showing data without using the Hide and Unhide function. Both options are great for organizing and de-cluttering worksheets which have a lot of data on display. Did you know that you can expand and collapse grouped columns using keyboard shortcuts? Follow […]

Continue reading

If you have a worksheet with a lot of data and you want to ensure your data integrity, you need to make certain that there are no duplicates in your data. Trying to find and remove duplicates in your worksheet can be like trying to find a needle in a haystack. Fortunately the Remove Duplicates […]

Continue reading

To make a number easy to read, or to make it a ‘round’ number you can format it to only show a certain number of decimal places regardless of how many are actually in the cell. Instead of having to use your mouse to format the cell in a number of steps, you can do […]

Continue reading

If you have data in your Microsoft® Excel® worksheet that spans across a lot of columns, you won’t see all of your data on your screen. To view different columns, you need to scroll from one side of the sheet to the other. Most people would use the scroll bar, but there’s a quicker and […]

Continue reading