Excel Data Analysis Course

Excel Data Analysis Course

Course FAQ's - Contact Us for your Bespoke Excel Course - What's Included

Book now

From £250

Choose your date for London and book here
Choose your date for Milton Keynes and book here
Choose your date for Southend-on-Sea and book here
Choose your date for Portsmouth and book here
Choose your date for Manchester and book here

Microsoft Excel Data Analysis for Modern Managers

Private 1-to-1, Versions 2007 upwards

Course summary

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.

Excel Course Outline

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:
Match, Index
Excel Function wizard for statistical functions:
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
Pivot charts

What is included:

Excel Course Certificate on completion (assessment based)
Excel Course notes
Practical Class exercises, Excel Course Homework / Excel Course Revision work
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online via Skype or Teamviewer.

Other Excel Courses

Is this the course for you? Book today and start preparing for the course

PCWorkshops specialises in Java Courses, Database courses and MS Project Courses.