Companies Home Search Profile

Microsoft Excel: Microsoft Excel for Data Analysis

Focused View

1:33:20

0 View
  • 1. The Concept of Data Analysis.mp4
    08:03
  • 2. Microsoft Excel Interface and Basic Functions.mp4
    08:09
  • 1. Power Query for Data Cleaning.mp4
    17:46
  • 2.1 Data Cleaning with Excel Functions.xlsx
  • 2. Excel Formulas and Functions for Data Cleaning.mp4
    09:32
  • 1.1 Excel Formulas and Functions.xlsx
  • 1. Data Analysis with Excel Formulas and Functions.mp4
    24:51
  • 2.1 Excel F&F Answer.xlsx
  • 2.2 Excel F&F Questions.xlsx
  • 2. Exercises on Excel Formulas and Functions.mp4
    01:46
  • 3.1 Data Analysis with Pivot Tables.xlsx
  • 3. Data Analysis with Pivot Tables.mp4
    14:56
  • 4.1 Pivot Table Answers.xlsx
  • 4.2 Pivot Tables Assignment.xlsx
  • 4. Exercise on Pivot Tables.mp4
    01:19
  • 1.1 Forecasting Sheet.xlsx
  • 1. Forecasting for Analyzing and Predicting Future Results.mp4
    06:58
  • Description


    Learn How to Use Pivot Tables, Power Query, Excel Formulas and Functions for Data Analysis.

    What You'll Learn?


    • Data Analysis with Pivot Tables
    • Microsoft Excel Functions and Formulas
    • Data Analysis with Power Query
    • Excel Dashboard Creation
    • The Concept of Data Analysis
    • Linear Regression for Predictive Analysis

    Who is this for?


  • Aspiring Data Analyst
  • Business owners
  • What You Need to Know?


  • Basic Microsoft Excel Knowledge
  • Microsoft Excel 2016 and above
  • More details


    Description

    Unlock the Power of Data Analysis with Microsoft Excel

    Are you ready to embark on the exciting world of becoming a Data Analyst? Microsoft Excel is the skill you need to get started as a Data Analyst.

    Learning Python as a beginner will be a wrong move for you. What you need, is a deep understanding of the Microsoft Excel techniques needed to conduct Comprehensive Data Analysis. Excel is the bedrock of data analysis. Whether you're an aspiring data analyst or an experienced professional, Excel remains a must-have skill for data analysis.

    With Excel, you can dive deep into your data, uncover hidden insights, create compelling visualizations, and make informed decisions.

    This course is designed to take you from Excel novice to Excel pro. I covered everything you need to master this essential tool:

    • Data Cleansing: You will learn how to clean and prepare data for analysis using Power Query and Excel formulas and functions.

    • Advanced Formulas: This course dive deep into Excel's functions and formulas, making complex calculations a breeze.

    • Pivot Tables: You will learn how to create dynamic summaries and gain new insights from your data.

    • Data Visualization: You will learn how to unleash the power of Excel's charts and graphs to tell compelling data-driven stories.

    • Real-world Projects: This course comes with real-world data analysis projects to put what you have learned into action.

    • Forecasting: You will learn how to predict future outcomes using linear regression and other Excel in-built features.

    By the time you finish this course, you will have an idea of the first thing to do when you are given a dataset to analyze, you will know how to filter, sort, and clean data using Power Query and Excel Functions.

    The skills you will learn in this course will help you to understand SQL, Power BI and Python easily.

    I look forward to seeing you on the other side!

    Who this course is for:

    • Aspiring Data Analyst
    • Business owners

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 9
    • duration 1:33:20
    • Release Date 2024/10/31