www.getreporthelp.com
This happens all the time; you get a set of data and you realize that whatever category is there, is wrong. Here’s a video showing how to re-categorize the data quickly and easily. It uses a few formulas, and we have videos showing those in detail.
If you’ve had a spreadsheet with many rows colored and other rows left uncolored, then you realize that there is no easy button to sort or count rows that have color. This can be a very time consuming process, unless you use Visual Basic. Here’s one solution that we’ve come up with.
As a Business Intelligence professional you need to know how to make a good chart in Excel. 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 3 of a 3 part series on how to create compelling charts in Excel.
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 2 of a 3 part series on how to create compelling charts in Excel.
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.