Главная
Study mode:
on
1
Start
2
Introduction
3
Named Ranges
4
Multiple Named Ranges
5
XLOOKUP
6
Data Mining with XLOOKUP
7
IF Function
8
Database Functions
9
Goal Seek
10
PMT Data Tables
11
Macros
12
IF-THEN Statements
13
Do Until Loops
14
Creating Games with Excel VBA Code
15
Conclusion
Description:
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.

Excel Advanced Tutorial - From Named Ranges to VBA

Learnit Training
Add to list
0:00 / 0:00