Excel: Macros and VBA for Beginners

Focused View

Oz du Soleil

37:42

195 View

01 - Introduction

01 - Save time with Excel macros and VBA.mp4

00:48

02 - 1. Understand Macros and VBA

01 - What is an Excel macro.mp4

01:57

03 - 2. Record a Macro

01 - Enabling the Developer tab to expose VBA tools.mp4

01:28

02 - Recording your first macro.mp4

03:00

03 - Assign a macro to a button.mp4

01:51

04 - 3. Edit the Macro

01 - Introduction to Visual Basic (VBA).mp4

02:57

02 - Reading your recorded code.mp4

03:24

03 - Testing recorded macros.mp4

04:48

04 - Adjusting recorded macros.mp4

02:29

05 - Making recorded macros dynamic.mp4

07:34

06 - Rules of thumb for testing.mp4

03:30

07 - How to step through code when testing.mp4

03:25

05 - Conclusion

01 - Next steps.mp4

00:31

Description

View Oz's LinkedIn Newsletter

If you’re a frequent user of Excel, chances are you have Excel tasks that you need to repeat often. Fortunately, you can automate these tasks by creating macros. Many people assume macros are complicated and reserved only for Excel power users. Not so! In this short course, Excel MVP Oz du Soleil first explains the best times to use a macro, and then how to use Visual Basic for Applications (VBA) to set up a basic macro in Excel to record your mouse clicks and keystrokes. Learn how to set up macros in Excel now, saving time later.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Excel

Oz du Soleil

Instructor's Courses

Microsoft Excel MVP | YouTube Channel: Excel on Fire | Author, Guerrilla Data Analysis Version 2. Co-authored with Mr Excel, Bill Jelen | Excel Trainer & Instructor | Speaker. I've been working with data and Excel for many years, and have developed a passion for clean data and reliable reporting. An even greater passion is that of teaching, sharing knowledge and empowering people to do handle their data more efficiently and with greater skill to turn their data into useful information. Presented at: #Northwestern University #University of Illinois at Chicago #IgniteChicago #ExcelTV Courses taught: Excel Formulas Data Visualization in Excel 2013 Pivot Tables & Dashboards Excel for Nonprofits: Measuring Fundraising Effectiveness Introduction to Programming VBA

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.