Coursera Bets $100 Million That Andrew Ng Can Do What Coursera Can’t

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

VDCI

Excel for Data Analytics

via VDCI

Go to class Write review

Overview

Take your data analysis abilities further with our Excel for Data Analytics course. You'll master key functions, formulas, and powerful techniques such as Pivot Tables and VLOOKUP. Through practical, real-world exercises, you'll build the skills to streamline your workflow and handle data with greater speed and confidence.

Syllabus

Excel Level I: Fundamentals

  • Learn how to use functions to speed up your workflow
  • Add formatting and other visual effects
  • Turn data into visual charts, including line, column, and pie charts
  • Learn tips and tricks for easy workbook management

Excel Level II: Intermediate

  • Learn to split and join text, add data validation, and named ranges
  • Use database functions and logical statements
  • Create Pivot Tables to quickly summarize large databases
  • Create advanced combo charts from multiple charts

Excel Level III: Advanced

  • Cell management, including cell locking, auditing, and hot keys
  • Special formatting for calculating dates
  • Use advanced functions and advanced analytical tools
  • Record macros and relative reference macros for ad hoc reporting

Taught by

Garfield Stinvil, Colin Jaffe, and Brian McClain

Reviews

Start your review of Excel for Data Analytics

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.