Excel GPT

Excel, Outlook & Reporting Automation

Created bySandeepa K H

Last updated 4/2025

English

What you'll learn

Excel Automation: Automate repetitive tasks in Excel using powerful tools and techniques.
Email Automation: Set up systems to send custom emails automatically.
Report Automation: Build tools to generate and share corporate reports without manual effort.
Job-Ready Skills: Develop unique skills in Excel and automation that can help you stand out in the job market.
Custom Automation Tools: Design a personalized automation system that enables your computer to create and distribute reports seamlessly.
Corporate Reporting Expertise: Learn how to create two professional-level corporate reports highly valued in smartphone companies.
Real-World Application: Gain practical skills to solve real-world business challenges using automation.

Course content

10 sections • 123 lectures • 9h 40m total length

Course Output: A Game-Changer for You.3:26
Are you ready to transform the way you work with Excel? In this video, I’ll give you an exciting overview of what you can expect from this course.
Here's what you’ll discover:
How this course will help you master Excel automation, email automation, and report automation.
The unique skills you’ll gain, including building your own custom automation tool.
Why this course is a game-changer for your productivity and career.
The corporate insights you'll learn, including creating reports highly valued in the smartphone industry.
This course is designed to empower you to work smarter, save time, and stand out in your professional journey.
Watch this video and take the first step towards building tools that automate your work and make you a true productivity expert!
Why to choose this course?1:42

