Automating tasks in Excel 365 (2024)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Unlock the full potential of Excel 365 by automating repetitive tasks and transforming yourself into an efficiency expert. Discover how to automate basic tasks by creating macros and using the new Office Scripts. First, learn how to confidently activate macros within Excel 365. Then, discover how to record a macro to automate repetitive tasks, saving time and minimizing errors. Once you have created a macro, it’s important to know how to save a workbook with macros, maintaining the integrity of your automated processes. This course also covers how to run macros smoothly, and view and modify them to ensure that you can tailor your automated tasks to your specific needs. As you become more proficient, discover the Visual Basic for Applications (VBA) Editor with ease, learning advanced techniques for editing macros to streamline complex tasks. Applying macros across different workbooks will no longer be a challenge as you master the methods to extend automation beyond a single file. Lastly, get an introduction to Office Scripts, a powerful feature of Excel 365. Learn to record, manage, and deploy Office Scripts, enabling cross-platform automation within Excel and OneDrive. This course aligns with the objectives of MO-211: Microsoft Excel Expert (Microsoft 365 Apps). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.