Microsoft Excel: Beginner to Intermediate Data Analysis

Microsoft Excel: Beginner to Intermediate Data Analysis

English | 02:12:41 | Video 720p | Subtitles

Learn Data Analysis, Formulas, and Pivot Tables. Data Analysis in Microsoft Excel for Beginners and Intermediate users


 

What you'll learn

How to create Pivot Tables to quickly summarize data

How to use VLOOKUP and INDEX/MATCH to pull out specific info from large data sets

How to use basic math/statistical functions like SUM, AVERAGE, COUNTIFS, and more...

How to build conditional statements using the IF() function

How to organize data to be scalable and easily used other data analysts

How to move around Excel quickly and efficiently

How to sort and filter data based on specific criteria

How to streamline your data analysis workflow in Excel

 

Requirements

Microsoft Excel for PC (2013 or later recommended. Some features may not be available in earlier versions)

Some prior knowledge of Excel will be helpful.

 

Description

This course will teach you to go from level up from beginner to intermediate in Excel in around 2 hours. You'll learn a wide variety of important Excel features, including Pivot Tables, sorting and filtering, keyboard shortcuts, as well as intermediate functions like VLOOKUP, INDEX & MATCH, IF statements, and many more (2016 PC Version used in course). 

Sample data sets provided for you to follow along and learn as you watch!

 

Who this course is for:

Job seekers who want to add "Microsoft Excel" as a skill on their resume or Linkedin Profile

Aspiring Data Analysts, Managers, or employees that anticipate using MORE data in the future

Anyone already in a job/career that involves data who wants to level up their skills in Excel

Anyone who wants to learn how to cut hours off of their weekly reporting tasks

Anyone who wants to learn how to learn excel for budgeting, side projects, or as an additional skill

 

Homepage:

https://www.udemy.com/course/microsoft-excel-for-data-analysis/

 

 

Microsoft Excel: Beginner to Intermediate Data Analysis


 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.


 Solid   |  

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