Excel in the World of Data Analytics

Excel in the World of Data Analytics, available at $54.99, has an average rating of 4.05, with 20 lectures, 12 quizzes, based on 72 reviews, and has 304 subscribers.

You will learn about 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! This course is ideal for individuals who are Students wanting to learn about Excels application to data analytics or Beginner Excel users or Students who want to understand the different formulas and applications present in Excel It is particularly useful for Students wanting to learn about Excels application to data analytics or Beginner Excel users or Students who want to understand the different formulas and applications present in Excel.

Enroll now: Excel in the World of Data Analytics

Summary

Title: Excel in the World of Data Analytics

Price: $54.99

Average Rating: 4.05

Number of Lectures: 20

Number of Quizzes: 12

Number of Published Lectures: 20

Number of Published Quizzes: 12

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: ￡99.99

Quality Status: approved

Status: Live

What You Will Learn

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!

Who Should Attend

Students wanting to learn about Excels application to data analytics

Beginner Excel users

Students who want to understand the different formulas and applications present in Excel

Target Audiences

Students wanting to learn about Excels application to data analytics

Beginner Excel users

Students who want to understand the different formulas and applications present in Excel

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 interfacein 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!

Course Curriculum

Chapter 1: Course Structure

Lecture 1: Course Structure

Chapter 2: Introduction

Lecture 1: Introduction to the Course

Chapter 3: Navigation

Lecture 1: Navigation in Excel

Chapter 4: Entering Data

Lecture 1: Entering Data in Excel

Chapter 5: Simple Formulae

Lecture 1: Simple Formulae

Chapter 6: Cell Referencing

Lecture 1: Cell Referencing

Chapter 7: Conditional Formulae

Lecture 1: Conditional Formulae

Lecture 2: Bonus Lecture A: Conditional Formulae

Lecture 3: Bonus Lecture B: Conditional Formulae

Chapter 8: Referencing Worksheets

Lecture 1: Referencing Worksheets

Chapter 9: Graphs

Lecture 1: Graphs: Data Visualisation

Chapter 10: Filtering Data

Lecture 1: Filtering Data

Chapter 11: Named Ranges

Lecture 1: Named Ranges

Chapter 12: Conditional Formatting

Lecture 1: Conditional Formatting

Chapter 13: String Formulae

Lecture 1: String Formulae

Lecture 2: Bonus Lecture: String Formulae

Chapter 14: Date Formulae

Lecture 1: Date Formulae

Chapter 15: Lookups

Lecture 1: Lookups

Chapter 16: Pivots

Lecture 1: Pivots

Chapter 17: End of Course!

Lecture 1: Congratulations!

Instructors

Data Civilisation
Technology-based analytics company

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 10 votes

4 stars: 25 votes

5 stars: 36 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!