Category: Video

Posted on: June 23, 2016 Posted by: admin Comments: 0

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.

Posted on: October 8, 2011 Posted by: Johnny Comments: 0

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.

Posted on: June 6, 2011 Posted by: Johnny Comments: 0

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.

Posted on: February 16, 2011 Posted by: Johnny Comments: 2

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.

Posted on: January 21, 2011 Posted by: Johnny Comments: 0

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.

Posted on: December 1, 2010 Posted by: Johnny Comments: 0

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.

Posted on: November 19, 2010 Posted by: Johnny Comments: 3

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.