Introduction to VBA.2:03
By the end of this section, students will be able to:
Understand What VBA (Visual Basic for Applications) Is:
Learn the purpose and role of VBA in automating tasks in Excel.
Recognize the Benefits of Using VBA:
Understand how VBA can save time, reduce errors, and streamline repetitive processes.
Navigate the VBA Environment:
Familiarize themselves with the VBA editor and key features within Excel.
Activate and Open the VBA Editor:
Learn how to enable and access the VBA editor for coding.
Understand How VBA Relates to Excel's Functionality:
Explore how VBA interacts with Excel data and features to create automation.
This section will give students a strong foundation to start exploring the world of VBA programming and automation in Excel confidently.
Exploring the VBA User Interface.6:19
This video focuses on the VBA Editor’s user interface. You’ll learn about its key components like the Project Explorer, Properties Window, and Code Window, making it easier to navigate and work efficiently in the VBA environment.
What You Will Learn:
After this video, students will be able to confidently navigate the VBA Editor and understand its key components.
Activating the Editor Pane in VBA.2:11
Learn how to activate and configure the Editor Pane in the VBA environment. This step is crucial for writing and testing VBA code effectively.
What You Will Learn:
By the end of this section, students will know how to open and set up the VBA Editor Pane for seamless coding.
Recording Your First Macro.8:46
Discover how to record a macro to automate repetitive tasks in Excel. This video provides a step-by-step guide on using the Macro Recorder to capture actions and generate VBA code.
What You Will Learn:
Students will be able to record their first macro and understand how the recorder translates actions into VBA code.
Saving a Macro for Future Use.2:45
Learn how to save macros properly in different file formats, such as macro-enabled workbooks, to ensure their functionality is preserved for future use.
What You Will Learn:
Students will know how to save macros and choose the correct file type to ensure compatibility and usability.
Saving Macro Workbooks Quiz.
Writing Your First Macro from Scratch.3:45
This video guides you through writing your first VBA macro from scratch. You’ll learn the structure of a macro, how to write simple commands, and execute them in Excel.
What You Will Learn:
After completing this section, students will be able to write basic VBA macros independently.
Understanding Cell References.7:45
Explore the different types of cell references in VBA, including absolute, relative, and mixed references. This video explains how to reference and manipulate cells programmatically.
What You Will Learn:
Students will understand how to use cell references in VBA to dynamically work with Excel data.
Automating Copy and Paste.7:44
Automate the copy-paste process in Excel using VBA. This video demonstrates how to write a macro for copying and pasting data between cells and worksheets.
What You Will Learn:
Students will be able to create macros to automate the copy-paste functionality in Excel.
Customizing Font Properties.4:30
Learn how to use VBA to customize font properties such as size, color, and style. This video walks you through examples of formatting cells programmatically.
What You Will Learn:
Students will know how to write macros to adjust font properties dynamically in Excel.
Mastering the With Block.4:10
This video introduces the With block, a powerful VBA construct to simplify repetitive code and improve readability. Learn how to efficiently manipulate properties of objects within a single block of code.
What You Will Learn:
Students will understand how to use the With block to streamline VBA code and avoid redundant object references.
Adding and Customizing Borders.3:57
Learn how to add and customize borders around cells using VBA. This video covers techniques to define border styles, colors, and thickness programmatically.
What You Will Learn:
Students will be able to apply and modify borders to enhance the visual presentation of Excel data.
Aligning Content in Excel.3:32
Discover how to align text and numbers in Excel using VBA. This video demonstrates methods for horizontal and vertical alignment to format your data effectively.
What You Will Learn:
Students will know how to write macros to adjust alignment for better data organization and presentation.
Changing Font Color.4:10
Learn to dynamically change the font color of cells using VBA. This video explains how to apply conditional and customized font colors for better data visualization.
What You Will Learn:
Students will be able to automate font color changes to highlight specific data.
Setting Interior (Background) Colors.2:35
This video focuses on applying background colors to cells using VBA. Learn how to programmatically use colors to organize and emphasize data.
What You Will Learn:
Students will know how to write macros to set interior colors for cells in Excel.
Automating Paste Special Operations.4:21
Learn how to perform and automate Paste Special operations in Excel using VBA. This video shows how to paste values, formats, and formulas programmatically.
What You Will Learn:
Students will be able to create macros that replicate advanced paste special options.
Adjusting Text Orientation.2:44
Discover how to change the orientation of text in cells using VBA. This video demonstrates ways to rotate text for better data presentation.
What You Will Learn:
Students will understand how to modify text orientation programmatically to improve layout and design.
Wrapping Text in Excel.1:40
This video shows how to use VBA to enable text wrapping in Excel cells. Learn to format long text to fit within cells neatly.
What You Will Learn:
Students will be able to automate text wrapping to maintain a clean and readable layout.
Wrap Text in VBA Quiz.
Merging and Unmerging Cells.3:05
Learn how to merge and unmerge cells programmatically in Excel using VBA. This video explains the scenarios where merging can improve formatting.
What You Will Learn:
Students will know how to automate merging and unmerging cells to format Excel sheets effectively.
Clearing Cell Content.3:44
Discover how to clear cell content, formats, or both using VBA. This video provides a step-by-step guide to use Clear methods efficiently.
What You Will Learn:
Students will understand how to write macros to clear specific parts of a worksheet as needed.
Clear Options in VBA Quiz
Deleting Specific Cells.3:02
Learn how to delete specific cells and shift data around them programmatically in VBA. This video covers handling cells while maintaining the structure of the worksheet.
What You Will Learn:
Students will be able to automate cell deletion while controlling data movement.
Inserting Rows Programmatically.4:05
This video teaches you how to insert rows in Excel using VBA. Learn to add rows dynamically based on conditions or user requirements.
What You Will Learn:
Students will be able to insert rows programmatically to adjust data layout dynamically.
Deleting Rows and Columns.4:08
Learn how to delete entire rows and columns in Excel using VBA. This video explains methods to clean up unnecessary data effectively.
What You Will Learn:
Students will understand how to write macros to delete rows and columns based on specific criteria.
Deleting Rows in VBA Quiz
Adjusting Column Width.3:33
This video demonstrates how to set and adjust column widths programmatically in Excel. Learn to optimize space and improve readability of your worksheets.
What You Will Learn:
Students will be able to dynamically set column widths for better data presentation.
Changing Row Heights.3:23
Discover how to change row heights in Excel using VBA. This video explains how to make adjustments dynamically based on the content or user input.
What You Will Learn:
Students will know how to write macros to adjust row heights for better worksheet formatting.

