Data Analysis with Excel
Excel tools for improve productivity and analytical skills
3.55 (41 reviews)
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
Rating
Enrollment distribution
Related Topics
1717800
udemy ID
5/28/2018
course created date
2/18/2020
course indexed date
Bot
course submited by