Category Archives: Video

My Presentation at Empower 2016

Deciding what level of detail to create in your QuickBase tables can make a huge difference in how you create, update, and delete records. You have choices, but many don’t know what those choices are and what are the consequences are. Continue reading

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

Critical Point When Presenting to Managment

When presenting to management, you need to consider these critical keys. Continue reading

Posted in Best Practices, Presentations, Video | Leave a comment

How to learn faster and get up to speed

YouTube is an amazing tool for learning languages and programs. A perfect example is SteveFox1973 who makes basic Microsoft’s Sql Server Integration Services (SSIS) videos. Continue reading

Posted in Best Practices, Video | Leave a comment

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