LF logo
by learnformula
search
Log in
search
Courses/Office Productivity/MS Excel

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.

Created byMike Thomas
4.8
(5 reviews)
BeginnerUpdated Apr 12, 2022
Excel for HR Professionals - Bar Charts and Column Charts

What You'll Learn

check_circleSelect and create the most appropriate chart for your data
check_circleChange the type of chart and/or the data source of an existing chart
check_circleFrom drab to fab...convert a basic chart into an eye-catching visual
check_circleCreate infographic-style charts by filling the bars with images and shapes
check_circleCreate a chart from a Pivot Table
check_circleCopy and export charts created in Excel to other applications

About This Course

By the end of this course, you'll have the knowledge you need to turn your numerical data into a set of engaging, attention-grabbing, and easy-to-understand visuals!

"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!

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.

Aimed at users who have little or no experience in 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.

Here's what you'll get: Bite-sized, easy to understand, and to-the-point training delivered by an instructor with over 30 years experience of working with and teaching Excel

A copy of all the Excel workbooks used in the videos so that you can follow along with the demonstrations

Your Instructor

Mike Thomas
Mike Thomas

Productivity-Boosting Excel and PowerBI Training

menu_book1 courses
star5 reviews

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses which are available via a number of platforms and in his career delivered thousands of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organisations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

Credit Information

Do these courses count toward my professional development requirements?

This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.

If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.

What Students Are Saying

4.8
Student's Choice
5 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.