Summer Sets: Data Analysis In Excel + Data Science
Course
Online
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
Start date
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
Reviews
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 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
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