Udemy

Platform

English

Language

Microsoft

Category

Certificate Course on Advance MS. Excel with Data Analytics

Become Excel Expert

4.29 (21 reviews)

Certificate Course on Advance MS. Excel with Data Analytics

Students

1 hour

Content

Sep 2020

Last Update
Regular Price


What you will learn

Complete Data Entry In Excel

Get required skill & Be Job Ready


Description

Data Analysis with Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the features available in MS-Excel.

Analyzing large data sets with Excel makes work easier if you follow a few simple rules: Select the cells that contain the data you want to analyze. Click the Quick Analysis button image button that appears to the bottom right of your selected data (or press CRTL + Q). Selected data with Quick Analysis Lens button visible

Microsoft Excel is one of the most widely used tools in any industry. While some enjoy playing with pivotal tables and histograms, others limit themselves to simple pie-charts and conditional formatting. Some may create an artwork out of the dull monochrome Excel, while others may be satisfied with its data analysis.


Content

Introduction

Introduction to Excel

Introduction to Excel for Data Analysis

Microsoft Excel Basic Function

Short Cut Keys of Excel

Data formatting

Conditional Formats

Aggregate Functions and Number Functions

Lookup Functions

Lookup and hookup function

Index and Match

Data Handling

Data Validation Part 1 and Part 2

Duplicates and Transpose

Paste Special Functions

Data handling

Data Visualization

Types of charts

Population Pyramid

Data Summaries, Reports and Dashboard

Excel Final Quiz


Reviews

S
Sayara30 December 2020

Interactive Content and syllabus ,easy to understand Projects and assignment are full with information. thank you


3474174

Udemy ID

9/4/2020

Course created date

9/24/2020

Course Indexed date
Bot
Course Submitted by