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
Master Excel from beginner to advanced level in this comprehensive 5-hour tutorial. Learn essential formulas, data cleaning techniques, pivot tables, dynamic array functions, advanced formulas, and basic VBA macros. Start with fundamental concepts like VLOOKUP, COUNT, SUM, and IF functions, then progress to intermediate skills such as creating pivot tables and using dynamic arrays. Dive into advanced topics, including logical functions, INDEX, MATCH, SUMPRODUCT, and COUNTIFS. Conclude by exploring VBA macros, learning how to record, save, run, and edit them. Follow along with provided instructor files to practice and reinforce your skills throughout this in-depth Excel training.
