Data Visualisation using Excel – Training Course

In this Training Course you will learn about Data Visualisation using Excel. Visual presentation of data and results is an important part of data analysis, and a key element in data mining as well as reporting. A good graph or chart can make your data and results understandable to you, your colleagues, clients or customers.

Excel makes a good tool for data visualisation: it is familiar and widely available, and it has excellent graphical capabilities. In the Data Visualisation using Excel training course (DS103) you will learn the skills you need to use Excel to produce professional-looking graphs and charts. You’ll learn how to choose the best type of graph for your needs and how to refine Excel graphs for maximum effectiveness.

Our training course is about Data Visualisation using Excel, and you’ll learn:

• How to choose the best type of graph.
• Which elements of a graph are important?
• How to create a range of graphs in Excel.
• How to edit and refine your Excel graphs and charts.

Our Data Visualisation using Excel training course builds on our previous Statistical Analysis and Data Courses DS101 and DS102 but can also be taken as a standalone course to help improve your Excel skills.

Data Visualization is an important element in analyzing data. Our training Course on Visualizing Data using Excel will give you the skills you need to produce effective and professional-looking graphs and charts. Your graphs can help when analyzing data with Excel, as it is easier to see patterns and relationships by visualizing data (a graph), than by purely numerical methods.

Visualizing Data with Excel is a good choice, especially for beginners, as Excel has a wide range of tools for analyzing data and can make professional-looking graphs. Excel is also familiar and widely available.

There are many kinds of graph available and in this training course you will learn how to choose the best kind of graph for your data. You will learn how to use Excel graphs to visualize data in the most effective way. You’ll also learn the skills you need to refine and edit your graphs and charts, to maximise their effectiveness.

In this Data Visualisation Course you’ll find out how to make the best use of your data and results by presenting them visually. You’ll learn which graph or chart is the “best” for which circumstance and how to create professional-looking graphs from your Excel spreadsheet.

Our Data Visualisation using Excel Course is suitable for anyone who needs to present data, regardless of their field of interest.

Our Data Visualisation Course includes various topics, such as:

• Which graph to use for what purpose.
  • The basic components of a good chart/graph.
• Bar and Columns charts.
  • Histograms.
  • Tally plots.
• Scatter plots.
  • Trendlines and lines of best-fit.
• Line charts.
• Pie Charts.
• Box-whisker plots.

No prior knowledge is assumed but it would be helpful to understand a little about statistics or data. The Making Sense of Data (DS101) and Basic Hypothesis Testing (DS102) courses would make ideal background. Some basic idea of how to use your spreadsheet would also be useful.

You’ll simply need a computer and Excel spreadsheet software. Online courses are delivered using the Zoom software, which is available for Windows or Macintosh computers. Support material is supplied online, usually via Google Classroom.

The duration of the Data Visualisation using Excel Course is one day (starting at 9.30am and ending around 4.30pm).

Since COVID-19 online courses have been more popular. All our data training courses are available online, which means we can be flexible about dates. We can also arrange training at our main training centre in London, or at your workplace. At the moment there are no set dates for courses but you can Check dates here to see details of forthcoming events.

Our main training centre is at 107, Cheapside, London EC2V 6DN. This is right in the heart of London and is close to Bank and St. Paul’s underground stations.

The Data Visualisation using Excel course (DS103) is part of a suite of training courses aimed at beginners in data science. See also:

• Making Sense of Data (DS101) – Learn how to arrange and manage your data most effectively.

• Basic Hypothesis Testing using Excel (DS102) – Learn some of the basic hypothesis tests that underpin data analysis.