Excel - Become a Professional Data Analyst

Learn all the Tools and Techniques for Data Analysis using Excel software. Get the Fundamentals right, and Build your Career.

Beginner 5(8 Ratings) 103 Students enrolled English
Created by Pegon Academy
Last updated Fri, 26-Jan-2024
+ View more
Course overview

Data analysis is a process of inspecting, cleaning, transforming, and modeling data with the purpose of discovering useful information, and informing conclusions, that will support data-driven decision-making.

It is essential that every organization has a competent data analyst if they must optimize their business performance.

In this course, you'll be learning how to analyze data using Excel.

This course comprises of Comprehensive video tutorials, Excel software, Practice exercise files, and continuous mentorship.

It’s going to be a long journey of learning, unlearning, and re-learning. We are going to move together.

Once, you purchase this course, you will automatically have access to the step-by-step video tutorials, Excel software, and practice exercise files.

So first, you would need to watch the video lessons and practice along-side.

So let’s journey on, click the Start Course button above to purchase the course and get started.

What will i learn?

  • What Data Analysis is all about
  • Using Excel Spreadsheet - All Features
  • Sites to Collect Practice DataSets
  • Preparation & Cleaning of Raw Data for Use
  • Formulas, Filters & Tables to Analyze Data
  • Creating & Using Pivot Tables in Excel
  • Create Dashboards in Excel
  • Creating Slicers & Using them
  • Using Conditional Formatting
  • Answer Real Life Data Questions
Requirements
  • A basic computer
  • No prior knowledge required
Curriculum for this course
10 Lessons 00:00:00 Hours
MODULE 1 - Introduction
4 Lessons 00:00:00 Hours
  • Introduction to Data Analysis
    .
  • Microsoft Office (Excel) Software and Installation Guide
    .
  • Introduction to Data
    .
  • Introduction to EXCEL spreadsheet - Excel Basics
    .
MODULE 2 - All Practice Exercise Files in this Course
1 Lessons 00:00:00 Hours
  • All 3 Practice Exercise files
    .
MODULE 3 - Data Cleaning
1 Lessons 00:00:00 Hours
  • Data Preparation and Cleaning
    .
MODULE 4 - Projects
2 Lessons 00:00:00 Hours
  • Data Analysis - Project 1
    .
  • Data Analysis - Project 2
    .
MODULE 5 - Data Visualization
1 Lessons 00:00:00 Hours
  • Visualizing and Presenting your Data
    .
MODULE 6 - Your Project
1 Lessons 00:00:00 Hours
  • Your Final Project to receive your Certification
    .

Frequently asked question

Do I need a computer?
Yes! you need a computer for effective practicing.
What is the course made up of?
✅ Step-by-step video lessons, ✅ Practice exercise files, ✅ Excel software - 2019 version and Installation Guide, ✅ Lifetime Mentorship, ✅ Certificate.
+ View more
Other related courses
00:00:00 Hours
Tableau and PowerBI - Become a Professional Data Analyst
Updated Fri, 26-Jan-2024
3 42 ₦30000 ₦5000
00:00:00 Hours
Python and MySQL - Become a Professional Data Analyst
Updated Thu, 25-Jan-2024
4 42 ₦30000 ₦5000
About instructor

Pegon Academy

19 Reviews | 250 Students | 10 Courses
Digital Courses
Student feedback
5
8 Reviews
  • (0)
  • (1)
  • (0)
  • (2)
  • (5)

Reviews

  • Ashams Timi
    Great course. I learnt a lot of new things I never knew Excel could do
  • Eric Joe
    The instructor is really good. She takes her time to slowly explain the concepts. Even though I'm not a beginner, there was still alot I learnt in this course, kudo to her
  • Victor David
    I really needed this course for my job. I use Excel alot. Thanks Pegon Academy for the opportunity
  • Derrick Nyumah
  • Gotau Israel
    the lecture made it easy to understand
  • ISAGBA EDNA NKEONYEASUA
  • Okolie Emeka Franklin
  • Abdallah Issahaku
Preview this course
₦30000 ₦5000
Includes: