Excel Module 2 – Data Visualisation

Book this course

Course description

When it comes to data, Microsoft Excel is one of the most powerful tools for the job. Beyond its basic features, Excel can be used to gather and present data in a useful and meaningful way, ultimately enhancing the way in which you work.

We show you the essential features and tools you need to be aware of in order to use Excel for effectively managing data – from formulas and formatting to creating graphs and setting up automation.

Is it right for me?

If you’re already an Excel user – either you’ve attended our Excel Module 1 (Essentials) course, or have equivalent knowledge – this Excel training course will enhance your current skill level.

What will I get out of it?

By the end of the course you will be able to:

  • Transfer and link information between worksheets and workbooks
  • Create and format graphs
  • Automate repetitive tasks with macros
  • Add conditional formatting to cells
  • Create and use spreadsheets with validation and protection
Trainer was excellent. Answered all questions at length and explained everything in detail. All in all, a very good day all round. Thank you.
Personal Assistant, Caravan Club

What does it cover?

  • Building formulas
  • Ordering calculations
  • Absolute cell references
  • Using functions
  • Moving, copying, inserting and deleting worksheets
  • Selecting multiple worksheets
  • Changing tab colour
  • Linking within a workbook
  • Linking between workbooks
  • Changing the type of graph
  • Adding data labels
  • Customising the graph
  • Creating Sparklines
  • Recording and running macros
  • Assigning macros to quick keys
  • Assigning macros to the quick access toolbar
  • Assigning macros to objects
  • Changing the cell format depending on set criteria
  • Databars, top/bottom rules, colour scales and icon sets
  • Creating custom formula rules
  • Setting number and date validation
  • Setting drop down list validation
  • Setting custom validation
  • Using the auditing facility
  • Protecting worksheets
  • Selectively protecting
  • Protecting workbooks

Book this course

Other recommended courses

Show more courses +

Course leader

Susan Howard

Head of Technical, Digital and Project Management

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Latest insight from Thales L&D

Free download

Enhance Magazine - Issue 19

Welcome to our latest issue of Enhance. Businesses are facing ever more challenging times in terms of global and local...

Read full article

Blog article

How Prepared are You? Episode Two: An Ageing Workforce

With all the changes I see occuring, one of the questions I'm most interested in is: how are organisations preparing...

Read full article

White paper

A Useful Guide to L&D Curriculum Design

Employee engagement has become one of the most frequently cited buzzwords in the HR and L&D world, and with good...

Read full article