Microsoft Excel Analytics - Data Analysis Essentials
MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 2 hours | Size: 305 MB
A step-by-step guide in Excel Analytics. Learn the Essentials of Data Analysis and Analytics with Microsoft Excel.

What Will I Learn?

Learn the ropes of Microsoft Excel. This course will learn you the essentials of Microsoft Excel. The ultimate course for beginners!
Learn some of the most frequently used formulas in Excel: COUNT, COUNTIF(S), SUM, SUMIF(S), AVERAGE, VLOOKUP, IF(S), INDEX/MATCH, CONCATENATE, TRIM.
Learn how to build a Dashboard from scratch with step-by-step exercises and customize Charts and Tables.
Improve the layout of your dashboards with Conditional Formatting and Cell Formatting.
Improve user interactivity and reporting with Sort, Filter, and Advanced Filters.
Build visually effective reports and dashboards with Pivot Charts and Pivot Tables
Improve data quality by using formula auditing and formula evaluation in Excel.
Become 5X Faster. Learn tips and tricks for using shortcuts in Excel and improve your everyday productivity and efficiency.

Requirements

Some basic knowledge of Microsoft Excel would be helpful, but is not a prerequisite for following this course.
Interest in learning Excel.

Description

Learn the essentials of Microsoft Excel Analytics through this step-by-step course. The Data Analytics with Microsoft Excel course takes you through the basics of Excel Analytics, but also introduces some more advanced topics like advanced filters, pivot charts and pivot tables. The course also learns you some, shortcuts, tips and tricks for improving your productivity in working with Excel.

Learn to build a dashboard from scratch!

Shorcuts can boost your productivity up to 5X.. and improve improve your efficiency in building dashboards!

The course contains training materials, where you can practice, apply your knowledge and build a dashboard from scratch. The training materials are provided in an Excel file that you can download to your computer. Each module also ends with a short quiz and there is a final quiz at the end of the course.

Good luck and hope you enjoy the course.

Pre-requisites:

Some basic knowledge of Microsoft Excel Analytics

Course content:

The course consists of the following modules:

Introduction, shortcuts, tips & tricks!
Excel Basic Formulas: COUNT, COUNTIF(S), SUM, SUMIF(S), AVERAGE, VLOOKUP, IF(S), INDEX/MATCH, CONCATENATE, TRIM
Conditional Formatting and Cell Formatting
Charts and Tables
Sorting and Filtering
Pivot Charts and Pivot Tables
Final Quiz

Who should follow this course?

You should take this course if you want to learn the essentials of Microsoft Excel from scratch.
This is not a course for advanced Excel users, but for novice users that would like to broaden their knowledge of Excel.
This is an ideal course for novice Excel users that would like to take their Excel skills to the next level.
Professionals that would like to get a good knowledge of Excel, as part of their employers learning program.

Who is the target audience?

This is not a course for advanced Excel users, but for beginners that would like to broaden their knowledge of Excel.
This is an ideal course for beginners that would like to take their Excel skills to the next level.
Professionals that would like to get a better knowledge of Excel, as part of their employers learning program.
Anyone who wants to learn the absolute essentials of Microsoft Excel from scratch.