CINXE.COM

Excel: Learning VBA Online Class | LinkedIn Learning, formerly Lynda.com

<!DOCTYPE html> <html lang="en"> <head> <meta name="pageKey" content="d_learning_course_guest"> <!----><!----> <meta name="locale" content="en_US"> <meta id="config" data-app-version="2.0.2217" data-call-tree-id="AAYn2ny6ZneD13qRgnC0CQ==" data-multiproduct-name="learning-guest-frontend" data-service-name="learning-guest-frontend" data-browser-id="220266ef-d8f7-4265-80dd-bc8a80c56d9c" data-enable-page-view-heartbeat-tracking data-page-instance="urn:li:page:learning_course_guest;AZ+aLjUtT0C8N8oDuVm74g==" data-disable-jsbeacon-pagekey-suffix="false" data-member-id="0"> <link rel="canonical" href="https://www.linkedin.com/learning/excel-learning-vba"> <!----><!----> <!----> <!----> <!----> <link rel="manifest" href="/homepage-guest/manifest.json" crossorigin="use-credentials"> <!----> <script> function getDfd() {let yFn,nFn;const p=new Promise(function(y, n){yFn=y;nFn=n;});p.resolve=yFn;p.reject=nFn;return p;} window.lazyloader = getDfd(); window.tracking = getDfd(); window.impressionTracking = getDfd(); window.ingraphTracking = getDfd(); window.appDetection = getDfd(); window.pemTracking = getDfd(); </script> <!----> <link rel="icon" href="https://static.licdn.com/aero-v1/sc/h/444zstxv7s91nepfm5et6ofge"> <title>Excel: Learning VBA Online Class | LinkedIn Learning, formerly Lynda.com</title> <meta name="robots" content="noarchive, max-image-preview:large"> <meta name="description" content="Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA."> <meta property="og:site_name" content="LinkedIn"> <meta name="twitter:site" content="@LI_Learning"> <meta name="twitter:card" content="summary"> <meta name="litmsProfileName" content="learning-guest-frontend"> <meta property="og:title" content="Excel: Learning VBA Online Class | LinkedIn Learning, formerly Lynda.com"> <meta name="twitter:title" content="Excel: Learning VBA Online Class | LinkedIn Learning, formerly Lynda.com"> <meta property="og:description" content="Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA."> <meta name="twitter:description" content="Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA."> <meta property="og:image" content="https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&amp;v=beta&amp;t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w"> <meta name="twitter:image" content="https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&amp;v=beta&amp;t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w"> <!----> <meta property="og:url" content="https://www.linkedin.com/learning/excel-learning-vba"> <meta property="og:type" content="website"> <meta name="clientSideIngraphs" content="1" data-gauge-metric-endpoint="/learning-guest/api/ingraphs/gauge" data-counter-metric-endpoint="/learning-guest/api/ingraphs/counter"> <link rel="stylesheet" href="https://static.licdn.com/aero-v1/sc/h/ccepec31u8riooiwchbtig8m0"> <script type="application/ld+json"> {"@context":"http://schema.org/","@type":"Course","provider":{"@type":"Organization","name":"LinkedIn Learning","url":"https://www.linkedin.com/learning/"},"publisher":{"@type":"Organization","name":"LinkedIn Learning","url":"https://www.linkedin.com/learning/"},"hasCourseInstance":{"@type":"CourseInstance","courseMode":"online","courseWorkload":"PT4H20M41S","instructor":[{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"}]},"inLanguage":"en","name":"Excel: Learning VBA","offers":[{"@type":"Offer","category":"Subscription"},{"@type":"Offer","category":"Paid","price":"299.99","priceCurrency":"HKD"}],"description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","image":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","creator":[{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"}],"author":[{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"}],"dateCreated":"2023-10-25","datePublished":"2023-10-25","thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","timeRequired":"PT4H20M41S","totalHistoricalEnrollment":31442,"url":"https://www.linkedin.com/learning/excel-learning-vba","about":[{"@type":"Thing","url":"https://www.linkedin.com/learning/search?keywords=VBA+Excel","name":"VBA Excel"},{"@type":"Thing","url":"https://www.linkedin.com/learning/topics/microsoft-excel","name":"Microsoft Excel"}],"hasPart":[[{"@type":"VideoObject","name":"Extend the capabilities of Excel using VBA - Introduction","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT26S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/extend-the-capabilities-of-excel-using-vba"},{"@type":"VideoObject","name":"What you should know before starting - Introduction","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT1M10S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/what-you-should-know-before-starting"}],[{"@type":"VideoObject","name":"Introduce object-oriented programming - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M2S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/introduce-object-oriented-programming"},{"@type":"VideoObject","name":"Examine the Excel object model - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M14S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/examine-the-excel-object-model"},{"@type":"VideoObject","name":"Work in the Visual Basic Editor - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT6M27S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/work-in-the-visual-basic-editor"},{"@type":"VideoObject","name":"Set VBA project properties - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M28S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/set-vba-project-properties"},{"@type":"VideoObject","name":"Create, export, and delete code modules - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M54S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/create-export-and-delete-code-modules"},{"@type":"VideoObject","name":"Create a subroutine - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M28S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/create-a-subroutine"},{"@type":"VideoObject","name":"Create a function - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M2S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/create-a-function"},{"@type":"VideoObject","name":"Add comments to your code - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M47S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/add-comments-to-your-code"},{"@type":"VideoObject","name":"Run a VBA procedure - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M20S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/run-a-vba-procedure"},{"@type":"VideoObject","name":"Add code to a recorded macro - 1. Introducing Visual Basic for Applications","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M48S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/add-code-to-a-recorded-macro"}],[{"@type":"VideoObject","name":"Introduce Excel VBA data types - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M5S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/introduce-excel-vba-data-types"},{"@type":"VideoObject","name":"Declare variables and require declaration before use - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M27S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/declare-variables-and-require-declaration-before-use"},{"@type":"VideoObject","name":"Manage variable scope - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M50S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/manage-variable-scope"},{"@type":"VideoObject","name":"Define static variables and constants - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M42S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/define-static-variables-and-constants"},{"@type":"VideoObject","name":"Create a calculation using mathematical operators - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M10S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/create-a-calculation-using-mathematical-operators"},{"@type":"VideoObject","name":"Define arrays - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT7M10S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/define-arrays"},{"@type":"VideoObject","name":"Define and use object variables - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M3S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/define-and-use-object-variables"},{"@type":"VideoObject","name":"Streamline code references using With…End With statements - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M40S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/streamline-code-references-using-with-end-with-statements"},{"@type":"VideoObject","name":"Challenge: Define variables, constants, and calculations - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT2M5S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/challenge-define-variables-constants-and-calculations"},{"@type":"VideoObject","name":"Solution: Define variables, constants, and calculations - 2. Defining Variables, Constants, and Calculations","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M13S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/solution-define-variables-constants-and-calculations"}],[{"@type":"VideoObject","name":"Repeat a task using a For…Next loop - 3. Adding Logic to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M6S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/repeat-a-task-using-a-for-next-loop"},{"@type":"VideoObject","name":"Step through all items of a collection using a For…Each loop - 3. Adding Logic to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M37S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/step-through-all-items-of-a-collection-using-a-for-each-loop"},{"@type":"VideoObject","name":"Repeat a task using a Do loop - 3. Adding Logic to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M47S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/repeat-a-task-using-a-do-loop"},{"@type":"VideoObject","name":"Execute code conditionally using an If…Then statement - 3. Adding Logic to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT6M48S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/execute-code-conditionally-using-an-if-then-statement"},{"@type":"VideoObject","name":"Select which action to take using a Case statement - 3. Adding Logic to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M42S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/select-which-action-to-take-using-a-case-statement"},{"@type":"VideoObject","name":"Challenge: Add logic to your code - 3. Adding Logic to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT2M52S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/challenge-add-logic-to-your-code"},{"@type":"VideoObject","name":"Solution: Add logic to your code - 3. Adding Logic to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M40S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/solution-add-logic-to-your-code"}],[{"@type":"VideoObject","name":"Manage errors using On Error statements - 4. Debugging Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT6M8S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/manage-errors-using-on-error-statements"},{"@type":"VideoObject","name":"Step through a subroutine or function - 4. Debugging Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT6M2S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/step-through-a-subroutine-or-function"},{"@type":"VideoObject","name":"Set breakpoints in your code - 4. Debugging Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M47S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/set-breakpoints-in-your-code"},{"@type":"VideoObject","name":"Verify output using the Immediate window - 4. Debugging Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M10S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/verify-output-using-the-immediate-window"},{"@type":"VideoObject","name":"Watch a value in a routine - 4. Debugging Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M10S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/watch-a-value-in-a-routine"},{"@type":"VideoObject","name":"Challenge: Debug your VBA code - 4. Debugging Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M38S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/challenge-debug-your-vba-code"},{"@type":"VideoObject","name":"Solution: Debug your VBA code - 4. Debugging Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M1S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/solution-debug-your-vba-code"}],[{"@type":"VideoObject","name":"Write a value to a cell - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M29S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/write-a-value-to-a-cell"},{"@type":"VideoObject","name":"Cut, copy, and paste cell data - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT6M51S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/cut-copy-and-paste-cell-data"},{"@type":"VideoObject","name":"Find values in cells - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M7S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/find-values-in-cells"},{"@type":"VideoObject","name":"Refer to cells using the OFFSET property - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M1S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/refer-to-cells-using-the-offset-property"},{"@type":"VideoObject","name":"Concatenate text strings - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M4S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/concatenate-text-strings"},{"@type":"VideoObject","name":"Return part of a string - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT6M15S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/return-part-of-a-string"},{"@type":"VideoObject","name":"Manage worksheets with VBA - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT8M30S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/manage-worksheets-with-vba"},{"@type":"VideoObject","name":"Manage workbooks with VBA - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT6M41S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/manage-workbooks-with-vba"},{"@type":"VideoObject","name":"Challenge: Manage workbook elements and data in VBA - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT2M53S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/challenge-manage-workbook-elements-and-data-in-vba"},{"@type":"VideoObject","name":"Solution: Manage workbook elements and data in VBA - 5. Manage Workbook Elements and Data in VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M8S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/solution-manage-workbook-elements-and-data-in-vba"}],[{"@type":"VideoObject","name":"Turn off screen updating when you run a macro - 6. Adding Advanced Elements to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M21S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/turn-off-screen-updating-when-you-run-a-macro"},{"@type":"VideoObject","name":"Use worksheet functions in a macro - 6. Adding Advanced Elements to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M12S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/use-worksheet-functions-in-a-macro"},{"@type":"VideoObject","name":"Acquire values using an input box or message box - 6. Adding Advanced Elements to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT6M55S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/acquire-values-using-an-input-box-or-message-box"},{"@type":"VideoObject","name":"Call a subroutine from another subroutine - 6. Adding Advanced Elements to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M46S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/call-a-subroutine-from-another-subroutine"},{"@type":"VideoObject","name":"Challenge: Add advanced elements to your workbook - 6. Adding Advanced Elements to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M35S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/challenge-add-advanced-elements-to-your-workbook"},{"@type":"VideoObject","name":"Solution: Add advanced elements to your workbook - 6. Adding Advanced Elements to Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT4M1S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/solution-add-advanced-elements-to-your-workbook"}],[{"@type":"VideoObject","name":"Run a procedure when you open, close, or save a workbook - 7. Using Excel Events in Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M35S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/run-a-procedure-when-you-open-close-or-save-a-workbook"},{"@type":"VideoObject","name":"Run a procedure when a cell range changes - 7. Using Excel Events in Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT5M37S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/run-a-procedure-when-a-cell-range-changes"},{"@type":"VideoObject","name":"Trigger a procedure using a specific key sequence - 7. Using Excel Events in Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M48S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/trigger-a-procedure-using-a-specific-key-sequence"},{"@type":"VideoObject","name":"Challenge: Use Excel events in your VBA code - 7. Using Excel Events in Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M9S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/challenge-use-excel-events-in-your-vba-code"},{"@type":"VideoObject","name":"Solution: Use Excel events in your VBA code - 7. Using Excel Events in Your VBA Code","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT3M30S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/solution-use-excel-events-in-your-vba-code"}],[{"@type":"VideoObject","name":"Further resources - Conclusion","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT1M14S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/further-resources"}]],"syllabusSections":[{"@type":"Syllabus","name":"Extend the capabilities of Excel using VBA","timeRequired":"PT26S"},{"@type":"Syllabus","name":"What you should know before starting","timeRequired":"PT1M10S"},{"@type":"Syllabus","name":"Introduce object-oriented programming","timeRequired":"PT3M2S","description":"Excel VBA is based on the object-oriented programming model. In this video, learn how to describe object-oriented programming."},{"@type":"Syllabus","name":"Examine the Excel object model","timeRequired":"PT4M14S","description":"You can explore the Excel object model from within the program. In this video, learn how to examine the Excel object model."},{"@type":"Syllabus","name":"Work in the Visual Basic Editor","timeRequired":"PT6M27S","description":"The Visual Basic Editor provides an environment to create VBA procedures. In this video, learn how to work in the Visual Basic Editor."},{"@type":"Syllabus","name":"Set VBA project properties","timeRequired":"PT4M28S","description":"Adding properties to a VBA project makes it easier to search for and interpret your workbooks. In this video, learn how to set VBA project properties."},{"@type":"Syllabus","name":"Create, export, and delete code modules","timeRequired":"PT5M54S","description":"Code modules can be created, edited, and saved for use in other workbooks. In this video, learn how to create, export, and delete code modules."},{"@type":"Syllabus","name":"Create a subroutine","timeRequired":"PT3M28S","description":"A subroutine contains code that performs a task within a workbook. In this video, learn how to create a subroutine."},{"@type":"Syllabus","name":"Create a function","timeRequired":"PT5M2S","description":"A function defines a calculation that can be used in a formula. In this video, learn how to create a function in Excel VBA."},{"@type":"Syllabus","name":"Add comments to your code","timeRequired":"PT4M47S","description":"Comments make code easier to comprehend without slowing Excel down. In this video, learn how to add comments to your code."},{"@type":"Syllabus","name":"Run a VBA procedure","timeRequired":"PT5M20S","description":"VBA procedures can be run using several methods in Excel. In this video, learn how to run a VBA procedure."},{"@type":"Syllabus","name":"Add code to a recorded macro","timeRequired":"PT3M48S","description":"Recording macros saves VBA code in a module, which you can then edit to make it more readable or add steps. In this video, learn how to add code to a recorded macro."},{"@type":"Syllabus","name":"Introduce Excel VBA data types","timeRequired":"PT4M5S","description":"Excel VBA data types change how Excel stores values in your code. In this video, learn how to introduce Excel VBA data types."},{"@type":"Syllabus","name":"Declare variables and require declaration before use","timeRequired":"PT5M27S","description":"Declaring variables makes your code easier to read and helps prevent errors. In this video, learn how to declare variables and require declaration before use."},{"@type":"Syllabus","name":"Manage variable scope","timeRequired":"PT3M50S","description":"Variables can be available at different levels of your code and workbook. In this video, learn how to manage variable scope."},{"@type":"Syllabus","name":"Define static variables and constants","timeRequired":"PT5M42S","description":"Variables can have permanent values or be updated and retain their values. In this video, learn how to define static variables and constants."},{"@type":"Syllabus","name":"Create a calculation using mathematical operators","timeRequired":"PT5M10S","description":"Mathematical operators let you perform calculations on your data in VBA. In this video, learn how to create a calculation using mathematical operators."},{"@type":"Syllabus","name":"Define arrays","timeRequired":"PT7M10S","description":"Arrays store multiple values in a set structure. In this video, learn how to define arrays."},{"@type":"Syllabus","name":"Define and use object variables","timeRequired":"PT3M3S","description":"Object variables refer to Excel workbook elements such as cell ranges or worksheets. In this video, learn how to define and use object variables."},{"@type":"Syllabus","name":"Streamline code references using With…End With statements","timeRequired":"PT4M40S","description":"Some code segments use repeated terms that can be abbreviated. In this video, learn how to streamline code references using With…End With statements."},{"@type":"Syllabus","name":"Challenge: Define variables, constants, and calculations","timeRequired":"PT2M5S","description":"Practicing defining variables, constants, and calculations helps you understand how to perform these tasks. In this video, discover a set of challenges to solve."},{"@type":"Syllabus","name":"Solution: Define variables, constants, and calculations","timeRequired":"PT3M13S","description":"Practicing defining variables, constants, and calculations helps you understand how to perform these tasks. In this video, see the answers to the challenges from the previous video."},{"@type":"Syllabus","name":"Repeat a task using a For…Next loop","timeRequired":"PT5M6S","description":"Sections of your VBA code can be repeated using a For...Next loop. In this video, learn how to repeat a task using a For…Next loop."},{"@type":"Syllabus","name":"Step through all items of a collection using a For…Each loop","timeRequired":"PT4M37S","description":"When you work with an array or collection of objects, you can define a loop to work with every element of the collection. In this video, learn how to step through all items of a collection using a For…Each loop."},{"@type":"Syllabus","name":"Repeat a task using a Do loop","timeRequired":"PT5M47S","description":"A Do loop repeats a section of code while a condition is true. In this video, learn how to repeat a task using a Do loop."},{"@type":"Syllabus","name":"Execute code conditionally using an If…Then statement","timeRequired":"PT6M48S","description":"Some code segments should only run when specific conditions are true. In this video, learn how to execute code conditionally using an If…Then statement."},{"@type":"Syllabus","name":"Select which action to take using a Case statement","timeRequired":"PT3M42S","description":"Selecting which action to take can depend on the value of a variable. In this video, learn how to select which action to take using a Case statement."},{"@type":"Syllabus","name":"Challenge: Add logic to your code","timeRequired":"PT2M52S","description":"Practicing adding logic to your VBA code helps you understand how to perform these tasks. In this video, discover a set of challenges to solve."},{"@type":"Syllabus","name":"Solution: Add logic to your code","timeRequired":"PT4M40S","description":"Practicing adding logic to your VBA code helps you understand how to perform these tasks. In this video, see the answers to the challenges from the previous video."},{"@type":"Syllabus","name":"Manage errors using On Error statements","timeRequired":"PT6M8S","description":"Programming errors will always happen, but you can use some techniques to manage them. In this video, learn how to manage errors using On Error statements."},{"@type":"Syllabus","name":"Step through a subroutine or function","timeRequired":"PT6M2S","description":"Moving through a subroutine one step at a time can help you find and fix errors in your code. In this video, learn how to step through a subroutine or function."},{"@type":"Syllabus","name":"Set breakpoints in your code","timeRequired":"PT3M47S","description":"Stopping your code at a specific line lets you verify you get the expected results up to that point. In this video, learn how to set breakpoints in your code."},{"@type":"Syllabus","name":"Verify output using the Immediate window","timeRequired":"PT5M10S","description":"You can use the Immediate window to run commands without editing your code. In this video, learn how to verify output using the Immediate window."},{"@type":"Syllabus","name":"Watch a value in a routine","timeRequired":"PT4M10S","description":"Observing how a value changes can help you evaluate your code. In this video, learn how to watch a value in a routine."},{"@type":"Syllabus","name":"Challenge: Debug your VBA code","timeRequired":"PT3M38S","description":"Practicing debugging your VBA code helps you understand how to perform these tasks. In this video, discover a set of challenges to solve."},{"@type":"Syllabus","name":"Solution: Debug your VBA code","timeRequired":"PT4M1S","description":"Practicing debugging your VBA code helps you understand how to perform these tasks. In this video, see the answers to the challenges from the previous video."},{"@type":"Syllabus","name":"Write a value to a cell","timeRequired":"PT4M29S","description":"Using VBA to write a value to a cell lets you affect your entire workbook. In this video, learn how to write a value to a cell."},{"@type":"Syllabus","name":"Cut, copy, and paste cell data","timeRequired":"PT6M51S","description":"Moving data within a workbook using VBA saves users a lot of work. In this video, learn how to cut, copy, and paste cell data."},{"@type":"Syllabus","name":"Find values in cells","timeRequired":"PT5M7S","description":"Finding and replacing cell values using VBA lets users finish their work faster. In this video, learn how to find values in cells."},{"@type":"Syllabus","name":"Refer to cells using the OFFSET property","timeRequired":"PT5M1S","description":"Referring to cells using relative references in VBA uses the OFFSET function. In this video, learn how to refer to cells using the OFFSET function."},{"@type":"Syllabus","name":"Concatenate text strings","timeRequired":"PT4M4S","description":"Concatenation combines multiple text elements into a single string. In this video, learn how to concatenate text strings."},{"@type":"Syllabus","name":"Return part of a string","timeRequired":"PT6M15S","description":"Elements of a text string can provide vital information. In this video, learn how to return part of a string."},{"@type":"Syllabus","name":"Manage worksheets with VBA","timeRequired":"PT8M30S","description":"Creating and deleting worksheets provides useful capabilities in VBA. In this video, learn how to manage worksheets with VBA."},{"@type":"Syllabus","name":"Manage workbooks with VBA","timeRequired":"PT6M41S","description":"Creating and deleting workbooks provides useful capabilities in VBA. In this video, learn how to manage workbooks with VBA."},{"@type":"Syllabus","name":"Challenge: Manage workbook elements and data in VBA","timeRequired":"PT2M53S","description":"Practicing managing workbook elements and data in your VBA code helps you understand how to perform these tasks. In this video, discover a set of challenges to solve."},{"@type":"Syllabus","name":"Solution: Manage workbook elements and data in VBA","timeRequired":"PT3M8S","description":"Practicing managing workbook elements and data in your VBA code helps you understand how to perform these tasks. In this video, see the answers to the challenges from the previous video."},{"@type":"Syllabus","name":"Turn off screen updating when you run a macro","timeRequired":"PT4M21S","description":"Avoiding screen flashes makes your VBA code more user-friendly. In this video, learn how to turn off screen updating when you run a macro."},{"@type":"Syllabus","name":"Use worksheet functions in a macro","timeRequired":"PT3M12S","description":"Rather than create every calculation in VBA, you can use built-in worksheet functions. In this video, learn how to use worksheet functions in a macro."},{"@type":"Syllabus","name":"Acquire values using an input box or message box","timeRequired":"PT6M55S","description":"User input beyond what is in a worksheet can help make your VBA code effective. In this video, learn how to acquire values using an input box or message box."},{"@type":"Syllabus","name":"Call a subroutine from another subroutine","timeRequired":"PT3M46S","description":"Organizing your code effectively often means creating small subroutines for specific tasks. In this video, learn how to call a subroutine from another subroutine."},{"@type":"Syllabus","name":"Challenge: Add advanced elements to your workbook","timeRequired":"PT3M35S","description":"Practicing adding advanced elements to your VBA code helps you understand how to perform these tasks. In this video, discover a set of challenges to solve."},{"@type":"Syllabus","name":"Solution: Add advanced elements to your workbook","timeRequired":"PT4M1S","description":"Practicing adding advanced elements to your VBA code helps you understand how to perform these tasks. In this video, see the answers to the challenges from the previous video."},{"@type":"Syllabus","name":"Run a procedure when you open, close, or save a workbook","timeRequired":"PT5M35S","description":"If you want to run a VBA procedure when a workbook opens, closes, or changes, you can create an event to do so. In this video, learn how to run a procedure when you open, close, or save a workbook."},{"@type":"Syllabus","name":"Run a procedure when a cell range changes","timeRequired":"PT5M37S","description":"If you want to run a VBA procedure when a cell range changes, you can create an event to do so. In this video, learn how to run a procedure when a cell range changes."},{"@type":"Syllabus","name":"Trigger a procedure using a specific key sequence","timeRequired":"PT3M48S","description":"If you want to run a VBA procedure-specific key sequence, you can create an event to do so. In this video, learn how to trigger a procedure using a specific key sequence."},{"@type":"Syllabus","name":"Challenge: Use Excel events in your VBA code","timeRequired":"PT3M9S","description":"Practicing using Excel events in your VBA code helps you understand how to perform these tasks. In this video, discover a set of challenges to solve."},{"@type":"Syllabus","name":"Solution: Use Excel events in your VBA code","timeRequired":"PT3M30S","description":"Practicing using Excel events in your VBA code helps you understand how to perform these tasks. In this video, see the answers to the challenges from the previous video."},{"@type":"Syllabus","name":"Further resources","timeRequired":"PT1M14S"}],"aggregateRating":{"@type":"AggregateRating","ratingCount":595,"ratingValue":4.7,"bestRating":5,"worstRating":1},"review":[{"@type":"Review","author":{"@type":"Person","name":"Simon During-Nicholson","jobTitle":"--","url":"https://uk.linkedin.com/in/simon-during-nicholson-25ab30332"},"reviewRating":{"@type":"Rating","ratingValue":5},"reviewBody":"Great course","datePublished":"2024-11-17T14:20:41.112Z","publisher":{"@type":"Organization","name":"LinkedIn"},"bestRating":5,"worstRating":1},{"@type":"Review","author":{"@type":"Person","name":"Alexander Kinlock","jobTitle":"Data Analyst at Ivy Computer, Inc.","url":"https://www.linkedin.com/in/alexander-kinlock-a41877294"},"reviewRating":{"@type":"Rating","ratingValue":3},"reviewBody":"I would love these courses so much more if I get a chance to problem solve for myself rather than being shown an already made code.","datePublished":"2024-10-17T20:16:53.344Z","publisher":{"@type":"Organization","name":"LinkedIn"},"bestRating":5,"worstRating":1},{"@type":"Review","author":{"@type":"Person","name":"Gina McKenzie","jobTitle":"Senior Accountant at Michael Kors","url":"https://www.linkedin.com/in/gina-mckenzie-21506b21"},"reviewRating":{"@type":"Rating","ratingValue":5},"reviewBody":"Great, I already have recommended it to 2 coworkers","datePublished":"2024-10-17T15:37:22.528Z","publisher":{"@type":"Organization","name":"LinkedIn"},"bestRating":5,"worstRating":1}],"video":{"@type":"VideoObject","name":"Extend the capabilities of Excel using VBA - Excel: Learning VBA","author":{"@type":"Person","name":"Curt Frye","description":"Online course developer, freelance writer, and speaker. MBA.","jobTitle":"Online course developer, freelance writer, and speaker. MBA.","url":"https://www.linkedin.com/in/curtisfrye"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&v=beta&t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w","description":"Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.","duration":"PT26S","datePublished":"2023-10-25","uploadDate":"2023-10-25","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://www.linkedin.com/learning/excel-learning-vba/extend-the-capabilities-of-excel-using-vba"},"educationalLevel":"Advanced","educationalCredentialAwarded":[{"@type":"EducationalOccupationalCredential","name":"LinkedIn Learning Certificate of Completion","url":"https://www.linkedin.com/help/learning/answer/a598944/learning-certificates-of-completion-faqs","credentialCategory":"Certificate","offers":[{"@type":"Offer","category":"Subscription"}]}]} </script> <!----> </head> <body dir="ltr"> <!----><!----><!----> <!----> <a href="#main-content" class="skip-link btn-md btn-primary absolute z-11 -top-[100vh] focus:top-0"> Skip to main content </a> <header class="header base-detail-page__header px-mobile-container-padding bg-color-background-container global-alert-offset sticky-header"> <nav class="nav pt-1.5 pb-2 flex items-center justify-between relative flex-nowrap babymamabear:py-1.5 nav--minified-mobile " aria-label="Primary"> <a href="https://www.linkedin.com/learning/?trk=learning-course_nav-header-logo" class="nav__logo-link link-no-visited-state z-1 mr-auto min-h-[52px] flex items-center babybear:z-0 hover:no-underline focus:no-underline active:no-underline babymamabear:mr-3" data-tracking-control-name="learning-course_nav-header-logo" data-tracking-will-navigate> <div class="learning-logo"> <icon class="learning-logo__inbug onload" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4zqr0f9jf98vi2nkijyc3bex2"></icon> <span class="learning-logo__text" aria-hidden="true">Learning</span> <span class="sr-only">LinkedIn Learning</span> </div> </a> <section class="search-bar relative flex flex-grow h-[40px] bg-cool-gray-20 min-w-0 max-w-full mx-4 rounded-sm babymamabear:mx-0 babymamabear:mb-1.5 babymamabear:bg-color-transparent babymamabear:w-full babymamabear:flex babymamabear:flex-wrap search-bar--minified-mobile" data-current-search-type="LEARNING"> <button class="search-bar__placeholder papabear:hidden text-input w-full mt-1.5 !pl-[14px] border-1 border-solid border-color-border-faint rounded-[2px] h-[40px] max-h-[40px] flex items-center overflow-hidden cursor-text" data-tracking-control-name="learning-course_search-switcher-opener"> <icon class="text-color-icon w-3 h-3 mr-1" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/397vrsk6op88l4981ji1xe1qt"></icon> <div class="search-bar__full-placeholder font-sans text-md text-color-text max-w-[calc(100%-40px)] text-left whitespace-nowrap overflow-hidden text-ellipsis"> <!----><!----> Search skills, subjects, or software <!----> </div> <span class="sr-only">Expand search</span> </button> <div class="switcher-tabs__trigger-and-tabs babymamabear:flex"> <button aria-expanded="false" class="switcher-tabs__placeholder flex !h-full !py-0 !pl-2 !pr-1.5 border-r-1 border-solid border-r-color-border-faint babymamabear:hidden tab-md papabear:tab-vertical papabear:justify-start cursor-pointer" data-tracking-control-name="learning-course_switcher-tabs-placeholder" aria-describedby="switcher-description"> <span class="switcher-tabs__placeholder-text m-auto"></span> <icon class="switcher-tabs__caret-down-filled onload pointer-events-none block my-auto min-h-[24px] min-w-[24px] h-[24px] babymamabear:hidden" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7asbl4deqijhoy3z2ivveispv"></icon> </button> <div id="switcher-description" class="hidden">This button displays the currently selected search type. When expanded it provides a list of search options that will switch the search inputs to match the current selection. </div> <!----> <div class="switcher-tabs hidden z-[1] w-auto min-w-[160px] mb-1.5 py-1 absolute top-[48px] left-0 border-solid border-1 border-color-border-faint papabear:container-raised babymamabear:static babymamabear:w-[100vw] babymamabear:h-[48px] babymamabear:p-0 overflow-y-hidden overflow-x-auto md:overflow-x-hidden"> <ul class="switcher-tabs__list flex flex-1 items-stretch papabear:flex-col" role="tablist"> <li class="switcher-tabs__tab h-[44px] babymamabear:basis-1/2" role="presentation"> <button aria-controls="jobs-search-panel" aria-selected="false" class="switcher-tabs__button w-full h-full tab-md papabear:tab-vertical papabear:justify-start cursor-pointer " data-switcher-type="JOBS" data-tracking-control-name="learning-course_switcher-tabs-jobs-search-switcher" id="job-switcher-tab" role="tab"> Jobs </button> </li> <li class="switcher-tabs__tab h-[44px] babymamabear:basis-1/2" role="presentation"> <button aria-controls="people-search-panel" aria-selected="false" class="switcher-tabs__button w-full h-full tab-md papabear:tab-vertical papabear:justify-start cursor-pointer " data-switcher-type="PEOPLE" data-tracking-control-name="learning-course_switcher-tabs-people-search-switcher" id="people-switcher-tab" role="tab"> People </button> </li> <li class="switcher-tabs__tab h-[44px] babymamabear:basis-1/2" role="presentation"> <button aria-controls="learning-search-panel" aria-selected="true" class="switcher-tabs__button w-full h-full tab-md papabear:tab-vertical papabear:justify-start cursor-pointer tab-selected" data-switcher-type="LEARNING" data-tracking-control-name="learning-course_switcher-tabs-learning-search-switcher" id="learning-switcher-tab" role="tab"> Learning </button> </li> </ul> <button aria-label="Close" class="switcher-tabs__cancel-btn papabear:hidden block w-6 h-6 m-auto text-color-text-low-emphasis" data-tracking-control-name="learning-course_switcher-tabs-cancel-search-switcher" type="button"> <icon class="switcher-tabs__cancel-icon block w-3 h-3 m-auto onload" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </div> </div> <section class="base-search-bar w-full h-full" data-searchbar-type="PEOPLE" aria-labelledby="people-switcher-tab" id="people-search-panel" role="tabpanel"> <form class="base-search-bar__form w-full flex babymamabear:mx-mobile-container-padding babymamabear:flex-col" role="search" action="/pub/dir" data-tracking-control-name="learning-course_people-search-bar_base-search-bar-form"> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 search-input"> <input aria-label="First Name" autocomplete="on" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_people-search-bar_first-name_dismissable-input" maxlength="500" name="firstName" placeholder="First Name" type="search"> <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_people-search-bar_first-name_dismissable-input-clear" type="button"> <label class="sr-only">Clear text</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 search-input"> <input aria-label="Last Name" autocomplete="on" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_people-search-bar_last-name_dismissable-input" maxlength="500" name="lastName" placeholder="Last Name" type="search"> <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_people-search-bar_last-name_dismissable-input-clear" type="button"> <label class="sr-only">Clear text</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section> <input name="trk" value="learning-course_people-search-bar_search-submit" type="hidden"> <button class="base-search-bar__submit-btn block basis-[40px] flex-shrink-0 cursor-pointer babymamabear:invisible babymamabear:ml-[-9999px] babymamabear:w-[1px] babymamabear:h-[1px]" aria-label="Search" data-tracking-control-name="learning-course_people-search-bar_base-search-bar-search-submit" type="submit"> <icon class="base-search-bar__search-icon onload mx-auto" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cb5bsr4tsn2r4sjg9e3ls4tjl"></icon> </button> </form> </section> <section class="base-search-bar w-full h-full" data-searchbar-type="JOBS" aria-labelledby="job-switcher-tab" id="jobs-search-panel" role="tabpanel"> <form class="base-search-bar__form w-full flex babymamabear:mx-mobile-container-padding babymamabear:flex-col" role="search" action="/jobs/search" data-tracking-control-name="learning-course_jobs-search-bar_base-search-bar-form"> <code id="i18n_aria_live_text_no-suggestions" style="display: none"><!--"No suggestions found"--></code> <code id="i18n_aria_live_text_one-suggestion" style="display: none"><!--"One Suggestion. Use up and down keys to navigate"--></code> <code id="i18n_aria_live_text_multiple-suggestions" style="display: none"><!--"Multiple Suggestions. Use up and down keys to navigate"--></code> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 typeahead-input keywords-typeahead-input text-input"> <input aria-autocomplete="list" aria-controls="job-search-bar-keywords-typeahead-list" aria-haspopup="listbox" aria-label="Search job titles or companies" autocomplete="off" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_dismissable-input" id="job-search-bar-keywords" maxlength="500" name="keywords" placeholder="Search job titles or companies" role="combobox" type="search"> <!----> <div class="typeahead-input__dropdown container-lined absolute top-[calc(100%+3px)] left-0 w-full rounded-b-md rounded-t-none z-[10] overflow-hidden max-w-none babybear:min-w-full babybear:bottom-0 babybear:overflow-y-auto"> <template class="typeahead-item-template"> <li class="typeahead-input__dropdown-item py-1.5 px-2 hover:cursor-pointer hover:bg-color-surface-new-hover hover:border-y-2 hover:border-solid hover:border-color-container-primary" role="option"> <span class="typeahead-input__dropdown-text font-sans text-sm font-bold text-color-text"></span> </li> </template> <ul class="typeahead-input__dropdown-list w-full" id="job-search-bar-keywords-typeahead-list" role="listbox"></ul> </div> <!----> <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_dismissable-input-clear" type="button"> <label class="sr-only">Clear text</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section> <!----> <code id="i18n_aria_live_text_no-suggestions" style="display: none"><!--"No suggestions found"--></code> <code id="i18n_aria_live_text_one-suggestion" style="display: none"><!--"One Suggestion. Use up and down keys to navigate"--></code> <code id="i18n_aria_live_text_multiple-suggestions" style="display: none"><!--"Multiple Suggestions. Use up and down keys to navigate"--></code> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 typeahead-input location-typeahead-input"> <input aria-autocomplete="list" aria-controls="job-search-bar-location-typeahead-list" aria-haspopup="listbox" aria-label="Location" autocomplete="off" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_dismissable-input" id="job-search-bar-location" maxlength="500" name="location" placeholder="Location" role="combobox" value="Hong Kong" type="search"> <!----> <div class="typeahead-input__dropdown container-lined absolute top-[calc(100%+3px)] left-0 w-full rounded-b-md rounded-t-none z-[10] overflow-hidden max-w-none babybear:min-w-full babybear:bottom-0 babybear:overflow-y-auto"> <template class="typeahead-item-template"> <li class="typeahead-input__dropdown-item py-1.5 px-2 hover:cursor-pointer hover:bg-color-surface-new-hover hover:border-y-2 hover:border-solid hover:border-color-container-primary" role="option"> <span class="typeahead-input__dropdown-text font-sans text-sm font-bold text-color-text"></span> </li> </template> <ul class="typeahead-input__dropdown-list w-full" id="job-search-bar-location-typeahead-list" role="listbox"></ul> </div> <!----> <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_dismissable-input-clear" type="button"> <label class="sr-only">Clear text</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section> <input name="geoId" value="102817007" type="hidden"> <input name="trk" value="learning-course_jobs-search-bar_search-submit" type="hidden"> <button class="base-search-bar__submit-btn block basis-[40px] flex-shrink-0 cursor-pointer babymamabear:invisible babymamabear:ml-[-9999px] babymamabear:w-[1px] babymamabear:h-[1px]" aria-label="Search" data-tracking-control-name="learning-course_jobs-search-bar_base-search-bar-search-submit" type="submit"> <icon class="base-search-bar__search-icon onload mx-auto" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cb5bsr4tsn2r4sjg9e3ls4tjl"></icon> </button> </form> </section> <section class="base-search-bar w-full h-full" data-searchbar-type="LEARNING" aria-labelledby="learning-switcher-tab" id="learning-search-panel" role="tabpanel"> <form class="base-search-bar__form w-full flex babymamabear:mx-mobile-container-padding babymamabear:flex-col" role="search" action="/learning/search" data-tracking-control-name="learning-course_learning-search-bar_base-search-bar-form"> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 search-input"> <input aria-label="Search skills, subjects, or software" autocomplete="on" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_learning-search-bar_keywords_dismissable-input" maxlength="500" name="keywords" placeholder="Search skills, subjects, or software" type="search"> <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_learning-search-bar_keywords_dismissable-input-clear" type="button"> <label class="sr-only">Clear text</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section> <input class="nav__search-uoo" name="upsellOrderOrigin" type="hidden"> <input name="trk" value="learning-course_learning-search-bar_search-submit" type="hidden"> <button class="base-search-bar__submit-btn block basis-[40px] flex-shrink-0 cursor-pointer babymamabear:invisible babymamabear:ml-[-9999px] babymamabear:w-[1px] babymamabear:h-[1px]" aria-label="Search" data-tracking-control-name="learning-course_learning-search-bar_base-search-bar-search-submit" type="submit"> <icon class="base-search-bar__search-icon onload mx-auto" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cb5bsr4tsn2r4sjg9e3ls4tjl"></icon> </button> </form> </section> <!----> <div aria-live="polite" class="search-bar__live-text sr-only" role="status"></div> </section> <!----> <div class="nav__cta-container order-3 flex gap-x-1 justify-end min-w-[100px] flex-nowrap flex-shrink-0 babybear:flex-wrap flex-2 babymamabear:min-w-[50px] "> <a class="nav__button-tertiary btn-md btn-tertiary" href="http://www.linkedin.com/learning/subscription/products?courseSlug=excel-learning-vba&amp;destRedirectURL=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba&amp;trk=learning-course_nav-header-join&amp;upsellTrk=lil_upsell_nav_subscription&amp;session_redirect=https%3A%2F%2Fwww.linkedin.com%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card" data-tracking-control-name="lil_upsell_nav_subscription" data-tracking-impression-name="lil_upsell_nav_subscription" data-test-live-nav-primary-cta data-tracking-will-navigate> Start free trial </a> <a class="nav__button-secondary btn-md btn-secondary-emphasis" href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&amp;fromSignIn=true&amp;session_redirect=https%3A%2F%2Fwww.linkedin.com%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card&amp;trk=learning-course_nav-header-signin" data-tracking-control-name="learning-course_nav-header-signin" data-tracking-will-navigate> Sign in </a> <a aria-label="Sign in" class="nav__link-person papabear:hidden mamabear:hidden" data-tracking-control-name="learning-course_nav-header-signin" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&amp;fromSignIn=true&amp;session_redirect=https%3A%2F%2Fwww.linkedin.com%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card&amp;trk=learning-course_nav-header-signin"> <img class="inline-block relative rounded-[50%] w-4 h-4 bg-color-entity-ghost-background" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt> </a> </div> <!----> <!----> </nav> </header> <!----> <div class="cta-banner "> <div class="enterprise-nav"> <div class="enterprise-nav__content-wrapper"> <p id="enterprise-nav-solutions" class="enterprise-nav__content" tabindex="-1"> Solutions for: </p> <a href="https://learning.linkedin.com/for-entire-companies?src=li-learning-nav&trk=learning-course_enterprise-nav" aria-labelledby="enterprise-nav-solutions business-nav-business" class="enterprise-nav__content" data-tracking-control-name="learning-course_enterprise-nav" data-tracking-will-navigate="true" id="business-nav-business">Business</a> <a href="https://learning.linkedin.com/for-higher-education?src=li-learning-nav&trk=learning-course_enterprise-nav" aria-labelledby="enterprise-nav-solutions business-nav-education" class="enterprise-nav__content" data-tracking-control-name="learning-course_enterprise-nav" data-tracking-will-navigate="true" id="business-nav-education">Higher Education</a> <a href="https://learning.linkedin.com/for-governments?src=li-learning-nav&trk=learning-course_enterprise-nav" aria-labelledby="enterprise-nav-solutions business-nav-government" class="enterprise-nav__content" data-tracking-control-name="learning-course_enterprise-nav" data-tracking-will-navigate="true" id="business-nav-government">Government</a> <a href="/learning/subscription/teams?veh=lil_upx&src=li-learning-nav&trk=learning-course_enterprise-nav" aria-labelledby="enterprise-nav-solutions business-nav-buy" class="enterprise-nav__content" data-test-live-enterprise-upsell="true" data-tracking-control-name="learning-course_enterprise-nav" data-tracking-will-navigate="true" data-tracking-impression-name="lil_upsell_learning-course_enterprise-nav_teambuy" id="business-nav-buy">Buy for my team</a> </div> </div> <!----> <!----> </div> <main class="main papabear:flex papabear:w-content-max-w papabear:mx-auto papabear:pt-desktop-content-top-margin mamabear:pt-desktop-content-top-margin " id="main-content" role="main"> <section class="core-rail mx-auto papabear:w-core-rail-width mamabear:max-w-[790px] babybear:max-w-[790px]"> <ol class="breadcrumb__list"> <li class="breadcrumb__item"> <a class="breadcrumb__link" href="https://www.linkedin.com/learning/browse?trk=learning-course_breadcrumb" data-tracking-control-name="learning-course_breadcrumb" data-tracking-will-navigate>All topics</a> </li> <li class="breadcrumb__item"> <a class="breadcrumb__link" href="https://www.linkedin.com/learning/topics/business?trk=learning-course_breadcrumb" data-tracking-control-name="learning-course_breadcrumb" data-tracking-will-navigate>Business</a> </li> <li class="breadcrumb__item"> <a class="breadcrumb__link" href="https://www.linkedin.com/learning/topics/business-software-and-tools?trk=learning-course_breadcrumb" data-tracking-control-name="learning-course_breadcrumb" data-tracking-will-navigate>Business Software and Tools</a> </li> <li class="breadcrumb__item"> <a class="breadcrumb__link" href="https://www.linkedin.com/learning/topics/spreadsheets?trk=learning-course_breadcrumb" data-tracking-control-name="learning-course_breadcrumb" data-tracking-will-navigate>Spreadsheets</a> </li> </ol> <script type="application/ld+json"> {"@context":"http://schema.org/","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"All topics","item":"https://www.linkedin.com/learning/browse"},{"@type":"ListItem","position":2,"name":"Business","item":"https://www.linkedin.com/learning/topics/business"},{"@type":"ListItem","position":3,"name":"Business Software and Tools","item":"https://www.linkedin.com/learning/topics/business-software-and-tools"},{"@type":"ListItem","position":4,"name":"Spreadsheets","item":"https://www.linkedin.com/learning/topics/spreadsheets"}]} </script> <section class="top-card-layout container-lined overflow-hidden babybear:rounded-[0px]"> <section class="top-card__image-container"> <img class="top-card__image" alt="Excel: Learning VBA" data-delayed-url="https://media.licdn.com/dms/image/v2/D4E0DAQGOnMimvSPjpQ/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1698103801272?e=2147483647&amp;v=beta&amp;t=PAtcLD9Gjlo3VVR_8q6fsdU0B42AaduUXKOQT5Rds6w"> <a class="top-card__overlay-button" data-tracking-control-name="course_preview" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/extend-the-capabilities-of-excel-using-vba?autoplay=true&amp;trk=course_preview"> <span class="top-card__preview-cta "> <icon class="top-card__preview-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l"> </icon> <span class="top-card__preview-cta-text">Preview</span> </span> <!----> </a> </section> <div class="top-card-layout__card relative p-2 papabear:p-details-container-padding"> <div class="top-card-layout__entity-info-container flex flex-wrap papabear:flex-nowrap"> <div class="top-card-layout__entity-info flex-grow flex-shrink-0 basis-0 babybear:flex-none babybear:w-full babybear:flex-none babybear:w-full"> <h1 class="top-card-layout__title font-sans text-lg papabear:text-xl font-bold leading-open text-color-text mb-0"> Excel: Learning VBA </h1> <h2 class="top-card-layout__headline break-words font-sans text-md leading-open text-color-text"> <div class="top-card__headline-row"> <span class="top-card__headline-row-item top-card__headline-row-item--large">With Curt Frye</span> <span class="top-card__headline-row-item">Liked by 5,959 users</span> </div> <div class="top-card__headline-row"> <span class="top-card__headline-row-item">Duration: 4h 20m</span> <span class="top-card__headline-row-item">Skill level: Advanced</span> <span class="top-card__headline-row-item">Released: 10/25/2023</span> </div> </h2> <!----> <!----> <div class="top-card-layout__cta-container flex flex-wrap mt-0.5 papabear:mt-0 ml-[-12px]"> <a href="http://www.linkedin.com/learning/subscription/products?courseSlug=excel-learning-vba&amp;destRedirectURL=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba&amp;trk=course_info&amp;upsellTrk=lil_upsell_course_info_subscription" data-tracking-control-name="lil_upsell_course_info_subscription" data-tracking-impression-name="lil_upsell_course_info_subscription" data-litms-tracking-control-name="lil_upsell_course_info_subscription" data-tracking-will-navigate class="top-card__upsell-link top-card-layout__cta mt-2 ml-1.5 h-auto babybear:flex-auto top-card-layout__cta--primary btn-md btn-primary" data-test-live-course-sub-upsell> Start my 1-month free trial </a> <a class="buy-for-your-team-cta__link top-card-layout__cta mt-2 ml-1.5 h-auto babybear:flex-auto top-card-layout__cta--secondary btn-md btn-secondary" href="/learning/subscription/teams?veh=lil_upx&amp;src=li-lil-upsell&amp;trk=learning-course_buy-for-your-team-cta" data-tracking-control-name="learning-course_buy-for-your-team-cta" data-tracking-impression-name="lil_upsell_learning-course_buy-for-your-team-cta_teambuy" data-test-live-buy-for-your-team-upsell data-tracking-will-navigate> Buy for my team </a> </div> </div> <!----> </div> <!----> <!----> </div> </section> <div class="details mx-details-container-padding"> <section class="core-section-container my-3 course-details"> <!----> <h2 class="core-section-container__title section-title"> Course details </h2> <!----> <div class="core-section-container__content break-words"> <section class="show-more-less-html course-details__description" data-max-lines="4"> <div class="show-more-less-html__markup show-more-less-html__markup--clamp-after-4 relative overflow-hidden"> VBA allows you to automate routine tasks in Excel, and it's easier to learn than you might think. In this course, Excel expert Curt Frye presents a thorough introduction to the Visual Basic for Applications programming language. Learn how to create subroutines and functions to hold code, and gain a solid grounding in the Excel object model. Explore programming techniques through real-world examples and the exercise files that accompany the course. Find out how to work with the Visual Basic Editor, add code to a macro, and create, export, and delete code modules. Go over declaring and using variables, managing variable scope, and defining arrays. Discover ways to use VBA to manage your workbooks and spreadsheets. Learn how to simplify repeating tasks with loops and debug VBA code. Practice cutting, copying, and pasting cell data, as well as running and triggering event procedures. Plus, use practical challenges to apply what you’ve learned. </div> <button class="show-more-less-html__button show-more-less-button show-more-less-html__button--more ml-0.5" data-tracking-control-name="learning-course_show-more-html-btn" aria-label="i18n_show_more" aria-expanded="false"> <!----> Show more <icon class="show-more-less-html__button-icon show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less-html__button show-more-less-button show-more-less-html__button--less ml-0.5" data-tracking-control-name="learning-course_show-less-html-btn" aria-label="i18n_show_less" aria-expanded="true"> <!----> Show less <icon class="show-more-less-html__button-icon show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <!----> </section> </div> </section> <section class="core-section-container my-3 course-skills"> <!----> <h2 class="core-section-container__title section-title"> Skills you’ll gain </h2> <!----> <div class="core-section-container__content break-words"> <ul class="course-skills__skill-list"> <li class="course-skills__skill-list-item"> <a href="https://www.linkedin.com/learning/search?keywords=VBA+Excel&amp;trk=learning-course_pill-list" data-tracking-control-name="learning-course_pill-list" data-tracking-will-navigate class="pill flex w-fit mr-[6px] mb-1 hover:no-underline skill-pill"> VBA Excel </a> </li> <li class="course-skills__skill-list-item"> <a href="https://www.linkedin.com/learning/topics/microsoft-excel?trk=learning-course_pill-list" data-tracking-control-name="learning-course_pill-list" data-tracking-will-navigate class="pill flex w-fit mr-[6px] mb-1 hover:no-underline skill-pill"> Microsoft Excel </a> </li> </ul> </div> </section> <section class="core-section-container my-3"> <!----> <h2 class="core-section-container__title section-title"> Earn a sharable certificate </h2> <!----> <div class="core-section-container__content break-words"> <p class="course-certificate__body-paragraph">Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.</p> <div class="course-certificate__image-container"> <img class="course-certificate__certificate-image" alt="Sample certificate" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/52nu8qc7cfcn7vrftr7ttceqt"> <div> <h3 class="course-certificate__detail-list-heading"> <div class="learning-logo"> <icon class="learning-logo__inbug onload" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4zqr0f9jf98vi2nkijyc3bex2"></icon> <span class="learning-logo__text learning-logo__text--show-on-mobile" aria-hidden="true">Learning</span> <span class="sr-only">LinkedIn Learning</span> </div> <span>Certificate of Completion</span> </h3> <ul> <li class="course-certificate__detail-list-item"> <div class="course-certificate__detail-list-item-icon-wrapper"><icon data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5lqa4dj5v9gp6yjh6s6iwtdbb"></icon></div> <p class="course-certificate__detail-list-item-text">Showcase on your LinkedIn profile under “Licenses and Certificate” section</p> </li> <li class="course-certificate__detail-list-item"> <div class="course-certificate__detail-list-item-icon-wrapper"><icon data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5lqa4dj5v9gp6yjh6s6iwtdbb"></icon></div> <p class="course-certificate__detail-list-item-text">Download or print out as PDF to share with others</p> </li> <li class="course-certificate__detail-list-item"> <div class="course-certificate__detail-list-item-icon-wrapper"><icon data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5lqa4dj5v9gp6yjh6s6iwtdbb"></icon></div> <p class="course-certificate__detail-list-item-text">Share as image online to demonstrate your skill</p> </li> </ul> </div> </div> </div> </section> <section class="core-section-container my-3 course-instructors"> <!----> <h2 class="core-section-container__title section-title"> Meet the instructor </h2> <!----> <div class="core-section-container__content break-words"> <ul class="course-instructors__list"> <li class="course-instructors__list-item"> <a href="https://www.linkedin.com/in/curtisfrye?trk=learning-course_instructor" target="_self" data-tracking-control-name="learning-course_instructor" data-tracking-will-navigate class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-main-card flex flex-wrap py-2 pr-2 babybear:pr-0 base-main-card--link"> <!----> <img class="inline-block relative rounded-[50%] w-6 h-6 bg-color-entity-ghost-background" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Click here to view Curt Frye’s instructor page"> <div class="base-main-card__info self-center ml-1 flex-1 relative break-words papabear:min-w-0 mamabear:min-w-0 babybear:w-full"> <h3 class="base-main-card__title font-sans text-[18px] font-bold text-color-text overflow-hidden "> Curt Frye </h3> <h4 class="base-main-card__subtitle body-text text-color-text overflow-hidden"> Online course developer, freelance writer, and speaker. MBA. </h4> <!----> <!----> </div> <!----> </a> </li> </ul> </div> </section> <section class="core-section-container my-3 reviews-feed"> <!----> <h2 class="core-section-container__title section-title"> Learner reviews </h2> <!----> <div class="core-section-container__content break-words"> <div class="reviews-feed__ratings-summary"> <section class="ratings-summary"> <div class="ratings-summary__overall-rating"> <h3 class="ratings-summary__header"><span class="ratings-summary__rating-average">4.7</span> <span class="ratings-summary__rating-max">out of 5</span></h3> <figure class="ratings-summary__figure"> <span class="star-rating" role="img" aria-label="Rating: 4.7 out of 5 stars"> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7dacecy4xq1otzk8pae2g0hxd"></icon> </span> </span> <figcaption class="ratings-summary__ratings-total">595 ratings</figcaption> </figure> </div> <div class="ratings-summary__breakdown"> <div class="ratings-summary__disclaimer"> <div class="tooltip"> <button class="tooltip__trigger ratings-summary__disclaimer-trigger" data-tracking-control-name="toggle_disclaimer" type="button"> <icon class="ratings-summary__disclaimer-icon" data-svg-class-name="ratings-summary__disclaimer-icon-svg" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/g8uts9v3k83n9e3iyvcxit0k"> </icon> <span class="ratings-summary__disclaimer-text">How are ratings calculated?</span> </button> <span role="tooltip" class="tooltip__popup" aria-hidden="true"> The overall rating is calculated using the average of submitted ratings. Ratings and reviews can only be submitted when non-anonymous learners complete at least 40% of the course. This helps us avoid fake reviews and spam. </span> </div> </div> <ul> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 5 star </figcaption> <progress class="ratings-summary__progress-bar" max="595" value="468" aria-valuemin="0" aria-valuenow="468" aria-valuemax="595"> Current value: 468 </progress> <span class="ratings-summary__rating-count-percent"> 79% </span> </figure> </li> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 4 star </figcaption> <progress class="ratings-summary__progress-bar" max="595" value="97" aria-valuemin="0" aria-valuenow="97" aria-valuemax="595"> Current value: 97 </progress> <span class="ratings-summary__rating-count-percent"> 16% </span> </figure> </li> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 3 star </figcaption> <progress class="ratings-summary__progress-bar" max="595" value="23" aria-valuemin="0" aria-valuenow="23" aria-valuemax="595"> Current value: 23 </progress> <span class="ratings-summary__rating-count-percent"> 4% </span> </figure> </li> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 2 star </figcaption> <progress class="ratings-summary__progress-bar" max="595" value="3" aria-valuemin="0" aria-valuenow="3" aria-valuemax="595"> Current value: 3 </progress> <span class="ratings-summary__rating-count-percent"> &#60;1% </span> </figure> </li> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 1 star </figcaption> <progress class="ratings-summary__progress-bar" max="595" value="4" aria-valuemin="0" aria-valuenow="4" aria-valuemax="595"> Current value: 4 </progress> <span class="ratings-summary__rating-count-percent"> &#60;1% </span> </figure> </li> </ul> </div> </section> </div> <ul class="reviews-feed__reviews-list"> <li class="reviews-feed__reviews-list-item"> <div class="review-card"> <div class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-main-card flex flex-wrap py-2 pr-2 babybear:pr-0 base-main-card--link review-card__entity"> <a class="base-card__full-link absolute top-0 right-0 bottom-0 left-0 p-0 z-[2]" href="https://uk.linkedin.com/in/simon-during-nicholson-25ab30332?trk=learning-course" data-tracking-control-name="learning-course" data-tracking-will-navigate> <span class="sr-only"> Simon During-Nicholson <!----> </span> </a> <img class="inline-block relative rounded-[50%] w-6 h-6 bg-color-entity-ghost-background" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Simon During-Nicholson"> <div class="base-main-card__info self-center ml-1 flex-1 relative break-words papabear:min-w-0 mamabear:min-w-0 babybear:w-full"> <h3 class="base-main-card__title font-sans text-[18px] font-bold text-color-text overflow-hidden "> Simon During-Nicholson <!----> </h3> <h4 class="base-main-card__subtitle body-text text-color-text overflow-hidden"> -- </h4> <!----> <div class="body-text text-color-text-low-emphasis base-main-card__metadata"> <div class="review-card__content"> <div class="review-card__centered-row"> <div class="review-card__star-container"> <span class="star-rating" role="img" aria-label="Rating: 5 out of 5 stars"> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> </span> </div> <span class="review-card__rating"> 5/5 </span> <span class="review-card__date"> November 17, 2024 </span> </div> <div class="review-card__text"> Great course </div> <div class="review-card__centered-row review-card__actions"> <a class="review-card__centered-row review-card__action-button" aria-label="Simon During-Nicholson’s comment is helpful" data-tracking-control-name="learning-course_review-card-helpful-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&amp;trk=learning-course_review-card-helpful-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5ptx189gjbxrh9wf3ncsehms9" data-svg-class-name="review-card__like-icon"></icon> Helpful </a> <span class="review-card__dot-delimiter">·</span> <a class="review-card__centered-row review-card__action-button" aria-label="Report Simon During-Nicholson’s comment" data-tracking-control-name="learning-course_review-card-report-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&amp;trk=learning-course_review-card-report-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/d04ze1wt0ev8ck8e4ovqk762o" data-svg-class-name="review-card__flag-icon"></icon> Report </a> </div> </div> </div> </div> <!----> </div> </div> </li> <li class="reviews-feed__reviews-list-item"> <div class="review-card"> <div class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-main-card flex flex-wrap py-2 pr-2 babybear:pr-0 base-main-card--link review-card__entity"> <a class="base-card__full-link absolute top-0 right-0 bottom-0 left-0 p-0 z-[2]" href="https://www.linkedin.com/in/alexander-kinlock-a41877294?trk=learning-course" data-tracking-control-name="learning-course" data-tracking-will-navigate> <span class="sr-only"> Alexander Kinlock <!----> </span> </a> <img class="inline-block relative rounded-[50%] w-6 h-6 bg-color-entity-ghost-background" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Alexander Kinlock"> <div class="base-main-card__info self-center ml-1 flex-1 relative break-words papabear:min-w-0 mamabear:min-w-0 babybear:w-full"> <h3 class="base-main-card__title font-sans text-[18px] font-bold text-color-text overflow-hidden "> Alexander Kinlock <!----> </h3> <h4 class="base-main-card__subtitle body-text text-color-text overflow-hidden"> Data Analyst at Ivy Computer, Inc. </h4> <!----> <div class="body-text text-color-text-low-emphasis base-main-card__metadata"> <div class="review-card__content"> <div class="review-card__centered-row"> <div class="review-card__star-container"> <span class="star-rating" role="img" aria-label="Rating: 3 out of 5 stars"> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0hq4l058yoqerjsrssp5pbr0"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0hq4l058yoqerjsrssp5pbr0"></icon> </span> </span> </div> <span class="review-card__rating"> 3/5 </span> <span class="review-card__date"> October 17, 2024 </span> </div> <div class="review-card__text"> I would love these courses so much more if I get a chance to problem solve for myself rather than being shown an already made code. </div> <div class="review-card__centered-row review-card__actions"> <a class="review-card__centered-row review-card__action-button" aria-label="Alexander Kinlock’s comment is helpful" data-tracking-control-name="learning-course_review-card-helpful-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&amp;trk=learning-course_review-card-helpful-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5ptx189gjbxrh9wf3ncsehms9" data-svg-class-name="review-card__like-icon"></icon> Helpful </a> <span class="review-card__dot-delimiter">·</span> <a class="review-card__centered-row review-card__action-button" aria-label="Report Alexander Kinlock’s comment" data-tracking-control-name="learning-course_review-card-report-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&amp;trk=learning-course_review-card-report-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/d04ze1wt0ev8ck8e4ovqk762o" data-svg-class-name="review-card__flag-icon"></icon> Report </a> </div> </div> </div> </div> <!----> </div> </div> </li> <li class="reviews-feed__reviews-list-item"> <div class="review-card"> <div class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-main-card flex flex-wrap py-2 pr-2 babybear:pr-0 base-main-card--link review-card__entity"> <a class="base-card__full-link absolute top-0 right-0 bottom-0 left-0 p-0 z-[2]" href="https://www.linkedin.com/in/gina-mckenzie-21506b21?trk=learning-course" data-tracking-control-name="learning-course" data-tracking-will-navigate> <span class="sr-only"> Gina McKenzie <!----> </span> </a> <img class="inline-block relative rounded-[50%] w-6 h-6 bg-color-entity-ghost-background" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Gina McKenzie"> <div class="base-main-card__info self-center ml-1 flex-1 relative break-words papabear:min-w-0 mamabear:min-w-0 babybear:w-full"> <h3 class="base-main-card__title font-sans text-[18px] font-bold text-color-text overflow-hidden "> Gina McKenzie <!----> </h3> <h4 class="base-main-card__subtitle body-text text-color-text overflow-hidden"> Senior Accountant at Michael Kors </h4> <!----> <div class="body-text text-color-text-low-emphasis base-main-card__metadata"> <div class="review-card__content"> <div class="review-card__centered-row"> <div class="review-card__star-container"> <span class="star-rating" role="img" aria-label="Rating: 5 out of 5 stars"> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> </span> </div> <span class="review-card__rating"> 5/5 </span> <span class="review-card__date"> October 17, 2024 </span> </div> <div class="review-card__text"> Great, I already have recommended it to 2 coworkers </div> <div class="review-card__centered-row review-card__actions"> <a class="review-card__centered-row review-card__action-button" aria-label="Gina McKenzie’s comment is helpful" data-tracking-control-name="learning-course_review-card-helpful-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&amp;trk=learning-course_review-card-helpful-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5ptx189gjbxrh9wf3ncsehms9" data-svg-class-name="review-card__like-icon"></icon> Helpful </a> <span class="review-card__dot-delimiter">·</span> <a class="review-card__centered-row review-card__action-button" aria-label="Report Gina McKenzie’s comment" data-tracking-control-name="learning-course_review-card-report-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fexcel-learning-vba%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&amp;trk=learning-course_review-card-report-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/d04ze1wt0ev8ck8e4ovqk762o" data-svg-class-name="review-card__flag-icon"></icon> Report </a> </div> </div> </div> </div> <!----> </div> </div> </li> </ul> </div> </section> </div> </section> <section class="right-rail papabear:w-right-rail-width papabear:ml-column-gutter mamabear:max-w-[790px] mamabear:px-mobile-container-padding babybear:max-w-[790px] babybear:px-mobile-container-padding"> <section class="table-of-contents mb-4 table-of-contents--with-max-height"> <h2 class="table-of-contents__header"> Contents </h2> <ul class="table-of-contents__list"> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> Introduction <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> Introduction <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/extend-the-capabilities-of-excel-using-vba?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Extend the capabilities of Excel using VBA </div> <div class="table-of-contents__item-duration"> 26s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/what-you-should-know-before-starting?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> What you should know before starting </div> <div class="table-of-contents__item-duration"> 1m 10s </div> </div> </a> </li> </ul> <!----> </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 1. Introducing Visual Basic for Applications <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 1. Introducing Visual Basic for Applications <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/introduce-object-oriented-programming?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Introduce object-oriented programming </div> <div class="table-of-contents__item-duration"> 3m 2s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/examine-the-excel-object-model?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Examine the Excel object model </div> <div class="table-of-contents__item-duration"> 4m 14s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/work-in-the-visual-basic-editor?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Work in the Visual Basic Editor </div> <div class="table-of-contents__item-duration"> 6m 27s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/set-vba-project-properties?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Set VBA project properties </div> <div class="table-of-contents__item-duration"> 4m 28s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/create-export-and-delete-code-modules?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Create, export, and delete code modules </div> <div class="table-of-contents__item-duration"> 5m 54s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/create-a-subroutine?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Create a subroutine </div> <div class="table-of-contents__item-duration"> 3m 28s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/create-a-function?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Create a function </div> <div class="table-of-contents__item-duration"> 5m 2s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/add-comments-to-your-code?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Add comments to your code </div> <div class="table-of-contents__item-duration"> 4m 47s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/run-a-vba-procedure?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Run a VBA procedure </div> <div class="table-of-contents__item-duration"> 5m 20s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/add-code-to-a-recorded-macro?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Add code to a recorded macro </div> <div class="table-of-contents__item-duration"> 3m 48s </div> </div> </a> </li> </ul> <!----> </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 2. Defining Variables, Constants, and Calculations <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 2. Defining Variables, Constants, and Calculations <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/introduce-excel-vba-data-types?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Introduce Excel VBA data types </div> <div class="table-of-contents__item-duration"> 4m 5s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/declare-variables-and-require-declaration-before-use?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Declare variables and require declaration before use </div> <div class="table-of-contents__item-duration"> 5m 27s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/manage-variable-scope?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Manage variable scope </div> <div class="table-of-contents__item-duration"> 3m 50s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/define-static-variables-and-constants?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Define static variables and constants </div> <div class="table-of-contents__item-duration"> 5m 42s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/create-a-calculation-using-mathematical-operators?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Create a calculation using mathematical operators </div> <div class="table-of-contents__item-duration"> 5m 10s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/define-arrays?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Define arrays </div> <div class="table-of-contents__item-duration"> 7m 10s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/define-and-use-object-variables?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Define and use object variables </div> <div class="table-of-contents__item-duration"> 3m 3s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/streamline-code-references-using-with-end-with-statements?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Streamline code references using With…End With statements </div> <div class="table-of-contents__item-duration"> 4m 40s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/challenge-define-variables-constants-and-calculations?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Challenge: Define variables, constants, and calculations </div> <div class="table-of-contents__item-duration"> 2m 5s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/solution-define-variables-constants-and-calculations?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Solution: Define variables, constants, and calculations </div> <div class="table-of-contents__item-duration"> 3m 13s </div> </div> </a> </li> </ul> <!----> </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 3. Adding Logic to Your VBA Code <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 3. Adding Logic to Your VBA Code <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/repeat-a-task-using-a-for-next-loop?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Repeat a task using a For…Next loop </div> <div class="table-of-contents__item-duration"> 5m 6s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/step-through-all-items-of-a-collection-using-a-for-each-loop?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Step through all items of a collection using a For…Each loop </div> <div class="table-of-contents__item-duration"> 4m 37s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/repeat-a-task-using-a-do-loop?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Repeat a task using a Do loop </div> <div class="table-of-contents__item-duration"> 5m 47s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/execute-code-conditionally-using-an-if-then-statement?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Execute code conditionally using an If…Then statement </div> <div class="table-of-contents__item-duration"> 6m 48s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/select-which-action-to-take-using-a-case-statement?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Select which action to take using a Case statement </div> <div class="table-of-contents__item-duration"> 3m 42s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/challenge-add-logic-to-your-code?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Challenge: Add logic to your code </div> <div class="table-of-contents__item-duration"> 2m 52s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/solution-add-logic-to-your-code?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Solution: Add logic to your code </div> <div class="table-of-contents__item-duration"> 4m 40s </div> </div> </a> </li> </ul> <!----> </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 4. Debugging Your VBA Code <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 4. Debugging Your VBA Code <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/manage-errors-using-on-error-statements?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Manage errors using On Error statements </div> <div class="table-of-contents__item-duration"> 6m 8s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/step-through-a-subroutine-or-function?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Step through a subroutine or function </div> <div class="table-of-contents__item-duration"> 6m 2s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/set-breakpoints-in-your-code?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Set breakpoints in your code </div> <div class="table-of-contents__item-duration"> 3m 47s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/verify-output-using-the-immediate-window?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Verify output using the Immediate window </div> <div class="table-of-contents__item-duration"> 5m 10s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/watch-a-value-in-a-routine?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Watch a value in a routine </div> <div class="table-of-contents__item-duration"> 4m 10s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/challenge-debug-your-vba-code?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Challenge: Debug your VBA code </div> <div class="table-of-contents__item-duration"> 3m 38s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/solution-debug-your-vba-code?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Solution: Debug your VBA code </div> <div class="table-of-contents__item-duration"> 4m 1s </div> </div> </a> </li> </ul> <!----> </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 5. Manage Workbook Elements and Data in VBA <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 5. Manage Workbook Elements and Data in VBA <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/write-a-value-to-a-cell?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Write a value to a cell </div> <div class="table-of-contents__item-duration"> 4m 29s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/cut-copy-and-paste-cell-data?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Cut, copy, and paste cell data </div> <div class="table-of-contents__item-duration"> 6m 51s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/find-values-in-cells?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Find values in cells </div> <div class="table-of-contents__item-duration"> 5m 7s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/refer-to-cells-using-the-offset-property?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Refer to cells using the OFFSET property </div> <div class="table-of-contents__item-duration"> 5m 1s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/concatenate-text-strings?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Concatenate text strings </div> <div class="table-of-contents__item-duration"> 4m 4s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/return-part-of-a-string?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Return part of a string </div> <div class="table-of-contents__item-duration"> 6m 15s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/manage-worksheets-with-vba?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Manage worksheets with VBA </div> <div class="table-of-contents__item-duration"> 8m 30s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/manage-workbooks-with-vba?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Manage workbooks with VBA </div> <div class="table-of-contents__item-duration"> 6m 41s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/challenge-manage-workbook-elements-and-data-in-vba?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Challenge: Manage workbook elements and data in VBA </div> <div class="table-of-contents__item-duration"> 2m 53s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/solution-manage-workbook-elements-and-data-in-vba?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Solution: Manage workbook elements and data in VBA </div> <div class="table-of-contents__item-duration"> 3m 8s </div> </div> </a> </li> </ul> <!----> </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 6. Adding Advanced Elements to Your VBA Code <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 6. Adding Advanced Elements to Your VBA Code <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/turn-off-screen-updating-when-you-run-a-macro?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Turn off screen updating when you run a macro </div> <div class="table-of-contents__item-duration"> 4m 21s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/use-worksheet-functions-in-a-macro?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Use worksheet functions in a macro </div> <div class="table-of-contents__item-duration"> 3m 12s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/acquire-values-using-an-input-box-or-message-box?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Acquire values using an input box or message box </div> <div class="table-of-contents__item-duration"> 6m 55s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/call-a-subroutine-from-another-subroutine?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Call a subroutine from another subroutine </div> <div class="table-of-contents__item-duration"> 3m 46s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/challenge-add-advanced-elements-to-your-workbook?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Challenge: Add advanced elements to your workbook </div> <div class="table-of-contents__item-duration"> 3m 35s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/solution-add-advanced-elements-to-your-workbook?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Solution: Add advanced elements to your workbook </div> <div class="table-of-contents__item-duration"> 4m 1s </div> </div> </a> </li> </ul> <!----> </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 7. Using Excel Events in Your VBA Code <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 7. Using Excel Events in Your VBA Code <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/run-a-procedure-when-you-open-close-or-save-a-workbook?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Run a procedure when you open, close, or save a workbook </div> <div class="table-of-contents__item-duration"> 5m 35s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/run-a-procedure-when-a-cell-range-changes?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Run a procedure when a cell range changes </div> <div class="table-of-contents__item-duration"> 5m 37s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/trigger-a-procedure-using-a-specific-key-sequence?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Trigger a procedure using a specific key sequence </div> <div class="table-of-contents__item-duration"> 3m 48s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/challenge-use-excel-events-in-your-vba-code?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Challenge: Use Excel events in your VBA code </div> <div class="table-of-contents__item-duration"> 3m 9s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/solution-use-excel-events-in-your-vba-code?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Solution: Use Excel events in your VBA code </div> <div class="table-of-contents__item-duration"> 3m 30s </div> </div> </a> </li> </ul> <!----> </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> Conclusion <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> Conclusion <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://www.linkedin.com/learning/excel-learning-vba/further-resources?autoplay=true&amp;trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Locked)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Further resources </div> <div class="table-of-contents__item-duration"> 1m 14s </div> </div> </a> </li> </ul> <!----> </div> </li> </ul> </section> <section class="aside-section-container mb-4 subscription-value-props-aside-section"> <h2 class="aside-section-container__title section-title"> What’s included </h2> <!----> <div class="aside-section-container__content break-words"> <ul> <li class="subscription-value-props-aside-section__list-item"> <span class="subscription-value-props-aside-section__value-prop-label">Practice while you learn</span> <span class="subscription-value-props-aside-section__value-prop-sublabel">2 exercise files</span> </li> <li class="subscription-value-props-aside-section__list-item"> <span class="subscription-value-props-aside-section__value-prop-label">Test your knowledge</span> <span class="subscription-value-props-aside-section__value-prop-sublabel">7 quizzes</span> </li> <li class="subscription-value-props-aside-section__list-item"> <span class="subscription-value-props-aside-section__value-prop-label">Learn on the go</span> <span class="subscription-value-props-aside-section__value-prop-sublabel">Access on tablet and phone</span> </li> <li class="subscription-value-props-aside-section__list-item"> <span class="subscription-value-props-aside-section__value-prop-label">Stay up to date</span> <span class="subscription-value-props-aside-section__value-prop-sublabel">Continuing Education Units</span> </li> </ul> </div> </section> <section class="aside-section-container mb-4 similar-courses-aside-section"> <h2 class="aside-section-container__title section-title"> Similar courses </h2> <!----> <div class="aside-section-container__content break-words"> <ul> <li> <!----> <a href="https://www.linkedin.com/learning/excel-power-pivot-for-beginners-14948650?trk=learning-course_similar-courses" target="_self" data-tracking-control-name="learning-course_similar-courses" data-tracking-will-navigate class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-aside-card flex my-1.5 hover:show-play-button focus:show-play-button base-aside-card--link aside-learning-course-card"> <!----> <div class="base-aside-card__media flex-shrink-0 mr-0.5 overflow-hidden relative h-[54px] w-[95px] "> <img class="base-aside-card__media-element w-[100px] h-full object-cover" alt data-delayed-url="https://media.licdn.com/dms/image/v2/C560DAQE97jUGujsn3g/learning-public-crop_144_256/learning-public-crop_144_256/0/1656693392725?e=2147483647&amp;v=beta&amp;t=XLJumNJ18mWS90WNe9czOz75V6vfVtcjH0_ljsBJ5Kg"> <div class="aside-learning-course-card__duration duration">24m</div> <icon class="base-aside-card__play-button w-auto play-button overlay-center" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9n9raq7fmdu241tpsxwodsmcd" data-svg-class-name="base-aside-card__play-button-svg"></icon> </div> <div class="base-aside-card__info self-center pl-0.5 flex flex-col flex-1"> <h3 class="base-aside-card__title font-sans text-md font-bold text-color-text relative"> Excel: Power Pivot for Beginners <!----> </h3> <!----> <!----> <!----> <!----> <!----> </div> <!----> </a> </li> <li> <!----> <a href="https://www.linkedin.com/learning/learning-excel-what-if-analysis-2022?trk=learning-course_similar-courses" target="_self" data-tracking-control-name="learning-course_similar-courses" data-tracking-will-navigate class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-aside-card flex my-1.5 hover:show-play-button focus:show-play-button base-aside-card--link aside-learning-course-card"> <!----> <div class="base-aside-card__media flex-shrink-0 mr-0.5 overflow-hidden relative h-[54px] w-[95px] "> <img class="base-aside-card__media-element w-[100px] h-full object-cover" alt data-delayed-url="https://media.licdn.com/dms/image/v2/C560DAQElwHwac_JqEA/learning-public-crop_144_256/learning-public-crop_144_256/0/1644003709091?e=2147483647&amp;v=beta&amp;t=nYFgve4N0tBNYAZ_gDr9ndMAdUA3SSlcw3q272LMwrU"> <div class="aside-learning-course-card__duration duration">1h 22m</div> <icon class="base-aside-card__play-button w-auto play-button overlay-center" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9n9raq7fmdu241tpsxwodsmcd" data-svg-class-name="base-aside-card__play-button-svg"></icon> </div> <div class="base-aside-card__info self-center pl-0.5 flex flex-col flex-1"> <h3 class="base-aside-card__title font-sans text-md font-bold text-color-text relative"> Learning Excel What-If Analysis <!----> </h3> <!----> <!----> <!----> <!----> <!----> </div> <!----> </a> </li> <li> <!----> <a href="https://www.linkedin.com/learning/excel-advanced-formatting-techniques?trk=learning-course_similar-courses" target="_self" data-tracking-control-name="learning-course_similar-courses" data-tracking-will-navigate class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-aside-card flex my-1.5 hover:show-play-button focus:show-play-button base-aside-card--link aside-learning-course-card"> <!----> <div class="base-aside-card__media flex-shrink-0 mr-0.5 overflow-hidden relative h-[54px] w-[95px] "> <img class="base-aside-card__media-element w-[100px] h-full object-cover" alt data-delayed-url="https://media.licdn.com/dms/image/v2/C560DAQEeekevgHLNKQ/learning-public-crop_144_256/learning-public-crop_144_256/0/1648232416811?e=2147483647&amp;v=beta&amp;t=flgcU8NTBaZLG7HY3yxHSZ5NAbzuT0rFOzZgpyagY8A"> <div class="aside-learning-course-card__duration duration">2h 42m</div> <icon class="base-aside-card__play-button w-auto play-button overlay-center" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9n9raq7fmdu241tpsxwodsmcd" data-svg-class-name="base-aside-card__play-button-svg"></icon> </div> <div class="base-aside-card__info self-center pl-0.5 flex flex-col flex-1"> <h3 class="base-aside-card__title font-sans text-md font-bold text-color-text relative"> Excel: Advanced Formatting Techniques <!----> </h3> <!----> <!----> <!----> <!----> <!----> </div> <!----> </a> </li> </ul> </div> </section> <section class="aside-section-container mb-4"> <h2 class="aside-section-container__title section-title"> Download courses </h2> <!----> <div class="aside-section-container__content break-words"> <p>Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.</p> <div class="app-links-aside-section__link-container"> <a class="app-links-aside-section__link" href="https://itunes.apple.com/app/apple-store/id1084807225?ls=1&amp;pt=10746&amp;mt=8&amp;ct=learning_course_app_links&amp;trk=learning-course_apple-app-store" data-tracking-control-name="learning-course_apple-app-store" data-tracking-will-navigate rel="noopener noreferrer" target="_blank"> <img alt="Download on the App Store" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/emczv26hz24woii2j4aleyry" height="42px" width="142px"> </a> <a class="app-links-aside-section__link" href="https://play.google.com/store/apps/details?id=com.linkedin.android.learning&amp;referrer=utm_source%3Dlinkedinlearning%26utm_medium%3DmobileWeb%26utm_campaign%3Dlearning_guest&amp;ct=learning_course_app_links&amp;trk=learning-course_google-play-store" data-tracking-control-name="learning-course_google-play-store" data-tracking-will-navigate rel="noopener noreferrer" target="_blank"> <img alt="Get it on Google Play" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/535kqf5rsexfx0lucb3t6palb" height="42px" width="142px"> </a> </div> </div> </section> </section> </main> <div class="pre-footer "> <section class="core-section-container my-3 price-disclaimer"> <!----> <!----> <!----> <div class="core-section-container__content break-words"> <p class="price-disclaimer__copy"> <sup class="price-disclaimer__copy--sup">*</sup>Price may change based on profile and billing country information entered during Sign In or Registration </p> </div> </section> <section class="tw-linkster bg-cool-gray-20 browse-map" data-impression-id="learning-course_linkster" data-js-module-id="linkster"> <div class="max-w-screen-content-max-w w-full flex justify-between my-0 mx-auto mamabear:px-3 babybear:px-2 babybear:flex-col"> <div class="flex-1 w-1/2 pt-2 pr-4 pb-4 pl-0 babybear:pb-2 babybear:w-full babybear:border-b-1 babybear:border-solid babybear:border-color-border-low-emphasis babybear:last:border-b-0"> <h3 class="text-md font-bold text-color-text leading-open"> Explore Business Topics </h3> <ul class="my-1"> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/business-analysis-and-strategy?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Business Analysis and Strategy </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/business-software-and-tools?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Business Software and Tools </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/career-development-5?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Career Development </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/customer-service-3?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Customer Service </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/diversity-equity-and-inclusion-dei?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Diversity, Equity, and Inclusion (DEI) </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/finance-and-accounting?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Finance and Accounting </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/human-resources-3?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Human Resources </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/leadership-and-management?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Leadership and Management </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/marketing-2?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Marketing </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/professional-development?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Professional Development </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/project-management?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Project Management </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/sales-3?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Sales </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/small-business-and-entrepreneurship?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Small Business and Entrepreneurship </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/training-and-education?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Training and Education </a> </li> </ul> <a class="link tw-linkster-general-link" aria-label="See all business courses" href="https://www.linkedin.com/learning/topics/business?trk=learning-course_browsemap_general-link" data-tracking-control-name="learning-course_browsemap_general-link" data-tracking-will-navigate> See all </a> </div> <div class="flex-1 w-1/2 pt-2 pr-4 pb-4 pl-0 babybear:pb-2 babybear:w-full babybear:border-b-1 babybear:border-solid babybear:border-color-border-low-emphasis babybear:last:border-b-0"> <h3 class="text-md font-bold text-color-text leading-open"> Explore Creative Topics </h3> <ul class="my-1"> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/aec?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> AEC </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/animation-and-illustration?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Animation and Illustration </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/audio-and-music?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Audio and Music </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/graphic-design?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Graphic Design </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/motion-graphics-and-vfx?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Motion Graphics and VFX </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/photography-2?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Photography </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/product-and-manufacturing?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Product and Manufacturing </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/user-experience?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> User Experience </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/2015-54?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Video </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/visualization-and-real-time?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Visualization and Real-Time </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/web-design?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Web Design </a> </li> </ul> <a class="link tw-linkster-general-link" aria-label="See all creative courses" href="https://www.linkedin.com/learning/topics/creative?trk=learning-course_browsemap_general-link" data-tracking-control-name="learning-course_browsemap_general-link" data-tracking-will-navigate> See all </a> </div> <div class="flex-1 w-1/2 pt-2 pr-4 pb-4 pl-0 babybear:pb-2 babybear:w-full babybear:border-b-1 babybear:border-solid babybear:border-color-border-low-emphasis babybear:last:border-b-0"> <h3 class="text-md font-bold text-color-text leading-open"> Explore Technology Topics </h3> <ul class="my-1"> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/artificial-intelligence?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Artificial Intelligence (AI) </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/cloud-computing-5?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Cloud Computing </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/security-3?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Cybersecurity </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/data-science?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Data Science </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/database-management?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Database Management </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/devops?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> DevOps </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/hardware?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Hardware </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/it-help-desk-5?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> IT Help Desk </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/mobile-development?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Mobile Development </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/network-and-system-administration?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Network and System Administration </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/software-development?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Software Development </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://www.linkedin.com/learning/topics/web-development?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Web Development </a> </li> </ul> <a class="link tw-linkster-general-link" aria-label="See all technology courses" href="https://www.linkedin.com/learning/topics/technology?trk=learning-course_browsemap_general-link" data-tracking-control-name="learning-course_browsemap_general-link" data-tracking-will-navigate> See all </a> </div> </div> </section> </div> <footer class="li-footer bg-transparent w-full "> <ul class="li-footer__list flex flex-wrap flex-row items-start justify-start w-full h-auto min-h-[50px] my-[0px] mx-auto py-3 px-2 papabear:w-[1128px] papabear:p-0"> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <span class="sr-only">LinkedIn</span> <icon class="li-footer__copy-logo text-color-logo-brand-alt inline-block self-center h-[14px] w-[56px] mr-1" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e12h2cd8ac580qen9qdd0qks8"></icon> <span class="li-footer__copy-text flex items-center">&copy; 2024</span> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://about.linkedin.com?trk=d_learning_course_guest_footer-about" data-tracking-control-name="d_learning_course_guest_footer-about" data-tracking-will-navigate> About </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/accessibility?trk=d_learning_course_guest_footer-accessibility" data-tracking-control-name="d_learning_course_guest_footer-accessibility" data-tracking-will-navigate> Accessibility </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/user-agreement?trk=d_learning_course_guest_footer-user-agreement" data-tracking-control-name="d_learning_course_guest_footer-user-agreement" data-tracking-will-navigate> User Agreement </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/privacy-policy?trk=d_learning_course_guest_footer-privacy-policy" data-tracking-control-name="d_learning_course_guest_footer-privacy-policy" data-tracking-will-navigate> Privacy Policy </a> </li> <!----> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/cookie-policy?trk=d_learning_course_guest_footer-cookie-policy" data-tracking-control-name="d_learning_course_guest_footer-cookie-policy" data-tracking-will-navigate> Cookie Policy </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/copyright-policy?trk=d_learning_course_guest_footer-copyright-policy" data-tracking-control-name="d_learning_course_guest_footer-copyright-policy" data-tracking-will-navigate> Copyright Policy </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://brand.linkedin.com/policies?trk=d_learning_course_guest_footer-brand-policy" data-tracking-control-name="d_learning_course_guest_footer-brand-policy" data-tracking-will-navigate> Brand Policy </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/psettings/guest-controls?trk=d_learning_course_guest_footer-guest-controls" data-tracking-control-name="d_learning_course_guest_footer-guest-controls" data-tracking-will-navigate> Guest Controls </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/professional-community-policies?trk=d_learning_course_guest_footer-community-guide" data-tracking-control-name="d_learning_course_guest_footer-community-guide" data-tracking-will-navigate> Community Guidelines </a> </li> <!----> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <div class="collapsible-dropdown collapsible-dropdown--footer collapsible-dropdown--up flex items-center relative hyphens-auto language-selector z-2"> <!----> <ul class="collapsible-dropdown__list hidden container-raised absolute w-auto overflow-y-auto flex-col items-stretch z-1 bottom-[100%] top-auto" role="menu" tabindex="-1"> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="العربية (Arabic)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ar_AE" data-locale="ar_AE" role="menuitem" lang="ar_AE"> العربية (Arabic) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="বাংলা (Bangla)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-bn_IN" data-locale="bn_IN" role="menuitem" lang="bn_IN"> বাংলা (Bangla) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Čeština (Czech)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-cs_CZ" data-locale="cs_CZ" role="menuitem" lang="cs_CZ"> Čeština (Czech) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Dansk (Danish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-da_DK" data-locale="da_DK" role="menuitem" lang="da_DK"> Dansk (Danish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Deutsch (German)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-de_DE" data-locale="de_DE" role="menuitem" lang="de_DE"> Deutsch (German) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Ελληνικά (Greek)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-el_GR" data-locale="el_GR" role="menuitem" lang="el_GR"> Ελληνικά (Greek) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="English (English) selected" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link--selected" data-tracking-control-name="language-selector-en_US" data-locale="en_US" role="menuitem" lang="en_US"> <strong>English (English)</strong> </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Español (Spanish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-es_ES" data-locale="es_ES" role="menuitem" lang="es_ES"> Español (Spanish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="فارسی (Persian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-fa_IR" data-locale="fa_IR" role="menuitem" lang="fa_IR"> فارسی (Persian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Suomi (Finnish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-fi_FI" data-locale="fi_FI" role="menuitem" lang="fi_FI"> Suomi (Finnish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Français (French)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-fr_FR" data-locale="fr_FR" role="menuitem" lang="fr_FR"> Français (French) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="हिंदी (Hindi)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-hi_IN" data-locale="hi_IN" role="menuitem" lang="hi_IN"> हिंदी (Hindi) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Magyar (Hungarian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-hu_HU" data-locale="hu_HU" role="menuitem" lang="hu_HU"> Magyar (Hungarian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Bahasa Indonesia (Indonesian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-in_ID" data-locale="in_ID" role="menuitem" lang="in_ID"> Bahasa Indonesia (Indonesian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Italiano (Italian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-it_IT" data-locale="it_IT" role="menuitem" lang="it_IT"> Italiano (Italian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="עברית (Hebrew)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-iw_IL" data-locale="iw_IL" role="menuitem" lang="iw_IL"> עברית (Hebrew) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="日本語 (Japanese)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ja_JP" data-locale="ja_JP" role="menuitem" lang="ja_JP"> 日本語 (Japanese) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="한국어 (Korean)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ko_KR" data-locale="ko_KR" role="menuitem" lang="ko_KR"> 한국어 (Korean) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="मराठी (Marathi)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-mr_IN" data-locale="mr_IN" role="menuitem" lang="mr_IN"> मराठी (Marathi) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Bahasa Malaysia (Malay)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ms_MY" data-locale="ms_MY" role="menuitem" lang="ms_MY"> Bahasa Malaysia (Malay) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Nederlands (Dutch)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-nl_NL" data-locale="nl_NL" role="menuitem" lang="nl_NL"> Nederlands (Dutch) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Norsk (Norwegian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-no_NO" data-locale="no_NO" role="menuitem" lang="no_NO"> Norsk (Norwegian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="ਪੰਜਾਬੀ (Punjabi)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-pa_IN" data-locale="pa_IN" role="menuitem" lang="pa_IN"> ਪੰਜਾਬੀ (Punjabi) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Polski (Polish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-pl_PL" data-locale="pl_PL" role="menuitem" lang="pl_PL"> Polski (Polish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Português (Portuguese)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-pt_BR" data-locale="pt_BR" role="menuitem" lang="pt_BR"> Português (Portuguese) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Română (Romanian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ro_RO" data-locale="ro_RO" role="menuitem" lang="ro_RO"> Română (Romanian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Русский (Russian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ru_RU" data-locale="ru_RU" role="menuitem" lang="ru_RU"> Русский (Russian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Svenska (Swedish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-sv_SE" data-locale="sv_SE" role="menuitem" lang="sv_SE"> Svenska (Swedish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="తెలుగు (Telugu)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-te_IN" data-locale="te_IN" role="menuitem" lang="te_IN"> తెలుగు (Telugu) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="ภาษาไทย (Thai)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-th_TH" data-locale="th_TH" role="menuitem" lang="th_TH"> ภาษาไทย (Thai) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Tagalog (Tagalog)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-tl_PH" data-locale="tl_PH" role="menuitem" lang="tl_PH"> Tagalog (Tagalog) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Türkçe (Turkish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-tr_TR" data-locale="tr_TR" role="menuitem" lang="tr_TR"> Türkçe (Turkish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Українська (Ukrainian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-uk_UA" data-locale="uk_UA" role="menuitem" lang="uk_UA"> Українська (Ukrainian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Tiếng Việt (Vietnamese)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-vi_VN" data-locale="vi_VN" role="menuitem" lang="vi_VN"> Tiếng Việt (Vietnamese) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="简体中文 (Chinese (Simplified))" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-zh_CN" data-locale="zh_CN" role="menuitem" lang="zh_CN"> 简体中文 (Chinese (Simplified)) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="正體中文 (Chinese (Traditional))" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-zh_TW" data-locale="zh_TW" role="menuitem" lang="zh_TW"> 正體中文 (Chinese (Traditional)) </button> </li> <!----> </ul> <button class="language-selector__button select-none relative pr-2 font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover hover:cursor-pointer focus:text-color-link-focus focus:outline-dotted focus:outline-1" aria-expanded="false" data-tracking-control-name="footer-lang-dropdown_trigger"> <span class="language-selector__label-text mr-0.5 break-words"> Language </span> <icon class="language-selector__label-chevron w-2 h-2 absolute top-0 right-0" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> </div> </li> </ul> <!----> </footer> <script src="https://static.licdn.com/aero-v1/sc/h/eh08muqvrde4h3hc6koyij5ti" async></script> <!----> <script src="https://static.licdn.com/aero-v1/sc/h/awgwgu3fg49q0tcvd24ku87qq" async defer></script> <script data-delayed-url="https://static.licdn.com/aero-v1/sc/h/81wy0f4hfrhoilx9eqdwg202z" data-module-id="media-player"></script> <code id="trackingData" style="display: none"><!--{"hashedCourseId":"aCoFmtvvpux480rxyoe5vEEo7GPLxpMat9oz2gxb/aI=","urn":"urn:li:lyndaCourse:4469215","totalPrice":{"currencyCode":"HKD","amount":"299.99"}}--></code> <code id="alcOnlyData" style="display: none"><!--{"isAlcOnly":false,"canPurchaseCourse":true}--></code> </body> </html>

Pages: 1 2 3 4 5 6 7 8 9 10