Excel for HR Professionals - Bar Charts and Column Charts

Impress your boss. Impress your colleagues. Turn drab into fab. Tell your story with awesome charts in Excel. Coming soon…a brand new video based course that will equip you with the knowledge you need to turn your numerical data into a set of engaging, attention-grabbing and easy-to-understand visuals!

Excel for HR Professionals - Bar Charts and Column Charts

Course Overview

“Every Picture Tells a Story” is a popular saying which is true not only in everyday life but in Excel too. Behind every set of numerical data is a story waiting to be told. The telling of this story needs to be succinct, easy to understand and engaging.

For most people it’s much easier to understand data, uncover important insights and make better decisions if that data is displayed in a visual way.

Drab-to-Fab. Engaging. Attention-grabbing…you can create a basic chart in Excel with a couple of mouse clicks or even a single keypress but the result is very plain and not at all engaging. This training will teach you how to make your charts more visually appealing so that they grab people’s attention.

Infographics are a popular way of presenting data. After participating in this course, you’ll be able to convert a bland chart into an awesome infographic with just a few mouse clicks!

Excel for HR Professionals - Bar Charts and Column Charts

In many cases, charts created in Excel need to be copied to other applications such as PowerPoint, to be used in a presentation, or Word or a design application such as Publisher to be included as part of a report. On the surface it’s a straightforward process but there’s a few gotchas to watch out for which you’ll learn about in the course.

Is this the Right Course for Me?

Are you an HR Professional who uses Excel and wishes to learn how to create eye-catching charts? Aimed at users who have little or no experience of creating charts in Excel, this training covers how to visually represent your data using two traditional chart types in Excel – bar charts and column charts.

I Don’t Work in HR. Can I Still Take this Course?

Of course you can! The demos and scenarios are HR-themed but the content is relevant and appropriate for anyone who is new to charts in Excel and wants/needs to learn how to create eye-catching charts. I’m sure you can apply the concepts and principles to your situation. 

What’s Included in the Course?

Over one hour of bite-sized, easy to understand and to-the-point training videos delivered by an instructor with over 30 years experience of working with and teaching Excel (that would be me – Mike Thomas!

You will also be able to download a copy of all the Excel workbooks used in the videos so that you can follow along with the demonstrations

What Will I Learn?

  • How to select and create the most appropriate chart for your data
  • How to change the type of chart and/or the data source of an existing chart
  • From drab to fab…how to convert a basic chart into an eye-catching visual
  • How to create infographic-style charts by filling the bars with images and shapes 
  • How to create a chart from a Pivot Table
  • How to copy and export charts created in Excel to other applications

What are the Requirements / Pre-requisites for Taking the Course?

I designed this course for existing users of Excel who have little or no experience of creating charts. Although the course was recorded using the latest version of Excel 365 for Windows, you’ll still be able to follow along if you use an earlier version of Excel. Windows users should at a minimum, have Excel 2010. Mac users will need Excel 2016 or later