Analyze your data with MS Excel!
PCWorkshops

Microsoft Excel Data Analysis for Modern Managers, Private 1-1

5.0 excellent 4 opinions
PCWorkshops
In London, Milton Keynes, Portsmouth and 3 other venues

£ 201-500
Prefer to call the centre directly?

Important information

Typology Short course
Level Intermediate
Location At 6 venues
Duration 1 Day
Start Different dates available
  • Short course
  • Intermediate
  • At 6 venues
  • Duration:
    1 Day
  • Start:
    Different dates available
Description

Prepare yourself to upgrade your Excel skills in order to manipulate sets of data with this Microsoft Excel Data Analysis for Modern Managers, offered by Emagister and imparted by PCWorkshops.

As a modern manager you need to go one step beyond and use Excel to obtain insights of your data and spot future trends that may impact your decision making. These skills are currently being used by data scientists who want to gather and analyse this type of information with a good visualization.

You’ll start learning from scratch how to work with the sheets, linking the files and auto-updating values. Also, working with formulas, copying forms to simplify cell referencing with names and ranges.

In addition, you’ll dig deeper by learning Excel Function wizard for statistical functions, using advanced filters and setting up criteria. Summarising and categorising data and finding trends with Excel Pivot tables, charts and calculations.

This programme includes an assessment-based Data analysis course certificate, including the notes, practical exercises, revisions of your work and also coffee and tea.

So, if you want to learn more, don’t hesitate to contact PCWorkshops through Emagister.co.uk

Facilities (6)
Where and when

Location

Starts

Berlin (Germany)
See map

Starts

Different dates availableNow taking bookings
Hannover (Germany)
See map

Starts

Different dates availableNow taking bookings
Köln (Germany)
See map

Starts

Different dates availableNow taking bookings
London
See map
8 Duncannon Street, WC2N 4JF

Starts

Different dates availableNow taking bookings
Milton Keynes (Buckinghamshire)
See map
Exchange House, 494 Midsummer Boulevard, MK9 2EA

Starts

Different dates availableNow taking bookings
Portsmouth (Hampshire)
See map
Lakeside North Harbour Western Road Building 1000 Ground Floor, PO6 3EZ

Starts

Different dates availableNow taking bookings
See all (6)

To take into account

· What are the objectives of this course?

Data analytics

· Who is it intended for?

Data professionals, data analysts and BI

· Requirements

Some basics of Excel

· What marks this course apart?

Private 1-1

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Opinions

5.0
excellent
Course rating
100%
Recommended
5.0
excellent
Centre rating

Reviews on this course

A
Andy Farrant
5.0 22/07/2018
What I would highlight: Very interesting and insightful course. I managed to learn a lot, thank you
What could be improved: -
Would you recommend this course?: Yes
Did this opinion help you? Yes (0)
A
Antonio Monteiro
5.0 05/11/2017
What I would highlight: Sarah is an excellent teacher. Her explanations are very clear and simple making functions look easy. I managed to learn a lot of things in Excel and will definitely recommend it!
What could be improved: .
Would you recommend this course?: Yes
Did this opinion help you? Yes (0)
T
Tanveer Khan
5.0 15/11/2016
What I would highlight: Thank you for finally consolidating my knowledge on Vlookups. It was confusing and I didn't know why I was so confused about it in the first place. Thank you so much.
What could be improved: .
Would you recommend this course?: Yes
Did this opinion help you? Yes (0)
E
Emma Zane
5.0 09/07/2016
What I would highlight: Sarah is a great teacher. She is very kind and will not refuse to answer the same questions. The course material was also good and the examples were even better. It helped me understand.
What could be improved: -
Would you recommend this course?: Yes
Did this opinion help you? Yes (0)
Reviews gathered by Emagister & iAgora

Achievements for this centre

2018

How do you get the CUM LAUDE seal?

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 2 years

What you'll learn on the course

Excel
Data Mining
Microsoft Excel
Data analysis
Data Collection
Private
Microsoft excel training
MS Excel
Data Analytics
Data Visualization
Data trends
Microsoft excel training
Data Visualization
Microsoft excel training
Data Visualization

Teachers and trainers (1)

Sarah Barnard
Sarah Barnard
Coder, Instructor

Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.

Course programme

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
Pivot charts