How to Use Microsoft Excel for Data Analysis

Offered byFutureLearn

How to Use Microsoft Excel for Data Analysis
at
FutureLearn
Overview

Duration	2 weeks
Total fee	₹900
Mode of learning	Online
Official Website	Go to Website
Credential	Certificate

How to Use Microsoft Excel for Data Analysis
at
FutureLearn
Highlights

Duration 2 weeks
Weekly study 5 hours
100% online Learn at your own pace

How to Use Microsoft Excel for Data Analysis
at
FutureLearn
Course details

Skills you will learn

Excel Data Modeling Vlookup Data analysis Big Data

More about this course

From transport to finance, everyday activities are increasingly leaving digital footprints that are transforming the workplace. Data analytics is the study of this 'big data'.
As the world is becoming ever more data-driven, many employers are increasingly searching for people with analytical skills. The global data analytics market is expected to grow by 30% from 2020 to 2023, offering a huge number of employment opportunities. Build your skills in data analytics and Microsoft Excel to find an entry into this thriving industry and create a rewarding and lucrative career.
You'll learn how to perform data analysis by creating pivot tables in Microsoft Excel which is one of the most popular features in Excel. You'll see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data to produce useful insights from your accumulated data.
You'll also learn how Excel formulas can be used to aggregate data to create useful reports across a multitude of business functions. These skills will help you to create dashboards and report hierarchical data. You'll even be able to find anomalies within your data, to prevent mistakes in reporting.
Once you've analyzed your data, you'll need to present it to your stakeholders. You'll learn how to create a variety of charts and visualizations so that your data analysis work can make a real impact.
As part of this course, you'll have access to a dedicated lab environment with the latest Microsoft Excel application and tools to complete exercises and activities, all powered by CloudSwyft.