The Private Equity Associate Certification
Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Learn the five most essential Excel functions in this 17-minute video tutorial that covers aggregate functions, date manipulation with Year/Month/Day, formatting techniques, logical operations, and lookup functionalities. Explore practical examples using a downloadable dataset while mastering fundamental Excel skills that are crucial for data analysis and everyday spreadsheet tasks. Progress through hands-on demonstrations of each function category, from basic aggregation to advanced lookup operations, with clear explanations and real-world applications.
Syllabus
Intro
Aggregate Functions
Year Month Day
Formatting
Logical
LookUp
Outro
Taught by
Alex the Analyst
Reviews
5.0 rating, based on 1 Class Central review
Showing Class Central Sort
-
Amazing Excel tutorial! Clear explanations, practical examples, and perfect for beginners or anyone refreshing their skills. I feel much more confident using Excel for data analysis now.