How to Create & Use Excel Macros (Real world example)

I'll show you what the macro recorder can record and which actions you have to add yourself to the visual basic editor. I'll add an example by using the IF statement in VBA and also referencing a range for the chart title. Learn how to save your spreadsheet so you can access your Excel macros again in the future.

In this video you'll learn the basics of Macros and VBA in Excel. Plus you learn all of this in 10 minutes! Macros allow you to automate repetitive tasks in Excel. I'll show you how to to enable the Developer Tab, which allows you to record and run macros. We'll do an example on how to automatically create and format an Excel chart based on a dataset. This dataset has different ranges so we want to record the macro in such a way that its dynamic depending on the size of the data. You'll learn to avoid a common mistake when referencing ranges in Excel. Instead of hardcoding a certain data range with excel macros we'll use dynamic cell referencing. I'll show you what the macro recorder can record and which actions you have to add yourself to the visual basic editor. I'll add an example by using the IF statement in VBA and also referencing a range for the chart title. Learn how to save your spreadsheet so you can access your Excel macros again in the future.

Timestamps

• 00:00 Excel Macro Tutorial for Beginners
• 01:12 How to Record a Macro in Excel
• 06:36 How to Manually Adjust Code in Visual Basic Editor
• 07:33 Add IF Condition to Avoid Errors
• 09:10 How to Save Excel Workbook With Macro
• 09:34 Wrap Up

excel

Advanced Excel Online Training & Certification Courses by CETPA with Real time projects. Enroll now to get student offer of 50% on Online Course. Call us: 9212172602.

In this MS Excel tutorials, video we are going to see the differnce between tables and cell ranges in MS Excel. Also we are going to see that how can we create a Table from data given to us and what all changes we can apply to our tables.

In this MS Excel tutorials, video we are going to apply the slicers in charts in MS Excel. However, there is no direct method of doing so, that is why we are going to use a simple trick over here. Also we are going to see that how can we connect same slicer with multiple charts in MS Excel. ​

In this MS Excel VBA video, we are going to see the usage of the Insert Cells feature of MS Excel. Using this feature we can insert cells at some specified locations easily. In this video we will see the Overview of formulas in Excel.

In this Excel VBA video, we are going to look at the usage of the Paste Special function in Excel using the VB code. Paste Special function helps us to use the paste function in different formats such as Pasting Cell Width, Pasting Text only, Pasting Cell Formats.