Category: Charting

Excel Fundamentals Boot Camp

COACHED TRAINING: Excel Fundamentals Boot Camp Course Description In the Fundamentals Boot Camp, you will begin with a review core skills for the Excel analyst. This section is geared to teach critical skills to less experienced users and review those

Read More »

Excel Dashboards

ON-DEMAND: Excel Dashboards COURSE DESCRIPTION Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data. Ken Puls has worked with a company called GoSkills to help design and

Read More »

Microsoft Excel – Advanced

ON-DEMAND: Microsoft Excel - Advanced COURSE DESCRIPTION Have some experience with Excel and want to improve your skills, or taken our Basic Excel course? This online course Ken Puls has built with GoSkills will help you learn intermediate and advanced

Read More »

Microsoft Excel – Basic

ON-DEMAND: Microsoft Excel - Basic COURSE DESCRIPTION New to Excel or need a refresher? Ken Puls has worked with a company called GoSkills to design and build a targeted Excel course which is offered in an online format. This online

Read More »

Microsoft Excel – Basic & Advanced

ON-DEMAND: Microsoft Excel - Basic & Advanced COURSE DESCRIPTION Looking for an Excel course online to improve your skills and save you time? Ken Puls has worked with a company called GoSkills to help design and build Basic and Advanced

Read More »

Temperature Forecast Chart

Some of the really cool charts that we can build in Excel involve the trick of combining multiple chart types together to make them happen. In this article, we’ll build one of those; a temperature chart that not only shows

Read More »

VLOOKUP for Pictures

Something that can be very handy when you’re building a dashboard is to return a certain picture depending on a condition. We can use VLOOKUP to look up data in a table and return the corresponding value from a different

Read More »

Data Labels on Chart Series

Since I know I have a few charting guys that follow this, I figured that I'd ask this question here. Hopefully the response will help someone… I'm creating a food & beverage function evaluation form, and threw a chart on

Read More »

Pie Chart of Daylight Hours

I came across this a while ago in a weather app on my iPhone, and thought it was interesting. Then there was a conversation on Twitter in which I brought it up as well. I'm not a huge fan of

Read More »