Active & Select.3:33
Learn how to dynamically select and activate specific cells or ranges in Excel using VBA. This video demonstrates practical methods to ensure efficient navigation and control over data selection in your spreadsheets.
What You'll Learn: By the end of this video, students will be able to programmatically select and activate any range of cells in Excel.
Hide Columns.2:44
Master how to hide columns in Excel through VBA. This video showcases techniques to streamline data presentation by programmatically concealing unnecessary columns.
What You'll Learn: Students will learn to write VBA code that can efficiently hide columns based on user-defined conditions.
Hide Rows.2:28
Discover how to hide rows in Excel using VBA. This tutorial provides step-by-step instructions on automating row visibility for better data management.
What You'll Learn: Students will be able to automate hiding rows in Excel based on specific criteria.
Hiding Rows in VBA Quiz
Sheet Reference.4:31
Understand how to reference sheets in Excel using VBA. This video covers accessing, navigating, and managing worksheets programmatically.
What You'll Learn: Students will gain the ability to efficiently reference and work with multiple sheets in a workbook.
Add Sheets.3:59
Learn how to add new sheets to an Excel workbook through VBA. This video covers creating and customizing sheets on demand.
What You'll Learn: Students will be able to programmatically add new worksheets to a workbook and name them dynamically.
Sheet Names.2:08
Learn how to retrieve and work with sheet names in Excel using VBA. This video simplifies the process of accessing sheet names dynamically.
What You'll Learn: Students will know how to extract, list, and use worksheet names programmatically.
Rename Sheet.3:06
Discover how to rename sheets in Excel with VBA. This video demonstrates renaming worksheets dynamically for better workbook organization.
What You'll Learn: Students will be able to write VBA scripts to rename sheets based on specific inputs or conditions.
Get Sheet Names.2:28
Learn how to fetch specific names of sheets from your Excel workbook using VBA. This tutorial simplifies the process of automating name retrieval.
What You'll Learn: Students will be able to retrieve and use worksheet names in their VBA projects.
Copy Sheet.2:55
Master the technique of copying worksheets using VBA. This video explains how to duplicate sheets with or without their content.
What You'll Learn: Students will be able to programmatically copy sheets within a workbook or into a new workbook.
Move Sheet.2:55
Understand how to move worksheets within or across workbooks using VBA. This video provides detailed instructions on rearranging sheets programmatically.
What You'll Learn: Students will be able to relocate sheets within the same workbook or to another workbook efficiently.
Moving Sheets in VBA Quiz
Tab Color.4:18
Explore how to change the tab color of worksheets using VBA. This video highlights practical methods for visualizing your data more effectively.
What You'll Learn: Students will be able to customize worksheet tab colors dynamically for better organization.
Hide Sheets.3:55
Learn to hide worksheets in Excel using VBA. This tutorial explains how to conceal sheets for a cleaner user experience.
What You'll Learn: Students will be able to automate hiding worksheets in their Excel workbooks.
Protect Sheet.4:50
Master the process of protecting worksheets using VBA. This video covers adding password protection and restricting access programmatically.
What You'll Learn: Students will know how to secure worksheets by applying protection features through VBA.
Activate Sheet.2:33
Understand how to activate specific worksheets using VBA. This video demonstrates the techniques to switch between sheets dynamically.
What You'll Learn: Students will be able to programmatically activate any worksheet in a workbook.
Add Workbook.5:05
Learn how to create new workbooks using VBA. This video walks through automating the creation and customization of Excel workbooks.
What You'll Learn: Students will be able to generate new workbooks programmatically with customized features
Get Workbook Names.4:04
Discover how to retrieve the names of open workbooks using VBA. This video simplifies working with multiple workbooks simultaneously.
What You'll Learn: Students will be able to list and interact with the names of active workbooks programmatically.
Save & Close Workbook.4:19
Learn how to save and close workbooks programmatically using VBA. This video ensures proper handling of workbook operations.
What You'll Learn: Students will be able to automate saving and closing of Excel files.
ThisWorkbook.Save.2:20
Master saving the current workbook through VBA. This video focuses on automating save operations specific to the active workbook.
What You'll Learn: Students will be able to save the active workbook using efficient VBA code.
Delete Files.3:48
Learn how to delete files using VBA. This video demonstrates the process of automating file deletion securely.
What You'll Learn: Students will be able to use VBA to locate and delete files programmatically.
Create Folder.1:43
Learn how to create folders programmatically using VBA. This video demonstrates how to set up directories for saving files or organizing data dynamically.
What You'll Learn: Students will be able to programmatically create folders in specified paths using VBA.
Variable.3:44
Understand how to declare and use variables in VBA. This video explains the different types of variables and how to effectively utilize them in your macros.
What You'll Learn: Students will learn how to declare, initialize, and manipulate variables in their VBA code.
Comments.2:11
Learn the importance of adding comments in VBA and how to write effective comments for clarity and maintainability.
What You'll Learn: Students will know how to add meaningful comments to their code to make it easier to read, debug, and maintain.
For Loop 1.7:04
For Loop 2.4:12
Dive deeper into advanced For Loop techniques and discover how they can optimize workflows by iterating over collections, ranges, and conditions.
What You'll Learn: Students will be equipped to use advanced "For Loops" with dynamic ranges and logic in their VBA scripts.
For Loop 3.4:08
Explore advanced applications of "For Loops" in VBA, including nested loops and iterating through multi-dimensional arrays. This video demonstrates practical use cases and scenarios.
What You'll Learn: Students will learn how to use nested loops and loop through complex ranges and arrays efficiently in their VBA projects.
Using For Loops in VBA Quiz

