Microsoft Excel Analytics - Data Analysis Essentials
 

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.

 

Microsoft Excel Analytics - Data Analysis Essentials


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Broknote   |  

Information
Members of Guests cannot leave comments.


SermonBox - Seasonal Collection

SermonBox - The Series Pack Collection

Top Rated News

  • Christmas Material
  • Laser Cut & Print Design Elements Bundle - ETSY
  • Daz3D - All Materials - SKU 37000-37999
  • Cgaxis - All Product - 2019 - All Retail! - UPDATED!!!
  • DigitalXModels Full Collections
  • Rampant Design Tools Full Collections Total: $4400
  • FilmLooks.Com Full Collection
  • All PixelSquid Product
  • The Pixel Lab Collection
  • Envato Elements Full Sources- 3200+ Files
  • Ui8.NET Full Sources
  • The History of The 20th Century
  • The Dover Collections
  • Snake Interiors Collections
  • Inspirational Collections
  • Veer Fancy Collections
  • All Ojo Images
  • All ZZVE Collections
  • All Sozaijiten Collections
  • All Image Broker Collections
  • Shuterstock Bundle Collections
  • Tattoo Collections
  • Blend Images Collections
  • Authors Tuorism Collections
  • Motion Mile - Big Bundle
  • PhotoBacks - All Product - 2018
  • Dekes Techniques - Photoshop & Illustrator Course - 1 to 673
Telegram GFXTRA Group
Udemy - Turkce Gorsel Ogrenme Setleri - Part 2
Videohive Wow Pack Series


rss