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

Please contact me via telegram

DMCA.com Protection Status

Quick Links

  • About us
  • Contact
  • Privacy Policy
  • Terms and Conditions
  • DCMA
  • Disclaimer

Resource

  • Course List
  • Recommend New Courses
  • For IT Students
© 2024 - freestudy247.com