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

Get attached file in this lession

Exercise Files
1.1 801 – Case study 2. Intercompany.zip
Size: 22.31 KB
1.2 Case Study 1 – Sales Data.zip
Size: 184.52 KB
Join the conversation
Previous
Next

Please contact me via telegram

DMCA.com Protection Status