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

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera