Perfect Pairs: Data Analysis in Excel + Data Science

Sale

$138.00 $19.00

Clear section

Category:

Get skilled in this valuable, high-demand area of modern business.

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.

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!

What you get with this Data Analysis duo:

  • 50+ modules of training.
  • Videos and downloadable exercises.
  • Tailored learning. If you have some knowledge, you can use the filter to show only what you most need to learn.
  • A blended learning experience where you’ll learn from a mix of videos, text and interactive quizzes.

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

Sample content:

More about us:

  • We have nearly a million students
  • Our training is personal. Use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and always improving. We work with our authors to ensure our courses are up to date.
  • All of our courses are certificated on completion – most of our Business Courses are also CPD Accredited

If you are not 100% happy with your Skillsology duo, you have 30 days to exchange or refund.

About the author:

Dr Chris Littlewood is Excel with Business’s Chief Scientific Officer and co-founder. Chris worked as a consultant at strategy consultancy Mars & Co after completing degrees in physics and maths at Oxford and Cambridge and conducting research in particle physics at CERN. His doctorate included a comparison of algorithms used to cluster jets of particles produced in high energy collisions so that all the products of a particle decay could be associated with the right parent particle.

He has fifteen years’ experience in analysis and strategy development, across industries at Mars & Co and in the rail sector. Since co-founding Excel with Business, Chris has led on the science behind the product, particularly the filtering algorithm that personalises an individual’s course syllabus based on their job role, learning needs and current proficiency.

He’s passionate about education, science, and understanding what makes industries and organisations tick.

Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).