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

YouTube

The Ultimate Excel Tutorial - Beginner to Advanced

Simon Sez IT via YouTube

Overview

This course covers Excel from beginner to advanced level in under 6 hours. The learning outcomes include mastering Excel formulas, data cleaning, pivot tables, dynamic array functions, advanced formulas, and VBA macros. The course teaches essential Excel skills such as VLOOKUP, COUNT, SUM, IF, INDEX, MATCH, SUMPRODUCT, SUMIFS, COUNTIFS, and more. The teaching method includes video tutorials with practical examples and exercises. This course is intended for beginners looking to become proficient in Excel, including professionals, students, and anyone interested in enhancing their spreadsheet skills.

Syllabus

- Excel Formulas for Beginners
- Cleaning Data in Excel
- Pivot Tables Excel Tutorial
- Dynamic Array Functions
- Advanced Formulas in Excel
- Macros and Basic VBA in Excel

Taught by

Simon Sez IT

Reviews

5.0 rating, based on 1 Class Central review

Start your review of The Ultimate Excel Tutorial - Beginner to Advanced

  • Julia Nti
    Exceptional Excel course: Beginner to Advanced. Clear explanations, practical examples, and valuable resources. Highly recommended!

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.