Excel Data Analysis Training

Excel Data Analysis Training

Course Details

  • Modules :                                                                                                     6
  • Projects :                                                                                                   10
  • Eligibility :                                                                                       HSC/SSC
  • Learning Mode :                                                           Online / Classroom
Enroll Now


ONLINE COURSE


CLASSROOM COURSE

INTRODUCTION

In this course you will learn – Descriptive Statistics in Excel, Central Tendency, Mean Mode Median, Dispersion, Standard Deviation, Data Analysis Tool, Central Tendency and Dispersions using Data Analysis, Correlation, and regression, Histogram using Data Analysis, Moving Averages using Data Analysis.

CURRICULUM

Before we talk about the target audience, prerequisite, FAQs, let’s look at the each module of this Excel Data Analysis Course briefly –

Sr. No. Course Name Duration Course Description
1 Microsoft Excel Course – Beginners 3 This is the first module of the entire Excel Data Analysis Course. And as you can expect, we will start with a brief overview of the MS Excel. Then, we will start with a case study so that showing you how things work would be easier. We will talk about calculations, formulas, updating a calculation, percentages & absolute references, conditional formatting, IF function, charts & graphs etc. You will also learn about common errors and shortcuts. This entire module will need you to watch 30 videos in total.
2 Microsoft Excel – Advanced  6 We will start this module will the key differences between MS Excel 2007 and MS Excel 2010. Then, we will talk about the most important & useful excel functions, data functions, what-if analysis, arrays, functions for working with text, pivot tables, names & dynamic range, advanced charts etc. You need to watch 61 videos in total to cover this entire module.
3 Gantt Chart Tutorials 1 This Excel Data Analysis Course module is an exclusive module for the course. In this module, we will begin with a brief overview of the Excel Gantt Chart. Then, we will talk in length about data series, e.g. inserting a new chart, performing on Red Data Series, data formatting series etc. You need to watch 7 videos in total to cover this module.
4 Power Excel Training 5 In this module, we will start with an introduction to the power excel training. Then, we will talk about functions, pivot table, date & time format, statement & VLookup, Future Value Function, Business Information etc. This entire module will need you to watch 47 videos in total.
5 Microsoft Excel Reports 9 As we always start, we start this Excel Data Analysis Course with a brief introduction to the excel reports. Then, we will talk about the shortcut function, excel functions, vertical lookups, financial function, and average if function. You need to watch 56 videos in total.
6 Microsoft Excel Simulations Training 2 We will start this module with an introduction to excel simulations and general tips on modeling in excel. Then, we will talk about the data simulation, goal-seek, table simulations, data validation & macro filters, and Monte Carlo Simulations. You need to watch 19 videos in total to cover the Excel Data Analysis Course.
7 Business Intelligence using Microsoft Excel 5 We will begin this Excel Data Analysis Course with an introduction to business intelligence and sorting in business intelligence. Then, we will talk about filtering, conditional formatting, checklist demonstration, data charts, pivot table, and calculated fields & data table. You need to watch 35 videos in total to cover the entire module.
8 Pivot Table 1 In this module, we will begin with an introduction to the pivot table. Then, we will talk in length about features, formatting, and questions. You need to watch 9 videos in total.
9 Microsoft Excel for Data Analyst 3 We will begin this module with an introduction to advanced data sorting, how to use data & sort and also with advanced data filtering. Then, we will go in detail about conditional formatting & cell referencing, VLookup, HLookup, Index & Match, and pivot table and advanced excel tricks. You need to watch 14 videos in total to cover the entire module.
10 Building Dynamic Heat Map in Microsoft Excel 2016 1 In this Excel Data Analysis Course module, we will start with a brief overview of the heat map. And we will also go in detail with an example. Then, we will teach you the formatting rules for dynamic heat map. Next, you will learn about how to use sales data, how to use channel, and finally, we will look at the reference files. The entire module will need you to watch 9 videos.
11 Statistical Tools in Microsoft Excel  1 We will again start with a brief introduction. Then, we will teach you descriptive statistics – the central tendency, dispersion, standard deviation, data analysis tool, descriptive statistics, histogram using data analysis, moving averages using data analysis, and finally, you will learn about statistical tools in excel. This entire Excel Data Analysis Course module will need you to watch 12 videos in total.

TARGET AUDIENCE

  • Students: If you’re a graduate or undergraduate student, this course will help you level up. No matter what profession you would choose in the near future, you would need MS Excel and at the same time, you would also need the data analysis skill. Well, you will get both of these in this Excel Data Analysis Course.
  • Professionals: No matter what profession you are in if you need to use MS Excel at a basic or at an advanced level, this Excel Data Analysis Course is for you. Just dive in, learn the lessons at your convenience, and work on them. You would be way ahead than the crowd.
  • Entrepreneurs: Many entrepreneurs struggle with the data analysis. If you’re someone who has a business and you feel that you should brush up your data analysis skill, this is the best course you would ever find in the market.

Alert: You are not allowed to copy content or view source !!