Udemy – Google Sheets – Analyst training with openly shared data! [100% off]

Google Sheets - Analyst training with openly shared data!

Course Description

Save time at your job and become a whiz at Google Sheets. This course takes you from beginner level to intermediate/advanced. You’ll learn how to:

  • Create, name, share sheets
  • Format sheets, best practices
  • Conditional formatting
  • Filter and sort data
  • Use TEXT functions to clean/manipulate data
    • CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE
  • Use basic math functions, including
    • SUM
    • AVERAGE
    • COUNT
    • MIN
    • MAX
    • ROUND
  • More advanced math functions
    • SUMIFS
    • COUNTIFS
    • AVERAGEIFS
  • Create and customize charts
  • Pivot tables
  • Lookups
    • VLOOKUP, INDEX/MATCH
  • Use logical functions such as IF, OR, AND
  • Use INDIRECT and pair with INDEX/MATCH
  • Link data together from multiple spreadsheets using IMPORTRANGE

This course will give you you everything you need to know about Google Spreadsheets, an increasingly important tool and rapidly growing in the enterprise sector.

Additionally, this course will provide you with the example sheets covered, so you can follow along! How fun :)

 

Udemy Coupon Codehttps://www.udemy.com/master-google-sheets/?couponCode=freesheets

 

 

 

Share with your friends :

Comentarios

Entradas populares de este blog

Udemy – How To Start a Profitable Social Media Marketing Agency [100% OFF]

Udemy – The Secrets of Magic and Mentalism: Become a Magician [100% OFF]

Udemy – Learn Illustrator CC: Create Simple Flat Vector Characters [100% OFF]