Teach yourself Excel VBA Step by Step

Simpliv

Course

Online

£ 10 VAT inc.

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

In this course the author Sam Parulekar, demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including recording a macro in stages, The course wraps up with a macro project brings together each of the elements in a real-world scenario. Exercise files accompany the course.Topics include:Understanding the VBA environment
Recording macros in stages
Writing VBA code
Using loops
Debugging macros
Testing
Copying Data from one worksheet to another

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Enabling the Developer Tab
Writing and running your first Macro Program
How to edit a recorded Macro
How to perform calculations using Macro
Looping Data using Do and For Loop
Conditional formatting using Macros
Using Cell properties
Finding next blank row
How to Copy data from one worksheet to another

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Excel Sheet
  • Writing
  • Property
  • Excel

Course programme

Introduction 2 lectures 05:19 Introduction to Excel VBA Enabling the Developer Tab Introduction 2 lectures 05:19 Introduction to Excel VBA Enabling the Developer Tab Introduction to Excel VBA Introduction to Excel VBA Introduction to Excel VBA Introduction to Excel VBA Enabling the Developer Tab Enabling the Developer Tab Enabling the Developer Tab Enabling the Developer Tab Studying Excel VBA 13 lectures 01:37:58 Resources section Writing and running your first Macro Program How to Record and Run a Macro How to edit a recorded Macro How to perform calculations using Macro Looping Data using Do while Loop Looping Data using For Next Loop Conditional Formatting Using Macros Nested do while to find duplicates Using Cell property to Select Excel Worksheet Cell Navigate in Excel Worksheet with offset property Find Next Blank Row with VBA How to Copy Data from one Excel Sheet to another and Print Studying Excel VBA 13 lectures 01:37:58 Resources section Writing and running your first Macro Program How to Record and Run a Macro How to edit a recorded Macro How to perform calculations using Macro Looping Data using Do while Loop Looping Data using For Next Loop Conditional Formatting Using Macros Nested do while to find duplicates Using Cell property to Select Excel Worksheet Cell Navigate in Excel Worksheet with offset property Find Next Blank Row with VBA How to Copy Data from one Excel Sheet to another and Print Resources section Resources section Resources section Resources section Writing and running your first Macro Program Writing and running your first Macro Program Writing and running your first Macro Program Writing and running your first Macro Program How to Record and Run a Macro How to Record and Run a Macro How to Record and Run a Macro How to Record and Run a Macro How to edit a recorded Macro How to edit a recorded Macro How to edit a recorded Macro How to edit a recorded Macro How to perform calculations using Macro How to perform calculations using Macro How to perform calculations using Macro How to perform calculations using Macro Looping Data using Do while Loop Looping Data using Do while Loop Looping Data using Do while Loop Looping Data using Do while Loop Looping Data using For Next Loop Looping Data using For Next Loop Looping Data using For Next Loop Looping Data using For Next Loop Conditional Formatting Using Macros Conditional Formatting Using Macros Conditional Formatting Using Macros Conditional Formatting Using Macros Nested do while to find duplicates Nested do while to find duplicates Nested do while to find duplicates Nested do while to find duplicates Using Cell property to Select Excel Worksheet Cell Using Cell property to Select Excel Worksheet Cell Using Cell property to Select Excel Worksheet Cell Using Cell property to Select Excel Worksheet Cell Navigate in Excel Worksheet with offset property Navigate in Excel Worksheet with offset property Navigate in Excel Worksheet with offset property Navigate in Excel Worksheet with offset property Find Next Blank Row with VBA Find Next Blank Row with VBA Find Next Blank Row with VBA Find Next Blank Row with VBA How to Copy Data from one Excel Sheet to another and Print How to Copy Data from one Excel Sheet to another and Print How to Copy Data from one Excel Sheet to another and Print How to Copy Data from one Excel Sheet to another and Print Ending the Session 1 lecture 01:03 Congratulations you finished the course Ending the Session 1 lecture 01:03 Congratulations you finished the course Congratulations you finished the course Congratulations you finished the course Congratulations you finished the course Congratulations you finished the course

Additional information

The student should have working knowledge of Excel The student should have a computer with Excel installed (any version will do)

See related categories

Teach yourself Excel VBA Step by Step

£ 10 VAT inc.

The best Other Education courses

See all

See all