Microsoft Excel Data Analysis for Modern Managers, Private 1-1
-
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
Enrol into this course to learn from the best how to upgrade your Excel skills
-
Type
Short course
-
Level
Intermediate
-
Location
-
Duration
1 Day
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
Start date
Start date
Start date
Start date
Start date
Start date
Start date
About this course
Data analytics
Data professionals, data analysts and BI
Some basics of Excel
Private 1-1
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.
← | →
Course rating
Recommended
Centre rating
Andy Farrant
Antonio Monteiro
Tanveer Khan
Emma Zane
This centre's achievements
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
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
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