Good Course!
Data Analysis with Microsoft Excel
Complete Microsoft Excel Course for Data Analysts
Office Productivity,Microsoft,Microsoft Excel,Data Analysis
Lectures -10
Resources -8
Duration -2 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
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 XLOOKUP, VLOOKUP, HLOOKUP, SumIFs, Index, 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
Goals
- Become an Expert in Microsoft Excel as a Data Analyst
- Learn How to Predict Future Results with Microsoft Excel
- Master the art of Pivot Tables and Power Query
- Become an Expert in Creating Interactive Dashboard in Excel
Prerequisites
- Microsoft Excel 2016 and above
![Data Analysis with Microsoft Excel Data Analysis with Microsoft Excel](https://d3mxt5v3yxgcsr.cloudfront.net/courses/13944/course_13944_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Data Analysis with Excel
8 Lectures
-
The Concept of Data Analysis 12:43 12:43
-
Data Analysis with Pivot Tables 18:49 18:49
-
Maple Enterprises 01:17 01:17
-
Excel Functions for Data Analysis 27:47 27:47
-
Data Cleaning 25:51 25:51
-
Data Consolidation 10:18 10:18
-
How to Create an Interactive Dashboard as a Data Analyst 26:39 26:39
-
Data Analysis Report Writing 12:16 12:16
Projects
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Joseph Okon](https://www.tutorialspoint.com/assets/profiles/584603/profile/200_272924-1673692555.jpg)
Joseph Okon
Top-rated Tutor on Tutorials PointHello there, I am proud to be teaching here on Tutorials Point.
Feel free to reach out to me if you have any issue with any of my courses that you enroll in.
I do welcome feedback. My courses are well structured to give you the best outcome you so desire.
See you on the other side!
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)