Excel Module 2 – Gathering and Presenting Data Course

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

Course leader

Susan Howard

Head of Technical & Digital and Project Management Capability

Need a bespoke solution?

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

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine