merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Excel Data Analysis for Modern Managers

PCWorkshops
Course summary
1 day
English
London
Open / Scheduled

Excel Data Analysis for Modern Managers

Excel Data Analysis

Excel Data Analysis for Modern Managers - 1 day open / classroom course

This one day training programme will provide delegates with Excel Techniques required for manipulating sets of data stored in Excel, to analyse and obtain useful business insights from the data.

This course covers the following topics:

  • Working with Names and Ranges, Working with Array Formulas
  • Conditional Formatting, Data Validation, custom lists
  • Function wizard for statistical functions:
  • Working with Tables, Working with Records and Fields, Working with Tables and Filters
  • Using Excel as a Database:
    - Subtotals, Group, Outline
    - Dsum, Daverage, Dcount
    - Hlookup, Vlookup, Match, Index
    - Pivot Tables
    - Working with sheets and files
    - Graphs and Pivot charts

Suitability - Who should attend?

This course is designed for managers looking forward to sharpen their Excel terminology and capability to analyse large data sets.

Expenses

The cost of this 1 day course is 250 GBP+VAT per delegate.

Provider: PCWorkshops

PCWorkshops

PCWorkshops - Training in Java, SQL, MS Project, Excel and Data Design

PCWorkshops offers training courses in Java Programming, Database design and Data Normalisation, SQL Courses, Data reporting with MS SQL Server Report Builder, Excel Data Analysis for modern managers, data analyses courses. Our clients are: Software companies, testing companies and companies...


Read more and show all courses with this provider

Request information - obligation free

Tell us what kind of professional training you're looking for and we'll put you in touch with relevant training providers who will send you a quote.

Contact information for PCWorkshops

PCWorkshops

PCWorkshops
8 Northumberland Avenue
WC2N 5BY London

Need help?

Tell us what kind of professional training you're looking for and we'll put you in touch with relevant training providers who will send you a quote.

Reviews

There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more