Excel Data Analysis 1

  • Monday 4th March - COURSE FULL
  • Free (0 Credits)
Overview

To be faster & more confident analysing data in Excel
To summarise data using a Pivot Table
To visualise large amounts of data simply with a Pivot Chart

Applicants must have a basic understanding of Excel, including knowing how to navigate cell references, different styles, create formulas and various keyboard shortcuts.

Date

Monday 4th March – 9:30am – 12:30pm – COURSE FULL

 

Cost

Fully funded

Key Features
  • Understand the best way to arrange data in a spreadsheet
  • Find & fix inputting errors
  • Use Pivot tables to summarise & analyse data
  • Use format, layout & design options
  • Insert Slicers & timelines
  • Insert Calculated Fields, using grouped dates
  • Use the Subtotal function to calculate subtotals
  • Copy & paste visible cells
MEET THE LECTURERS

ALX Training

    We are a team of experienced IT Trainers & Software Adoption Specialists who deliver creative design-led learning to private & public sector organisations.

    Driven by our clients’ needs, we help organisations realise the full potential of their IT investment.

    ALX Training is part of BDO Jersey, working closely with BDO Advisory and C5 Alliance to help businesses and people succeed

    Top