YoVDO

The Ultimate Excel Tutorial - Beginner to Advanced

Offered By: Simon Sez IT via YouTube

Tags

Microsoft Excel Courses Data Cleaning Courses Pivot Tables Courses VLOOKUP Courses VBA Macros Courses

Course Description

Overview

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.

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

Related Courses

A Beginner’s Guide to Data Handling and Management in Excel
Packt via FutureLearn
Introduction to Financial Accounting: The Accounting Cycle
University of California, Irvine via Coursera
ADP Entry-Level Compensation and Benefits Analyst
Coursera
Microsoft Excel: Advanced Data Analysis and Visualisation
Cloudswyft via FutureLearn
Advanced Data Visualisation and Analysis in Excel
Packt via FutureLearn