Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Excel in the World of Data Analytics

Learn how to conduct data analysis in Excel and get meaningful insights!
4.4
☆☆☆☆☆ 4.4/5
(60 reviews)
254 students
Created by
Data Civilisation

8.7

Classbaze Grade®

7.1

Freshness

9.2

Popularity

9.2

Material

Detailed Analysis »

Learn how to conduct data analysis in Excel and get meaningful insights!
Go to course »
Platform: Udemy
Price: check current price
Video: 4h 26m
Language: English
Next start: On Demand

Best Data Analysis classes:

Skillshare_logo_2020
Best Data Analysis classes on Skillshare »
Coursera Logo
Best Data Analysis classes on Coursera »
Pluralsight Logo
BestData Analysis classes on PluralSight »
Udemy logo
Best Data Analysis classes on Udemy »
linkedin
Best Data Analysis classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

8.7 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

7.1 / 10
This course was last updated on 12/2019.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

9.2 / 10
We analyzed factors such as the rating (4.4/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

9.2 / 10
Video Score: 8.2 / 10
The course includes 4h 26m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 4 hours 49 minutes of 559 Data Analysis courses on Udemy.
Detail Score: 9.8 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
1 resources.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

Reviews
“A great, easy to follow course which provides all the knowledge you need to confidently use essential Excel functions in the corporate environment. Split into clear sections which makes it very useful to bookmark this course as a guide for future reference” – Sunny Gun
“This course really builds a strong foundation and which in turn makes the more complex excel functions to be easily understood. Coming from 5 years of experiences from professional services back ground and being through various excel training this is by far the most easily understood and value adding I have seen” – Adeel Sharif
“This course started with the very basics and continued to more advanced topics. I was already familiar with Excel but I leaned several new concepts that I can put to use. The instructor was very good.” – Disa Lee
“This course is highly recommended! The best data material I have ever seen! This course explains concepts to me in the most entertaining and easy to understand way possible. Thank you!” – Mostafa Ahmad
“Good explanation” – Balwinder Kaur
“I am brand new to Excel for data analytics! This course is providing me with a strong foundation to perform job tasks. Thank you for offering this course!” – Michelle Little
————————-
Join this course and you will work on building a strong skill set in Excel. We will start from the basics to develop a strong foundation, and we will then work through more complex functionalities, step-by-step.
This course covers topics which are used extensively in the job market, ranging from financial consulting to healthcare. Additionally, a lot of the topics in this course are actually used for interview questions for large corporations!
This course will walk you through the structure and user interface in Excel. We will then look at how to utilise a wide range of formulas which can help us analyse data sets. We will then go over at how to manipulate data and operations to create reports which show useful insights and findings. Finally, we will be visualising our results by creating graphs in Excel! This is the standard operation and process used in multiple job industries. We have tailored this course specifically to enhance your career opportunities!
So what are you waiting for? Jump right in and learn about data analysis in Excel!

What can you learn from this course?

✓ The structure of Excel and how to navigate through the user interface
✓ Entering data and understanding the different data types which can be used
✓ Mathematical operators and functions such as SUM, COUNT, MIN, MAX and AVERAGE
✓ How to utilise the different cell referencing present in Excel
✓ Introducing conditions and constraints in formulas by using functions such as IF, OR, AND, SUMIF, COUNTIF and AVERAGEIF
✓ How to work across multiple worksheets and reference them correctly in formulas
✓ How to create and modify graphs
✓ Applying simple and more complex filters on tables
✓ Naming cells and tables and utilising them in formulas
✓ How to format cells in a table based on different conditions being met
✓ Applying string formulas by applying functions such as LEFT, RIGHT, MID, LEN, UPPER, LOWER and CONCAT
✓ How to make string formulae more dynamic
✓ Understanding and applying formulas on the date data type
✓ Carrying out look ups by utilising the VLOOKUP function as well as a combination of the INDEX-MATCH formula combination
✓ How to utilise pivot tables to create meaningful reports
✓ Creating pivot charts based on the pivot tables created
✓ Quizzes to ‘test your knowledge’ as you progress through the course!

What you need to start the course?

• There are no requirements! We will be going through everything from the beginning. We just require you to have Excel installed onto your computer
• We will be going over a lot of practice exercises in this course, so you need to make sure to work along with us and go back to practice so that you master this course!
• Why not check the reviews & curriculum to see what’s in it for you?

Who is this course is made for?

• Students wanting to learn about Excel’s application to data analytics
• Beginner Excel users
• Students who want to understand the different formulas and applications present in Excel

Are there coupons or discounts for Excel in the World of Data Analytics ? What is the current price?

The course costs $14.99. And currently there is a 82% discount on the original price of the course, which was $84.99. So you save $70 if you enroll the course now.
The average price is $8.1 of 559 Data Analysis courses. So this course is -85% cheaper than the average Data Analysis course on Udemy.

Will I be refunded if I'm not satisfied with the Excel in the World of Data Analytics course?

YES, Excel in the World of Data Analytics has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Excel in the World of Data Analytics course, but there is a $70 discount from the original price ($84.99). So the current price is just $14.99.

Who will teach this course? Can I trust Data Civilisation?

Data Civilisation has created 4 courses that got 634 reviews which are generally positive. Data Civilisation has taught 18,697 students and received a 4.3 average review out of 634 reviews. Depending on the information available, we think that Data Civilisation is an instructor that you can trust.

Learn everything about

Data Civilisation

Technology-based analytics company
Data Civilisation is a technology-based analytics company, aiming to bring keen and curious learners together.
We aim to provide only the best quality content, to help our learners along their journey of becoming experienced data analysts.
Data Civilisation was founded by two data analysts who started their careers in the largest professional service consultancy firms. They work with various tools, such as SQL, PowerBI, and Python and have over ten years of combined experience in analytics.
Browse all courses by on Classbaze.
Data Civilisation's full profile and courses »
Go to class »

8.7

Classbaze Grade®

7.1

Freshness

9.2

Popularity

9.2

Material

Detailed Analysis »

Learn how to conduct data analysis in Excel and get meaningful insights!
Go to course »
Platform: Udemy
Price: check current price
Video: 4h 26m
Language: English
Next start: On Demand

Classbaze recommendations for you

Other courses by ​Data Civilisation

Go to class »