Excel Data Analysis Course

Excel Data Analysis Course



From £290 - FAQ's - Included - Course outline - Bespoke Course

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:
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

Other Excel Courses






What is included in this Excel Data Analysis Course:


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

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.