Microsoft Excel: Data Analysis with Excel (Updated)
- Description
- Curriculum
- FAQ
- Reviews
Learn Data Analysis with Microsoft Excel as a Data Analyst.
If you are ready to begin your journey to becoming a Data Analyst, here is it. Minimum technical skills required to get an entry-level job as a data analyst are;
1. Microsoft Excel
2. SQL
3. Power BI or Tableau
With these technical skills, you can gain an entry level data analyst job in any organization. So, I want to help you get started with my Data Analysis with Microsoft Excel course.
Here’s what you are getting:
The Concept of Data Analysis:
In this lesson, you will learn the concept of data analysis. You will get to know, who is a data analyst, what is data analysis, what does a data analyst do and a lot of other things.
Data Analysis with Pivot Table:
In this lesson, you will learn how to use pivot tables to analyze data. You will learn how to insert pivot tables and how to use recommended pivot tables.
You will learn what filter, column, rows and values mean and how to use them to analyze data in a pivot table.
Excel Formulas and Functions for Data Analysis:
In this video lesson, I covered some of the most important Microsoft Excel functions and formulas used as a Data Analyst for analyzing data. I covered functions like VLOOKUP, XLOOKUP, SUMIFS, INDEX, INDEX MATCH, IF function, and other functions.
Data Cleaning:
You are not a data analyst if you don’t know how to clean data. In this lesson, you will be taught how to clean data using Microsoft Excel functions and Power Query.
Forecasting and Predicting Future Results:
In this lesson, you will be taught how to predict and forecast sales for any given company.
And much more.
Projects are one of the most important steps you take when becoming a data analyst. It is a great way to improve your resume and showcase your skills. Project is one way to tell if you can call yourself an expert in analyzing data with Excel. That’s why I attached two projects to this course.
So, at the end of this course, you are expected to do two projects and submit for assessment. You will be given the datasets and requirements for the analysis. I look forward to seeing what you can do using Excel after the completion of this course.
Certificate is only awarded to students after completion of these projects.
I look forward to your first assignment. Yes, some of the lessons above come with assignment to get your hands dirty and test you.
Joseph Okon
-
1
The Concept of Data AnalysisIn this lesson, I talked about the concept of data analysis. I covered the following areas;
1. What is data analysis?
2. Who is a data analyst?
3. The 5 stages of data analysis.
This particular lesson is for those who are new to data analysis so they get to learn what data analysis entails before learning how they can use Microsoft Excel for data analysis.
-
2
Data Analysis with Pivot Tables
In this lesson, you will learn how to use Pivot Tables to analyze data. You will learn what filters, rows, columns and values mean and how to use them to analyze data in a Pivot Table.
-
3
Maple Enterprises Analysis
You can download the data set from the Resources box below.
-
4
Excel Functions for Data Analysis
In this lesson, I covered some of the most important excel functions and formulas used for data analysis. I covered functions like VLOOKUP, XLOOKUP, SUMIFS, INDEX, COUNTIF, INDEX MATCH, IF and other functions.
-
5
Data Consolidation
When you're given a task to compile excel sheets dated to more than 5 years into a master sheet, you only have one way you can easily achieve that, and that is with data consolidation.
In this lesson, you will learn how you can compile old records of multiple excel sheets into a master sheet in just few minutes.
-
6
Linear Regression Analysis
In this lesson, you are going to learn how to use a statistical tool in Excel to check the relationship between two sets of data or variables. You will learn how to predict the value of a variable based on the value of another variable.
-
7
Forecasting for Analyzing and Predicting Future Results
In this lesson, you will be taught how to predict and forecast future sales for any given company.
-
8
Data Cleaning with Power Query
Do you know how to clean data in Power Query? In this video tutorial, I shared 6 ways to clean data in excel with power query.
You will learn how to use power query to clean and transform data in excel. If you have a dataset and need to perform data analysis in excel, you need to clean your data. With power query in excel, you can clean, transform and automate the entire process.
-
9
Data Visualization in Excel
In this lesson, you will be taught how to create excel charts and build an interactive dashboard that tells your findings.
-
10
Data Analysis Report Writing
In this lesson, I talked about how to write a report as a Data Analyst.
