PCWorkshops

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

5.0 ausgezeichnet 4 Meinungen
PCWorkshops
In London (England)
  • PCWorkshops

Preis auf Anfrage
PREMIUM-KURS

Wichtige informationen

Tipologie Short course
Niveau Intermediate
Ort London (England)
Dauer 1 Day
Beginn nach Wahl
  • Short course
  • Intermediate
  • London (England)
  • Dauer:
    1 Day
  • Beginn:
    nach Wahl
Beschreibung

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

Wichtige informationen
Welche Ziele verfolgt der Kurs?

Data analytics

Ist dieser Kurs für mich?

Data professionals, data analysts and BI

Voraussetzungen: Some basics of Excel

Einrichtungen (1)
Wo und wann
Beginn Lage
nach Wahl
London
8 Duncannon Street, WC2N 4JF, London, England
Karte ansehen
Beginn nach Wahl
Lage
London
8 Duncannon Street, WC2N 4JF, London, England
Karte ansehen

Meinungen

5.0
ausgezeichnet
Kursbewertung
100%
Empfehlung der User
5.0
ausgezeichnet
Anbieterbewertung

Meinungen über diesen Kurs

A
Antonio Monteiro
05.11.2017
Das Beste: 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!
Zu verbessern: .
Kurs abgeschlossen: November 2017
Würden Sie diesen Bildungsanbieter weiterempfehlen?: Ja
T
Tanveer Khan
15.11.2016
Das Beste: 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.
Zu verbessern: .
Kurs abgeschlossen: November 2016
Würden Sie diesen Bildungsanbieter weiterempfehlen?: Ja
A
Andy Farrant
22.07.2018
Das Beste: Very interesting and insightful course. I managed to learn a lot, thank you
Zu verbessern: -
Kurs abgeschlossen: Juli 2018
Würden Sie diesen Bildungsanbieter weiterempfehlen?: Ja
E
Emma Zane
09.07.2016
Das Beste: 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.
Zu verbessern: -
Kurs abgeschlossen: Juli 2016
Würden Sie diesen Bildungsanbieter weiterempfehlen?: Ja
*Erhaltene Meinungen durch Emagister & iAgora

Was lernen Sie in diesem Kurs?

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

Themenkreis

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