For Loop Reverse.2:31
Learn how to use the For Loop Reverse to iterate through a range in reverse order, a useful technique for backward processing of data in Excel automation.
For Loop Diagonal.1:48
Discover how to loop through data diagonally in a spreadsheet using VBA. This technique is essential for unique range manipulations and patterns in automation tasks.
Get Sheet Names.2:12
Learn how to dynamically access and retrieve all sheet names in your workbook using VBA, enabling seamless multi-sheet data processing.
For Each.3:15
Understand how to use the For Each loop to iterate over objects like worksheets, ranges, or collections, simplifying your VBA code logic.
Do While.4:00
Learn how to use the Do While loop to execute repetitive tasks while a condition is true. This is a fundamental tool for conditional iterations.
Do Until.2:49
Explore how to use the Do Until loop to repeat actions until a condition is met, enabling efficient data processing and control flow in VBA.
Errors.4:19
Learn how to identify and handle runtime errors in your VBA scripts, and ensure your code runs smoothly even when unexpected issues arise.
Handling Error.9:04
Discover advanced techniques for error handling in VBA, including how to use On Error statements to gracefully manage runtime issues and ensure program stability.
Debug.5:06
Master the debugging tools in VBA, including setting breakpoints, stepping through code, and using the Immediate Window to troubleshoot issues effectively.
Immediate Window.4:50
Learn how to use the Immediate Window in the VBA editor to test snippets of code, troubleshoot logic errors, and inspect variable values in real-time.
If Statement.2:21
Understand how to use basic If Statements to control code execution based on conditions. This foundational logic is essential for dynamic programming.
If Else 2.1:33
Explore advanced If Else logic, enabling you to execute different code blocks depending on multiple conditions, adding flexibility to your VBA scripts.
If ElseIf Else.4:55
Learn how to use ElseIf statements in combination with If Else for more complex conditional logic and decision-making in VBA.
If And.4:03
Master combining multiple conditions with If And to execute code only when multiple criteria are met, improving the precision of your logic.
If For.2:46
Learn how to integrate loops with If statements to dynamically process ranges and data based on specific conditions in VBA.
Select Case.5:40
Explore how to use the Select Case statement to handle multiple conditions efficiently, providing cleaner and more readable code.
Message box 1.2:38
Learn how to use message boxes for user interaction, and display messages in your automation workflows.
Message box 2.3:29
Discover advanced uses of message boxes to gather user input and create interactive experiences in your Excel macros.
Message box 3.2:41
Explore advanced techniques with message boxes to dynamically control application logic and data based on user responses.
Message box 4.4:06
Understand how to utilize multiple message boxes to create decision trees or branching logic during macro execution.
Message box 5.2:06
Learn how to incorporate complex user response handling with multiple message box prompts to streamline user interactions.
InputBox.3:41
Learn how to use InputBox to prompt users for input dynamically and integrate their responses into your VBA logic.
Row & Column Count.2:53
Discover how to dynamically count rows or columns using VBA logic and functions, essential for automating range-based tasks.

