Free download » Free download video courses » Learning Office » Data Analysis with Microsoft Excel (2022)
  |   view 👀:34   |   🙍   |   redaktor: Baturi   |   Rating👍:

Data Analysis with Microsoft Excel (2022)

Data Analysis with Microsoft Excel (2022)
Published 12/2022
Created by Joseph Okon
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 11 Lectures ( 3h 36m ) | Size: 1.68 GB


Data Analysis Excel Course for Beginners
What you'll learn
The Concept of Data Analysis
Analyzing Data Using Pivot Table and Pivot Charts
Excel Functions and Formulas for Data Analysis
Data Consolidation Function in Excel
Forecasting in Excel for Analyzing and Predicting Future Results
Data Cleaning in Microsoft Excel
Creating an Interactive Dashboard in Microsoft Excel
How to Write a Report as a Data Analyst
Requirements
No computer or coding knowledge needed.
This is the foundational course you need to start your journey as a Data Analyst.
Description
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 Excel2. SQL3. Power BI or TableauWith these technical skills, you can gain an entry level data analyst job in any organization. So, I want to help you get started with Microsoft Excel with my course.Here's what you are getting: The Concept of Data Analysis:In this lesson, you will learn the basic 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.Pivot Table and Pivot Charts:In this lesson, you will be walked through how to import data into an excel worksheet and how to answer and analyze data using pivot tables. Excel Functions and Formulas:In this video lesson, I covered some of the most important excel functions and formulas used as a Data Analyst for analyzing data. I covered functions like 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 Excel function and Power Query. Forecasting and Predicting Future Results:Forecasting in Excel for Analyzing 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
Who this course is for
This course is for aspiring data analyst who want to learn from the very beginning.
Homepage
https://www.udemy.com/course/data-analysis-with-microsoft-excel/




Please Help Me Click Connect Icon Below Here and Share News to Social Network | Thanks you !

In today's era of digital learning, access to high-quality educational resources has become more accessible than ever, with a plethora of platforms offering free download video courses in various disciplines. One of the most sought-after categories among learners is the skillshar free video editing course, which provides aspiring creators with the tools and techniques needed to master the art of video production. These courses cover everything from basic editing principles to advanced techniques, empowering individuals to unleash their creativity and produce professional-quality content.

Comments (0)

Information
Users of Guests are not allowed to comment this publication.