YoVDO

Excel Advanced Tutorial - From Named Ranges to VBA

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Mining Courses Data Tables Courses Macros Courses VBA Courses Goal Seek Courses XLOOKUP Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Dive into advanced Excel techniques with this comprehensive tutorial designed for beginners and experienced users alike. Master named ranges, XLOOKUP, data mining, IF functions, and database operations to enhance your spreadsheet skills. Explore goal seek, PMT data tables, and macros to automate tasks and increase efficiency. Learn to create IF-THEN statements, implement Do Until loops, and even develop games using Excel VBA code. Elevate your Excel proficiency and streamline your data analysis processes with practical, hands-on examples throughout this 78-minute learning journey.

Syllabus

Start
Introduction
Named Ranges
Multiple Named Ranges
XLOOKUP
Data Mining with XLOOKUP
IF Function
Database Functions
Goal Seek
PMT Data Tables
Macros
IF-THEN Statements
Do Until Loops
Creating Games with Excel VBA Code
Conclusion


Taught by

Learnit Training

Related Courses

Introduction to Data Science
University of Washington via Coursera Big Data Analytics in Healthcare
Georgia Institute of Technology via Udacity More Data Mining with Weka
University of Waikato via Independent Mining Massive Datasets
Stanford University via edX Pattern Discovery in Data Mining
University of Illinois at Urbana-Champaign via Coursera