course-premium

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

5.0
4 reviews
  • 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.
    |

Short course

In Berlin (Germany), London, Milton Keynes and 4 other venues

£ 95 VAT exempt

Enrol into this course to learn from the best how to upgrade your Excel skills

  • Type

    Short course

  • Level

    Intermediate

Analyze your data with MS Excel!

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

Start date

Berlin (Germany)
See map

Start date

Different dates availableEnrolment now closed
Hannover (Germany)
See map

Start date

Different dates availableEnrolment now closed
Jersey Guernsey (Channel Islands)
See map

Start date

Different dates availableEnrolment now closed
Köln (Germany)
See map

Start date

Different dates availableEnrolment now closed
London
See map
8 Duncannon Street, WC2N 4JF

Start date

Different dates availableEnrolment now closed
Milton Keynes (Buckinghamshire)
See map
Exchange House, 494 Midsummer Boulevard, MK9 2EA

Start date

Different dates availableEnrolment now closed
Portsmouth (Hampshire)
See map
Lakeside North Harbour Western Road Building 1000 Ground Floor, PO6 3EZ

Start date

Different dates availableEnrolment now closed
See all (7)

About this course

Data analytics

Data professionals, data analysts and BI

Some basics of Excel

Private 1-1

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

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
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

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

Subjects

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

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

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

£ 95 VAT exempt