Learning VBA in Excel

( 0 Reviews )

Created by: Curt Frye

Produced in 2019

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a excel course? Or looking for more detail on Curt Frye's Learning VBA in Excel? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

The Visual Basic for Applications (VBA) programming language allows you to automate routine tasks in Excel and it's not as hard to learn as most people think. In this course, Excel expert Curt Frye offers a crash course on VBA, sharing techniques that can help users of Excel 2007 or later get more out of this powerful program. Curt covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.Topics include:Working in the Visual Basic EditorAdding code to a macroCreating, exporting, and deleting code modulesDeclaring and using variablesManaging variable scopeDefining arraysManaging workbooks and worksheets with VBARepeating tasks with loopsDebugging VBA codeCutting, copying, and pasting cell dataRunning and triggering event procedures

Beginner Level

Time: 3h 30m

Instructor Details

Curt Frye

0.0 Rating
0 Reviews

Curt Frye is the president of Technology and Society, Incorporated.He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for Lynda.com and LinkedIn Learning. As a speaker, he has presented talks on topics including "Rhetorical Mathematics" for CLE credit at the Law and Magic conference, "Business Storytelling Using Microsoft Excel" at the ATD-Cascadia annual conference, and his Improspectives approach to applying the techniques of improv theater to business and life for numerous audiences. As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences.Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.