Mastering Data Analysis in Excel

Unlock the power of Excel to utilize its analytical tools from Vlookup to Pivot Table - no matter your experience level
4.44 (558 reviews)
Udemy
platform
English
language
Data & Analytics
category
Mastering Data Analysis in Excel
6 462
students
5 hours
content
Sep 2022
last update
$69.99
regular price

What you will learn

Learn different techniques for data analysis that can be easily implemented in Excel 2010, 2013, 2016, and 2019

Transform Data into insight using powerful methods of analysis, techniques and tools

Bring your skills of Excel from Beginner or Intermediate levels to Expert level

Work with real-world data sets and solve real-world tasks

Learn 60+ frequently used functions in Excel (Logical, Text, Date, Math, Statistical, Financial)

Execute aggregation commands (SUM, COUNT, SUBTOTAL, etc.) and their conditional variants (SUMIFS, COUNTIFS, AVERAGEIFS, etc.) to summarize data sets

Combine data from multiply worksheets by VLOOKUP, INDEX and MATCH functions

Perform scenario and sensitivity analysis by Goal Seek, Data Table and Scenario Manager tools

Learn best practices for data analysis and data presentation using PivotTable and PivotChart tools

Perform statistical analysis by using Data Analysis ToolPak including Linear Regression

Learn best practices for the design and setup of interactive dashboards

Work in Excel faster by using hot key shortcuts

Course Gallery

Mastering Data Analysis in Excel – Screenshot 1
Screenshot 1Mastering Data Analysis in Excel
Mastering Data Analysis in Excel – Screenshot 2
Screenshot 2Mastering Data Analysis in Excel
Mastering Data Analysis in Excel – Screenshot 3
Screenshot 3Mastering Data Analysis in Excel
Mastering Data Analysis in Excel – Screenshot 4
Screenshot 4Mastering Data Analysis in Excel

Charts

Students
Price
Rating & Reviews
Coupons Issued
Enrollment Distribution
2263844
udemy ID
10/03/2019
course created date
16/06/2019
course indexed date
Bot
course submited by
Mastering Data Analysis in Excel - Coupon | Comidoc