Excel Data Analysis Course

Excel Data Analysis Course summary

In this Excel Course you will learn how to work effectively with large data sets.

Excel Data Analysis Course Description

Make it easy to spot 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, analyze, and visualize data.


Working with Excel 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, to simplify cell-referencing and copying of form
Working with Array Formulas
getting a range of results (for each value in a range)
Working with Excel 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
Excel Subtotals, Group, Outline
Cross Referencing data:
Hlookup
Vlookup
Match, Index
Excel Function wizard for statistical functions:
If,
Sumif(s), Averageif(s), Countif(s)
Dsum, Daverage, Dcount
For large dataset, organising columns, remove or add columns, filter relevant records:
Advanced Filter
Setting up criteria
Using Wildcards
Summarising and categorising data and finding trends:
Excel Pivot Tables
Create Pivot Tables
Amend Pivot Tables
Create Pivot Tables Custom Calculations
Amending calculations
Working with dates, sorting pivots,
Create Pivot Charts
Overview of Excel Charts and Sparklines

What is included in the Excel Courses:
  • Excel Course Certificate on completion (assessment based)
  • Excel Course notes
  • Practical Excel Course exercises, Excel Course Homework / Excel Revision work
  • Tea, coffees, but no lunch
  • To assist after the course, 1 free session for questions online Excel Course via Skype or Teamviewer.
  • Max group size on this Excel Course is 4.
LOCATIONS
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops Manchester
MANCHESTER: 53 Fountain Street, Manchester, M2 2AN
Read More
PCWorkshops Birmingham
BIRMINGHAM: One Victoria Square, Birmingham, B1 1BD
Read More
PCWorkshops Southend-on-Sea
SOUTHEND-ON-SEA: The Forum, Elmer Square, Southend-on-Sea SS1 1NS
Read More
PCWorkshops Milton Keynes
MILTON KEYNES: Exchange House, 494 Midsummer Boulevard, Milton Keynes, MK9 2EA
Read More
PCWorkshops PORTSMOUTH
PORTSMOUTH: Building 1000, Lakeside North Harbour, Western Road, Portsmouth, PO6 3EZ
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More

Subscribe our Newsletter

Sign up to receive lessons, tips, examples, quizzes and other training materials.