Course Overview:

Excel is a must-have tool for everyone who works with data, whether it's for business or otherwise. However, it can be used also in data analytics and research. This course is intended to provide a basic understanding of how to use Excel spreadsheets for data analysis. It covers the fundamentals of dealing with spreadsheets and how to use them in data analysis. You'll gain significant expertise utilising functions to cleanse and generate reports from data.

Learning Outcome:

Upon completion of this course you will learn how to use Excel and its formulas and functions that are important to analyse data and come up with reports. Key topics covered include:

• Introduction to Data Analytics
• Formatting Conditional Formatting and Important Functions
• Analyzing Data with Pivot Tables
• Business Analytics with Excel
• Data Analysis Using Statistics

Ideal for:

• Data Scientists
• Managers / Administrators
• Consultants
• Statisticians

Job opportunities and Career growth:

The new era revolves around data, as it is evident from the increasing use of software tools and ICT technologies to collect and process data. However, the humble MS Excel can prove to be a powerful tool for data analysis. People with Excel skills for the regular spreadsheet exercises are always in demand and those who have also learned to use this application for data analysis and report generation will find getting jobs and promotions easier. Professionals with Excel skills for data analysis can find some of the following jobs:

• Data Analyst - Excel
• Data Manager
• Business Intelligence Executive