String Functions 1.3:37
Learn how to use common String Functions in VBA to manipulate and process text data efficiently.
Using the Left Function in VBA Quiz
String Functions 2.2:49
Explore advanced String Functions techniques and discover how they can enhance data manipulation in your macros.
String Functions 3.2:38
Dive into advanced scenarios and practical applications of String Functions in VBA programming for dynamic data processing.
Create Function.3:58
Learn how to define and create custom functions in VBA to make your code reusable and efficient.
Date Add Function.5:40
Understand how to use the DateAdd function in VBA to perform date arithmetic and manipulate date values.
Date Extract 1.2:23
Discover how to extract specific date components using VBA functions, enhancing your ability to manipulate and analyze date values.
Date Extract 2.2:01
Learn how to efficiently extract date parts, such as year, month, or day, using VBA's built-in date processing tools.
Date Functions.2:40
Explore a range of date-related functions in VBA that help analyze, calculate, and manipulate dates effectively.
Time Functions 1.4:36
Learn how to use Time Functions in VBA to handle time calculations, manipulate times, and integrate time logic into automation.
Time Functions 2.1:58
Discover practical examples of Time Functions usage, including calculating durations and extracting time components.
Event Trigger.5:18
Learn how to set up and utilize Event Triggers in VBA to automatically respond to actions in the Excel environment.
Events 2.2:40
Explore advanced Event Handling scenarios with VBA to automate actions in response to user interactions.
Events 3.1:39
Dive into deeper examples of Event Handling, exploring the nuances of events like changes, selections, and other triggers.
Workbook Events.5:11
Discover how to automate workbook operations using VBA, including opening, saving, and manipulating multiple workbooks programmatically.
Assign Macro.3:16
Learn how to assign macros to buttons, shapes, or other objects to trigger automated actions in your Excel workbook.
Cursor Control.5:21
Understand how to control the cursor's position and navigation within a workbook using VBA to enhance user experience and automation.
PivotTable Introduction.2:42
Learn how to create and manipulate PivotTables programmatically with VBA for advanced data analysis and summarization.
PivotTable 1.13:59
Explore the first steps of PivotTable creation and manipulation with VBA, setting up tables dynamically.
PivotTable Manipulation.8:08
Discover advanced techniques for PivotTable Manipulation using VBA, allowing you to customize and dynamically analyze data.
Autofilter.5:25
Learn how to use Autofilter with VBA to sort and filter data efficiently, enabling quick data analysis in your macros.
Using AutoFilter in VBA Quiz
Replace.2:59
Explore how to use the Replace function in VBA to find and replace values or text within a range, streamlining data cleaning.
Used Range.2:14
Learn how to identify and work with the Used Range in Excel using VBA, allowing you to dynamically interact with only the relevant cells.

Email Writing Introduction.1:19
Learn the basics of writing and sending emails using VBA to automate communication tasks in Outlook.
Establish Connection.0:55
Discover how to establish a connection to Outlook using VBA, enabling automated email interactions.
New Mail Window Activation.3:28
Learn how to programmatically open a new mail window in Outlook using VBA for seamless email composition.
Set up Mail Properties.3:37
Explore how to set and customize mail properties, such as subject, recipients, and formatting, using VBA.
Insert Signature.7:00
Learn how to insert email signatures dynamically into your emails in Outlook using VBA.
HTML vs Mail Body.2:07
Understand the differences between HTML and plain text email bodies and how to select the appropriate format using VBA.
HTML Body in Outlook.1:17
Discover how to create and insert HTML email bodies into Outlook emails using VBA for advanced formatting.
Email Attachments.3:03
Learn how to attach files to Outlook emails programmatically using VBA to streamline your email workflows.
Excel Range to HTML Tag - 1.2:05
Understand how to convert and export Excel ranges into HTML format for inclusion in email bodies using VBA.
Excel Range to HTML Tag -2.8:49
Explore advanced techniques for exporting and formatting Excel ranges as HTML content for email automation with VBA.

