- Introduction to the course
- Using formulas in Excel
- Using functions in Excel
- Wrap-up
- Home
- Futurelearn
- Courses
- Excel for Data Analysis
Excel for Data Analysis
Learn about the use of Microsoft Excel to transform and manage big data through the Excel for Data Analysis training course.
Online
4 Weeks
Quick facts
particular | details | |||
---|---|---|---|---|
Collaborators
Tableau Software,
+1 more
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Learning efforts
4 Hours Per Week
|
Course overview
The Excel for Data Analysis certification course is the second installment of the Data Analytics For Business training programme provided by the FutureLearn portal supported by Tableau and Coventry University, U.K. The course will help learners to perform data analysis using Microsoft Excel and manage big data. Candidates will learn to structure data with the help of rows, columns and tables in Microsoft Excel. This course will help learners to gather knowledge of Excel and use it to organise data of the organisation.
The Excel for Data Analysis online course will be instructed by Jacques Haasbroek with English as a medium of instruction. The duration of the course is four weeks for which candidates will invest at least four hours weekly to complete the Excel for Data Analysis course syllabus on time. To apply for this course, candidates will have to visit the FutureLearn portal and register. Details regarding this course are given below in the article. Candidates are advised to go through the article carefully.
The highlights
Course and certificate fees
Fee Structure of the Excel for Data Analysis Course
Course | Fee Details |
Excel for Data Analysis Course | Candidates who are taking admission to the Excel for Data Analysis training course will get a seven-day free trial of the FutureLearn portal. After completing the free trial, candidates have to take the monthly subscription of Rs.900 for the FutureLearn portal. The amount has to be paid online. |
certificate availability
certificate providing authority
Eligibility criteria
Candidates who are interested in taking admission to the Excel for Data Analysis course do not require any eligibility or prerequisites to take admission to this course.
Certificate Qualifying Details
Candidates must complete all the Excel for Data Analysis course topics and appear in the online assessments of the course. At the completion of the course, candidates will get a completion certificate of the Excel for Data Analysis training course.
What you will learn
Through the Excel for Data Analysis course, candidates will be able to:
- Use Microsoft Excel to perform data analysis and use different functions and formulas in excel to combine data and keep it well-structured.
- Along with this, learners will learn the role of rows, columns, and tables in the excel sheet and how it helps in keeping big data in a tidy manner.
- Candidates will learn to create databases and how to organise databases for the organisation.
- Candidates will develop key skills such as Microsoft excel skills, management skills, data analysis skills, etc.
- Candidates will also learn to use DB Browser for SQLite and Microsoft Excel in order to complete the Excel for Data Analysis certification course syllabus.
Who it is for
Data Analysts - This course will help data analysts to improve their qualitative and quantitative skills based on data analytics. Also, they will use excel software in order to manage big data for the organisation.
Business Analysts - This course will help learners who are interested in becoming business analysts and are willing to work with any organisation. This course will help them to gather important information about the use of excel to manage data.
The Excel for Data Analysis Online Course will prove beneficial to learners who are starting fresh in their careers in data analysis. After completing this course, professionals will gain data analytics skills.
Admission details
- Candidates who are interested in taking admission to the Excel for Data Analysis course must visit the FutureLearn portal and register using this link - https://www.futurelearn.com/courses/data-analytics-for-business-creating-databases.
- After opening the link, click on the register button. This will redirect candidates to the registration page of the portal.
- Next, candidates have to provide all the necessary details for the registration such as the candidate’s full name, age, email id and set up a password for the portal.
- Use the same email id and password to log in to the FutureLearn portal.
- Find the Excel for Data Analysis training course and enroll in it.
The syllabus
Week 1: Statistics in Excel
Week 2: Data wrangling in Excel
- Introduction to data wrangling in Excel
- Importing and tidying data in Excel
- Wrangling data in Excel
- Wrap-up
Week 3: Transforming data in Excel
- Introduction to transforming data in Excel
- Transforming, sorting, and filtering data in Excel
- Creating pivot tables
- Wrap-up
Week 4: Visualising data in Excel
- Introduction to visualising data in Excel
- Data visualisation
- Exploratory data analysis
- Wrap-up
How it helps
The benefits of the Excel for Data Analysis certification course are:
- Candidates will learn to perform basic data analysis in Microsoft Excel.
- Along with this, they will try to keep the big data of the organisation in a well-structured manner. So, it will be easy for the candidates to use and manage data.
- Candidates will be able to identify the correct ERD for the database and learn to create databases and import tables using SQLite software.
- Candidates will get the completion certificate of the Excel for Data Analysis training course which will help them to boost their current job profiles or find better job opportunities in different sectors.
Instructors
Mr Jacques Haasbroek
Data Analyst
Freelancer
FAQs
The Excel for Data Analysis online course is a four- weeks training course in which learners will learn to use excel to perform data analysis.
The Excel for Data Analysis online course will be taught by Jacques Haasbroek, who is a certified data analyst.
Candidates who are interested in taking admission to the Excel for Data Analysis course do not need any prerequisites to take admission in the course.
Classes for the Excel for Data Analysis course will be conducted in online mode on the FutureLearn portal. The classes will consist of interactive sessions, doubt sessions and online assessments of the course.
Candidates who are willing to take admission to the Excel for Data Analysis online course are required to register on the FutureLearn portal using this link - https://www.futurelearn.com/courses/data-analytics-for-business-creating-databases.