Analyze your data with MS Excel!

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

5.0
4 opinions
  • Very interesting and insightful course. I managed to learn a lot, thank you
    |
  • 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!
    |
  • 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.
    |

In London, Milton Keynes, Portsmouth and 3 other venues

£ 201-500
  • Typology

    Short course

  • Level

    Intermediate

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

Location

Starts

Berlin (Germany)
See map

Starts

Different dates availablePlaces sold out
Hannover (Germany)
See map

Starts

Different dates availablePlaces sold out
Köln (Germany)
See map

Starts

Different dates availablePlaces sold out
London
See map
8 Duncannon Street, WC2N 4JF

Starts

Different dates availablePlaces sold out
Milton Keynes (Buckinghamshire)
See map
Exchange House, 494 Midsummer Boulevard, MK9 2EA

Starts

Different dates availablePlaces sold out
Portsmouth (Hampshire)
See map
Lakeside North Harbour Western Road Building 1000 Ground Floor, PO6 3EZ

Starts

Different dates availablePlaces sold out
See all (6)

To take into account

Data analytics

Data professionals, data analysts and BI

Some basics of Excel

Private 1-1

Questions & Answers

Ask a question and other users will answer you

We will only publish your name and question

Opinions

5.0
excellent
  • Very interesting and insightful course. I managed to learn a lot, thank you
    |
  • 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!
    |
  • 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.
    |
100%
5.0
excellent

Course rating

Recommended

Centre rating

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

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

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

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
Reviews gathered by Emagister & iAgora

Achievements for this centre

2018

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

£ 201-500

Call the centre

for further information on the course