Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel VBA Macro

via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course on Excel VBA Macros aims to teach learners how to automate tasks in Excel using Visual Basic for Applications. By the end of the course, students will be able to create, edit, and run macros, work with cells, formatting, and sheets, handle errors, use loops and conditional statements, manipulate dates and strings, and create user forms. The course uses a hands-on approach with step-by-step tutorials and examples. This course is intended for individuals who want to enhance their Excel skills and efficiency by automating repetitive tasks.

Syllabus

Excel VBA - Introduction.
Excel VBA - User-Interface of VBA Screen.
Excel VBA - Developer Tab.
Tutorix Simply Easy Learning Steps.
Excel VBA - Record a Macro.
Excel VBA - Save a Macro Workbook.
Excel VBA - Write a Simple Macro.
Excel VBA - Cell Referencing.
Excel VBA - Copy Paste.
Excel VBA - Font.
Excel VBA - With Block.
Excel VBA - Borders.
Excel VBA - Alignment.
Excel VBA - Font Color.
Excel VBA - Background Color.
Excel VBA - Paste Special.
Excel VBA - Orientation.
Excel VBA - Wrap Text.
Excel VBa - Merge Unmerge.
Excel VBA - Clear Cells.
Excel VBA - Delete Cells.
Excel VBA - Rows & Columns Insert.
Excel VBA - Rows and Columns Delete.
Excel VBA - Column Width.
Excel VBA - Row Height.
Excel VBA - Activate & Select.
Excel VBA - Columns Hide & Unhide.
Excel VBA - Rows Hide and Unhide.
Excel VBA - Sheets Introduction.
Excel VBA - Add Sheets.
Excel VBA - Add Sheet with Names.
Excel VBA - Rename Sheets.
Excel VBA - Get Sheet Names.
Excel VBA - Copy Sheets.
Excel VBA - Move Sheets.
Excel VBA - Change Sheet Tab Color.
Excel VBA - Hide and Unhide Sheets.
Excel VBA - Sheet Protection.
Tutorix Brings Simply Easy Learning.
Excel VBA - Activate Sheet.
Excel VBA - Create Workbook.
Excel VBA - Get Workbook Name.
Excel VBA - Save & Close Workbook.
Excel VBA - Open and Close Workbook.
Excel VBA - Delete Workbook.
Excel VBA - Create Folder.
Excel VBA - Variable Usage.
Excel VBA - Comment.
Excel VBA For Loop Example 1.
Excel VBA - For Loop Example 2.
Excel VBA - For Loop Example 3.
Excel VBA - For Loop Example 4.
Excel VBA - For Loop Example 5.
Excel VBA - For Loop Sheet Name.
Excel VBA - For Each Next Loop.
Excel VBA - Do While.
Excel VBA - Do Until.
Excel VBA - Types of Errors.
Excel VBA - Error Handling.
Excel VBA - Debugging.
Excel VBA - Immediate Window.
Excel VBA - Number to Text Function.
Excel VBA - If Statement.
Excel VBA - If Else Statement.
Excel VBA - If Elseif Else Statement.
Excel VBA - If Elseif Else with AND Operator.
Excel VBA - If Else Using For Loop.
Excel VBA - Select Case Statement.
Excel VBA - Message Box 1.
Excel VBA - Message Box 2.
Excel VBA - Message Box 3.
Excel VBA - Message Box 4.
Excel VBA - Message Box 5.
Excel VBA - Input Box.
Excel VBA - Rows & Columns Count.
Excel VBA - String Functions Left-Right.
Excel VBA - String Functions UCase-Lcase.
Excel VBA - String Reverse.
Excel VBA - Create Functions.
Excel VBA - Date Add.
Excel VBA - Date Part.
Excel VBA - DD/MM/YYYY.
Excel VBA - Dates.
Excel VBA - Time Function Part 1.
Excel VBA - Time Function Part 2.
Excel VBA - 1D Array Static.
Excel VBA - 2D Array Static.
Excel VBA - Dynamic Array.
Excel VBA - Worksheet Selection Change.
Excel VBA - Double Click.
Excel VBA - Sheet Activate.
Excel VBA - Workbook Open.
Excel VBA - Create User Form.
Excel VBA - Command Button.
Excel VBA - Radio Button.
Excel VBA - Check Box.
Excel VBA - List Box.
Excel VBA - Frames.
Excel VBA - Multipage.
Excel VBA - Background.
Excel VBA - Text Box.
Excel VBA - User Form Event.

Taught by

Tutorials Point (India) Ltd.

Reviews

Start your review of Excel VBA Macro

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.