Welcome to Our Introduction to Data Analytics Course!
You are here reading this because you have been nurturing a desire to become a Data Analyst, but you hadn’t known how to get there. Well, this course was designed for you.
Course Overview
This course introduces the fundamentals of Data Analytics and advanced Excel functionalities used in aggregating data to make it ready for analysis. You will learn how to quickly summarize data into meaningful and insightful information using a Pivot Table.
Why This Course?
Research shows that close to 60% of Excel users leave 80% of Excel’s powerful analytics tools untouched. The Pivot Table, perhaps the most powerful of all MS Excel tools, is arguably one of the least used and known features. It enables you to see your data from different perspectives and create interactive views of your data sets called Pivot Table reports.
What You’ll Learn
• Fundamentals of Data Analytics: Understand the basics and importance of data analytics in today’s data-driven world.
• Advanced Excel Functionalities: Master advanced Excel tools and techniques for data aggregation and preparation.
• Pivot Tables: Learn how to use Pivot Tables to create interactive views of your data and generate insightful reports.
What’s Included
• Downloadable Sample Files: Access files to practice with during and after the training.
• Best Practices: From beginner to advanced level, distilled into easy-to-understand patterns that you can instantly apply to your business/work.
• Completion Certificate: Receive a certificate upon completing the course.
Why Wait?
Don’t miss this heavily discounted course! Get ready to transform your career and become a proficient Data Analyst with skills that are in high demand!
Course Features
- Lectures 35
- Quizzes 0
- Duration 52 weeks
- Skill level All levels
- Language English
- Students 1077
- Certificate Yes
- Assessments Yes
Curriculum
- 1 Section
- 35 Lessons
- 52 Weeks
- Introduction to Data Analytics35
- 1.1Introduction
- 1.2Course Materials
- 1.3Understanding Data Types
- 1.4Determining the Proper Date Entry
- 1.5Different Types of Datasets
- 1.6Categories of Databases
- 1.7Structures of Databases
- 1.8Normalising Databases – How to remove Duplicates
- 1.9Performing The VLOOKUP Formula to De-Normalise Databases
- 1.10Performing The VLOOKUP Approximate
- 1.11Performing The HLOOKUP
- 1.12The MATCH function
- 1.13The INDEX and MATCH function
- 1.14The XMATCH function
- 1.15The XLOOKUP function
- 1.16The IF function
- 1.17The AND function
- 1.18The OR function
- 1.19The Nested IF-AND-OR function
- 1.20Number Formating
- 1.21Deleting Named Ranges and Table Properties
- 1.22The Pivot Table Layout
- 1.23Getting Data ready for Analysis
- 1.24My First Report
- 1.25Two Dimensional Report
- 1.26Multi Dimensional Report
- 1.27Creating reports that involve COUNT, AVERAGE, MAX and MIN
- 1.28Formating your Report
- 1.29Turning your pivot table into a final report
- 1.30Applying Filters to your Report
- 1.31Performing Magic with the Filters
- 1.32Introduction to Slicers
- 1.33Formatting your Slicers
- 1.34Creating Reports From Recommended Pivot Tables
- 1.35Quick Analysis Tool Completed
