Summer Sets: Data Analysis In Excel + Data Science

Course

Online

Save 80%
£ 19 VAT inc.

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Class hours

    13h

  • Duration

    Flexible

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Are you looking to break into the field of Data Science, or merely gain a solid understanding of the discipline? Do you want to understand the importance of data better, and how to use it?

In a world where we are constantly bombarded with information, making sense of it all can sometimes be difficult and time-consuming. This is particularly true of Excel. Analysing large amounts of data and presenting information that makes sense to your audience is an essential skill for many people.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

In this bundle, we aim to teach you the basic skills you need to analyse data effectively and efficiently. From Pivot Tables and Conditional Formatting to Lookup Formulas and beyond, ‘Excel Data Analysis’ will set you up with a great foundation upon which to build further skills. Get ready to impress your colleagues and gain their respect with your insight and knowledge after completing this duo!

CPD UK

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

2019

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

Subjects

  • Excel
  • Data analysis
  • MS Excel
  • Data science
  • Analytical skills
  • Large data sets
  • Data sets
  • Business
  • Findings
  • Separate
  • Signals
  • Excel techniques

Course programme

What you will learn in these courses:

Data Science:

  • How to use your analytical skills to manipulate large data sets
  • To develop business acumen, so findings are applicable in the real world
  • To master statistics, to separate vital signals from irrelevant noise
  • To grasp the basics of programming language and advanced Excel techniques
  • To understand the core elements of data science, allowing you to solve real business problems

Data Analysis in Excel:

  • Clean up data ready for analysis
  • Create PivotTables and PivotCharts
  • Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH
  • Make decisions using IF Statements
  • Highlight information using Conditional Formatting and Rules
  • Build a basic Interactive Dashboard

Summer Sets: Data Analysis In Excel + Data Science

£ 19 VAT inc.