Course Content
Subtitle Guide – Hướng dẫn thêm phụ đề
0/1
Set up subtitle for video – Hướng dẫn thêm phụ đề
1. Introduction to Microsoft Excel Automation
0/7
Subtitle File Resource
Welcome
Download the The Excel Autopilot Practice Workbook
3. 101 – Welcome
01:29
4. 102 – Excel Automation
01:37
5. 103 – Types of Automation
02:26
6. 104 – Use cases
01:54
2. PivotTables and PivotCharts
0/5
Subtitle File Resource
1. 201 – PivotTable and PivotChart
01:38
2. 202 – Create and customize
05:53
3. 203 – Change basic settings
01:44
4. 204 – PivotChart
04:22
3. Tips and tricks to work faster
0/7
Subtitle File Resource
1. 301 – Quick access toolbar
03:21
2. 302 – Shortcuts
08:18
3. 303 – Create your own tab
01:14
4. 304 – Templates
01:13
5. 305 – Change default settings
02:10
6. 306 – Themes, colors and fonts
02:32
4. AI and integration with Excel
0/3
Subtitle File Resource
2. 401 – AI-tools inside Excel
06:14
3. 402 AI-tools outside Excel stor
08:29
5. Excel Macros and VBA
0/7
Subtitle File Resource
1. 501 – Introduction to Macros
05:40
2. 502 – Recording and editing
03:35
3. 503 – VBA Editor
03:16
4. 504 – Variables
03:22
5. 505 – Loops
04:22
6. 506 – Conditional statements
02:45
6. Automating Tasks with VBA
0/4
Subtitle File Resource
1. 601 – Automate common tasks
02:12
2. 602 – Error handling and debugging
03:35
3. 603 – VBA Event
03:07
7. Excel Add-ins and Power Tools
0/3
Subtitle File Resource
2. 702 – Power Pivot
03:57
Resource
8. Putting It All Together
0/7
Subtitle File Resource
Course material
2. 801 – Case study 1
06:00
3. 801 – Case study 2
01:54
4. 802 – Tips and Best Practices
01:54
5. 803 – Course Summary
01:58
Draft Lesson
The Excel Autopilot Course 2024
About Lesson

Subtile file including English and Vietnamese is attached here

 

Join the conversation
Previous
Next

Please contact me via telegram

DMCA.com Protection Status