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 Excel's 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 Excel's 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 Excel's 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 Excel's application to data analytics
• Beginner Excel users
• Students who want to understand the different formulas and applications present in Excel