Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Excel: Data Visualization with Bar and Column Charts

person icon Mike Thomas

4.6

Excel: Data Visualization with Bar and Column Charts

Impress your boss. Impress your colleagues. Turn drab into fab. Tell your story with awesome charts in Excel

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Mike Thomas

category icon Office Productivity,Microsoft

Lectures -14

Resources -10

Duration -1 hours

4.6

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

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 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.

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

Goals

What will you learn in this course:

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

Prerequisites

What are the prerequisites for this 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.
Excel: Data Visualization with Bar and Column Charts

Curriculum

Check out the detailed breakdown of what’s inside the course

Welcome to the Course
2 Lectures
  • play icon Promo Video 01:34 01:34
  • play icon Welcome to the Course 02:46 02:46
Create a Chart
3 Lectures
Tutorialspoint
Chart Elements
2 Lectures
Tutorialspoint
Colours and Fills
2 Lectures
Tutorialspoint
Pivot Charts
2 Lectures
Tutorialspoint
Save and Copy a Chart
2 Lectures
Tutorialspoint
Wrap Up
1 Lectures
Tutorialspoint

Instructor Details

Mike Thomas

Mike Thomas

Productivity-Boosting Excel and PowerBI Tutorials

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 a career spanning 30+ years, Mike has delivered thousands of courses and produced hundreds of written and video-based Excel tutorials.

He 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.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515