Excel 365 in 30 Minutes – Macros & Forms (Advanced 8 of 11)

In this Bigger Brains course, you’ll learn how macros work and how they can save you time by automating common Excel tasks. You’ll see how to record macros using the Record Macro dialog box, verify macro security settings, and save workbooks as macro-enabled files. You’ll also learn best practices such as using the Personal Macro Workbook, running macros from dialog boxes and buttons, and recognizing VBA code behind the scenes. 

You’ll explore how to work directly with macros and forms at a more advanced level. You’ll learn how to navigate the Visual Basic Editor, edit and copy VBA code between macros, and fine-tune automation to fit your workflow. You’ll also see how to create data forms and forms linked to Excel, add form controls, and view submitted data directly in your worksheets—making data entry faster, easier, and more consistent for you and your team. 

Topics covered include: 

• Defining a macro 

• Explaining the benefit of using the Personal Workbook for macros 

• Recording a macro using the Record Macro Dialog Box 

• Verifying macro security settings 

• Running a macro from a dialog box and a button 

• Saving a workbook as a Macro Enabled Workbook 

• Navigating the VBE 

• Editing VBA code for a macro 

• Copying VBA code from one macro to another 

• Creating a data form to enter and modify data 

• Creating a form linked to Excel 

• Viewing submitted form data in Excel 

• Adding form controls to Excel workbooks 

Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.