25,000+ Courses Nationwide
0345 4506120

Excel Data Analysis for Modern Managers - One-to-One Training

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.

Select specific date to see price, venue and full details.

Learning Objectives

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

Course Content

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

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best