Recording and Managing Excel 2016 Macros

Focused View

Pratheerth Padman

31:36

68 View

00. Course Overview

00. Course Overview.mp4

01:51

01. Creating Simple Macros in Excel

00. Module Overview.mp4

01:16

01. Macros in Excel.mp4

02:27

02. Introduction to Excel VBA.mp4

01:35

03. Demo - Recording a Simple Macro.mp4

05:04

04. Demo - Editing a Simple Macro.mp4

03:05

02. Managing Macros and Configurations in Excel

00. Module Overview.mp4

00:51

01. Enable and Disable Macros.mp4

01:55

02. Demo - Enabling and Disabling Macros in Excel.mp4

03:00

03. Demo - Customizing the Ribbon with Developer Options.mp4

03:03

04. Copying Macros Between Workbooks.mp4

02:53

05. Renaming and Deleting a Macro.mp4

02:53

06. Summary and Feedback.mp4

01:43

Description

In this course, Recording and Managing Excel 2016 Macros, we will learn how to develop and edit macros in Excel, which will help us automate a whole host of tedious and time-consuming tasks.

What You'll Learn?

Unbeknownst to most people, a whole lot of our daily tasks performed in Excel can be automated. In this course, Recording and Managing Excel 2016 Macros, you will dip into the world of Excel Macros and VBA, which will help you do exactly that.

First, we'll see what macros are in Excel and how to go about creating and editing them. Next, you'll learn how to manage these newly created macros and their configurations, which include enabling and disabling macros, copying macros between workbooks, and renaming and deleting macros.

When you're finished with this course, you'll have fundamental knowledge about macros in Excel and the ability to create simple macros.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Macros

Pratheerth Padman

Instructor's Courses

Pratheerth is a Data Scientist who has entered the field after an eclectic mix of educational and work experiences. He has a Bachelor's in Engineering in Mechatronics from India, Masters in Engineering Management from Australia and then a couple of years of work experience as a Production Engineer in the Middle East. Then when the A.I bug bit him, he dropped everything to dedicate his life to the field. He is currently working on mentoring, course creation and freelancing as a Data Scientist.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.