Advanced Excel Mastery: Workshop Content
01. Goal Seek - Teach participants to find the needed input to achieve a desired goal
02. Solver: Understanding and using the solver function to perform what-if analysis
03. Developer Tabs - Active X Controls: Introduction to Developer tab functionality, and how to create and manage ActiveX controls
04. SpellNumber: Converting numbers into words
05. Save Data to New Row: Automate data saving in new rows
06. Loop Calculation: Implementing loop calculations in Excel
07. File Backup: Creating automated backup systems
08. Select Cells and Commanding: Understanding cell selection and commanding via VBA
09. Send Emails: Automate sending emails through Excel
10. Save as PDF Multiple Files: Bulk conversion of Excel files to PDF
11. Save as XLSX: How to save files in .XLSX format from .XLS format
12. Combine Multiple Excel Files: Combining various Excel files into one
13. Commanding with Icons: Enhancing visual functionality
14. Password Protect Files using VBA: Implementing password protection
Comments