Process Automation - Email Writing 1.15:20
Learn the basics of automating email writing using VBA with Outlook for efficient communication workflows.
Process Automation - Email Writing 2.13:36
Explore advanced techniques in automating email tasks, such as customizing recipients and mail properties with VBA.
Process Automation - Workbook management.2:39
Introduction to Automation Tools.1:54
Process Automation - Part - 98:16
Process Automation - Part - 104:15

Requirements

No Prior Coding Knowledge Required.
Basic Excel Knowledge: Students should have a basic understanding of Excel, including working with spreadsheets, formulas, and basic formatting.
Access to Microsoft Excel: Students will need access to a Windows or Mac computer with Microsoft Excel installed (preferably Excel 2016 or later).
Eagerness to Learn: A willingness to explore new tools and techniques to improve productivity and automation.
Basic Computer Skills: Familiarity with using a computer for everyday tasks such as file management and internet browsing.

Description

Step into the world of Excel Automation and transform the way you handle data and reports! This course is your gateway to mastering automation techniques that save time, boost efficiency, and make your work stand out.

What You Will Learn:

Excel Automation: Automate repetitive tasks and processes in Excel to make your workflows seamless.
Email Automation: Learn to create automated email systems to share reports effortlessly.
Report Automation: Build tools to generate corporate reports without lifting a finger.
Corporate Insights: Gain expertise in creating two critical corporate reports highly valued in smartphone companies, helping you stand out in the job market.

Course Highlights:

Build Your Own Automation Tool: By the end of this course, you'll have the skills to develop a custom automation tool that empowers your computer to create and share reports without human intervention.
Real-World Application: The automation techniques taught in this course are designed to solve real-world business challenges, making you a valuable asset in any organization.
Job-Ready Skills: Master skills that make you job-ready and open doors to exciting opportunities, especially in smartphone and tech-related industries.

Who This Course is For:

This course is perfect for:

Individuals with basic Excel knowledge who want to advance their skills.
Professionals aiming to improve efficiency and productivity in their work.
Aspiring candidates looking to enhance their resumes with unique, job-oriented skills.

By the End of This Course, You Will:

Create powerful Excel automations that reduce manual work.
Design email automation systems for seamless communication.
Develop corporate reports with automation to boost your career.
Build your very own custom automation tool and lead your organization into the future of data management!

Who this course is for:

Job Seekers: Aspiring candidates aiming to stand out in the job market by adding unique, automation-based skills to their resume.
Excel Enthusiasts: Individuals who have basic Excel knowledge and want to take their skills to the next level by learning automation techniques.
Business Professionals: Employees in roles that involve repetitive tasks, reporting, or data management, looking to save time and improve efficiency.
Corporate Analysts and Report Creators: Professionals in corporate roles responsible for generating and sharing reports, particularly in industries like smartphones and tech.
Anyone Seeking Productivity Gains: Anyone who loves learning new ways to work smarter and reduce manual effort in daily tasks.

Excel GPT

What you'll learn

Explore related topics

Course content

Excel Course Output: A Game-Changer for You.2 lectures • 5min

Excel Automation - Part 1.24 lectures • 1hr 38min

Excel Automation - Part 2.25 lectures • 1hr 29min

Excel Automation - Part 3.23 lectures • 1hr 23min

Excel Automation - Part 4.22 lectures • 1hr 31min

Design and Develop Custom Templates.5 lectures • 46min

Email Automation with Outlook.10 lectures • 34min

Process Automation - 1.5 lectures • 1hr 28min

Process Automation - 2.6 lectures • 46min

The End is Just the Beginning: Stay Inspired.1 lecture • 1min

Requirements

Description

Who this course is for: