Excel Automation 

Introduction

Reporting is an essential aspect of many professions and industries, providing valuable insights, analysis, and updates on various aspects of a business or project. However, the process of generating reports can often be a time-consuming and labour-intensive task. It requires collecting, organizing, and analysing data, creating visually appealing presentations, and ensuring accuracy throughout the entire process. 

The workshop focuses on Automation techniques in Microsoft Excel, such as macros, and other advanced functionalities, can revolutionize the way we approach reporting.  

These tools enable us to automate data collection, analysis, formatting, and even the generation of visually appealing reports, saving us valuable time and effort. 

No technical knowledge required. 

Recording and Running Macros 

• Recording and playing back macros 
• Assigning macros to buttons and shortcuts 

Working with Ranges and Cells 

Using Functions and Formulas for Automation 

Working with Worksheets and Workbooks 

• Creating, copying, and deleting worksheets 
• Linking data between worksheets and workbooks 

Handling Errors and Debugging 

• Error handling technique 
• Debugging and troubleshooting code 

Automating Data Manipulation 

• Importing and exporting data from external sources 
• Sorting and filtering data 
• Data validation and conditional formatting 

Advanced Automation Techniques 

Working with advanced Excel objects (charts, pivot tables)