Excel Training by "Sister Anne" | May 19, 2020 | Training VBA TopicSpreadsheet Topic Introduction VBA in Excel Excel shortcut keys Writing VBA Macro What XLOOKUP Can Do When things go wrong Top 25 Excel 2016 Tips and Tricks Buttons & Toolbars 10 Best Excel Tips for Beginners Selecting Cells Top 15 Advanced Excel 2016 Tips and Tricks Worksheets and Charts Power BI Tutorial For Beginners Workbooks Power Pivot Table Variables ObjectVariables Message Boxes Input Boxes App Input Box With Statements If Statements Select statement Do Until Find and FindNext ForNext Loops ForEachLoops Functions Error Handling Event Procedures User Forms Files and Folders Text Files File Dialogues Arrays Constants, Enumerations Creating Word Documents Creating PowerPoint Creating Outlook emails Querying a database Modyfying data with recordsets SQL Statements Creating AddIns Type Declarations Class modules Sharing Class modules Custom Collections Typed Collections Dictionaries
