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

Short course

Online

£ 290 VAT exempt

Description

  • Type

    Short course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    1 Day

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

Online

Start date

Different dates availableEnrolment now closed

About this course

Data analytics

Data professionals, data analysts and BI

Some basics of Excel

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

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

Microsoft Excel Data Analysis for Modern Managers, Private 1-1
Time: 11am-6pm (GMT)
Duration: 1 days
Online, Instructor-Led, Practical

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

£ 290 VAT exempt