In this course, students will learn how to use basic, intermediate and advanced Excel formulas, Flash fill, Pivot Tables and Pivot Charts, What-if analysis, logic functions, VLOOKUP and HLOOKUP.
Who Is This Course For?
beginners
What Will You Learn?
Excel 1 - basic formulas, Lab 1
Excel 2 - Lab 2, Project 1 and 2 - intermediate and advanced formulas
Excel 3 - Separate Email addresses, Flash fill, Pivot Tables and Pivot Charts, What-if analysis
How to perform VLOOKUP and HLOOKUP to access list data.
Prerequisite
basic Excel
Mentor(s)
Yulia Ovchinnikova
Bringing people together around technology, enabling startups.
I help businesses and talent to connect through creating engaging & collaborative opportunities.
#HudsonValleyCanCode #HVTechFest
Cynthia V. Marcello
Data Diva
Duration
15 hours
Cost
$499.00
Course Schedule:
This course is not currently scheduled.
Please sign up if you want to get this course soon.