Tag Archives: Video

How to Create New Categories of Data

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. Continue reading

Posted in Best Practices, Excel, Video | Tagged , , , , , , , , , , | Leave a comment

How to Count or Sort Rows by Color

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. Continue reading

Posted in Best Practices, Excel, Video | Tagged , , , , | 2 Comments

The Art of Charting in Excel

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. Continue reading

Posted in Best Practices, Communication, Excel, Presentations, Video | Tagged , , , , , , , | Leave a comment

How to Create an Excel Chart that Amazes

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. Continue reading

Posted in Best Practices, Communication, Excel, Presentations, Video | Tagged , , , , , , , | Leave a comment

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. Continue reading

Posted in Excel, Presentations, Video | Tagged , , , , , , , | 3 Comments