EXCEL COURSE – EXCEL 101 ANALYTICS
At the heart of having it is the ability to analyse data and derive useful conclusions. Excel offers some data analysis features, which is good news. This Excel course teaches you how to analyse data from a number of sources using a range of Excel capabilities.
Pre-requisites
This Excel course,Excel training is designed for beginners and does not require any prior expertise; nevertheless, some basic Excel understanding will be useful during the Excel training session. Excel 2016 or later versions should be installed on participants’ laptops or PCs.
The Power Query and Power Pivot features of Excel are used in this course, which may not be available on the Mac version of Excel. Check to determine if Power Query and Power Pivot are available in your version of Excel if you’re a Mac user.
Learning outcome
After completing this Excel course, participants will be able to:
- describe the analytics life cycle.
- Excel may be used to import, transform, and clean data.
- Make a data model in Excel.
- Create a visualisation in Excel using PivotChart, slicers, and report connectors.
Course Outline for the Excel Analytic course
- Introduction
- This module covers the analytics life cycle, data extraction and transformation, and data visualisation.
- An Investigation of a Case
To learn how to use analytics and put them into practise, enrol in Excel training.
Take this Excel course to improve your skills and advance your career.
So, what are you waiting for?
EXCEL COURSE – EXCEL 101 ANALYTICS
At the heart of having it is the ability to analyse data and derive useful conclusions. Excel offers some data analysis features, which is good news. This Excel course teaches you how to analyse data from a number of sources using a range of Excel capabilities.
Pre-requisites
This Excel course,Excel training is designed for beginners and does not require any prior expertise; nevertheless, some basic Excel understanding will be useful during the Excel training session. Excel 2016 or later versions should be installed on participants’ laptops or PCs.
The Power Query and Power Pivot features of Excel are used in this course, which may not be available on the Mac version of Excel. Check to determine if Power Query and Power Pivot are available in your version of Excel if you’re a Mac user.
Learning outcome
After completing this Excel course, participants will be able to:
- describe the analytics life cycle.
- Excel may be used to import, transform, and clean data.
- Make a data model in Excel.
- Create a visualisation in Excel using PivotChart, slicers, and report connectors.
Course Outline for the Excel Analytic course
- Introduction
- This module covers the analytics life cycle, data extraction and transformation, and data visualisation.
- An Investigation of a Case
To learn how to use analytics and put them into practise, enrol in Excel training.
Take this Excel course to improve your skills and advance your career.
So, what are you waiting for?
