Menu
  1. Home
  2. Microsoft
  3. Excel
  4. Short
  5. Excel Data Analysis for Modern Managers
Enquire Now

Excel Data Analysis for Modern Managers

Study Method
In-class
Locations
London, Milton Keynes, Portsmouth, Southend-on-Sea
Institution
PCWorkshops
Start Date
Multiple start dates available

Course overview

Make it easy to spot a trend and key values in data quickly. Excel techniques required for manipulating sets of data stored in Excel, to analyse and obtain useful business insights from the data. These Excel skills are common tools that data scientists depend on to gather, transform, analyse, and visualise data.

Expand all and read more

Campus locations

Study method

  • In-class
  • Blended
  • Online

Locations

  • England
    • London
    • Milton Keynes
    • Portsmouth
    • Southend-on-Sea
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 1 Day

Course features

  • You can bring your own Laptop – let us know beforehand
  • You can bring your own data and examples – let us know beforehand
  • Certificates: You will get attendance certificates
  • Notes: You will get brief course notes
  • On-site support: 1-hour consultation after the course, bookable, online, on-site or at our office

Subjects

Core Units
Working with Sheets and Files
  • Calculating using multiple sheets or files, getting trends over sheets of files, linking files for auto-updating of values
Working with Names and Ranges
  • Simplify cell-referencing and copying of form
Working with Array Formulas
  • Getting a range of results (for each value in a range)
Working with Tables/Database
  • Working with Records and Fields
  • Working with Filters
  • Sorting Data
  • Conditional Formatting
  • Data Validation to maximise accurate user input
  • Finding errors and formulae to clean data (TRIM, LEFT, RIGHT, IFERROR, IFBLANK, etc.) remove duplicates
  • Custom lists and using drop lists in cells
Subtotals, Group, Outline
Cross-Referencing Data
  • Hlookup
  • Vlookup
  • Match, Index
And more!
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £420

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.