Data Analysis with Excel

Excel tools for improve productivity and analytical skills

3.55 (41 reviews)
Udemy
platform
English
language
Other
category
instructor
Data Analysis with Excel
2,250
students
10.5 hours
content
Aug 2018
last update
$39.99
regular price

What you will learn

Create dashboards

Make decisions supported by data

Organize personal and business data

Description

This course will guide you from the basics of MS Excel to advanced topics using simulated cases to demonstrate how to use the of features of software and when is suitable. Knowing how analyze data is necessary skill for activities and with this course you learn the tools that Excel provides you to face the challenges related to planning, forecasting, budgeting, decision making, modelling and all the tasks that can be done using data analysis. Instructor has more than 10 years of experience working with MS Excel.

Content

Introduction

Introduction

Interface

Interface Intro
Interface: status bar
Status Bar
Interface: formula bar
Formula Bar
Interface: quick access
Interface: ribbon
Interface: options
Interface: tabs
Interface: keyboard shortcuts
Keyboard Shortcuts

Data

Data Intro
Data: manual input
Data: copy data
Data: import data
Data: sort and filter
Sort and filter
Data: paste data

Layout

Layout Intro
Layout demonstration
Layout: format as table
Layout: cell format
Layout: conditional formating
Layout: sparkline

Formulas

Functions Intro
Functions: manual and built-in functions
Manual formula
Functions: function assistant
Functions: function library
Functions: countif
Functions: nestedif
Functions: vlookup and sumif
Functions: auditing
Functions: auditing 2

Charts

Charts Intro
Charts demonstration
Create chart
Pie Chart
Column Chart
Bar Chart
Line Chart
Area Chart
Radar Chart
Scatter Chart
Histogram Chart
Tree Map Chart
Combo Chart
Style charts 1
Style charts 2
Style charts 3
Export charts
Warning

Pivot Table

Pìvot Table intro
Creat Pivot table
Layout
Layout options
Summary of values
Show values
Subtotals
Analyze
Design
Pivot Chart

Forecast

Forecast Intro
Goal Seeker
Scenario Manager
Data table
Forecast Sheet

Macro

Macro Intro
Record macro
View macros and relative reference
Macro editor
Macro shortcuts

Reviews

Omkalthoum
January 30, 2023
from my own experience which is almost related to the statistics, data classification I consider this course is an important course that can help me to read and analyze the data which is lead to get better result in shorter way.
Kostas
July 26, 2018
Boring repetitive slow presentation of basic material. You can find more concise tutorials in youtube with more advanced staff.

Charts

Price

Data Analysis with Excel - Price chart

Rating

Data Analysis with Excel - Ratings chart

Enrollment distribution

Data Analysis with Excel - Distribution chart
1717800
udemy ID
5/28/2018
course created date
2/18/2020
course indexed date
Bot
course submited by