Advanced Excel with ChatGPT: A Practical Programme for Professionals and Business Managers

Description

This is a 2-day workshop to be conducted on 14th - 15th Oct 2024.

Excel spreadsheets are indispensable tools in the modern professional and managerial landscape. Recognizing this, our dynamic workshop is tailored for those already have some prior experience in Excel and wish to elevate their expertise with advanced spreadsheet design, robust security measures, and sophisticated data modelling.

What sets this workshop apart is the integration of ChatGPT (an AI-driven assistant) to enhance the learning experience. This feature allows for real-time interaction, offering instant support and customized solutions relevant to your industry and role. Whether you're a professional seeking to streamline data collation and organization, or a manager needing to analyze and report data efficiently, this workshop offers invaluable insights. It's also ideal for those who require advanced skills in constructing spreadsheets for stress-testing and simulating data outputs.

Programme Outline

Excel Productivity Techniques and Best Practices

• Excel Spreadsheet Setup and Development Environment
• Spreadsheet Development Techniques with ChatGPT Assistance
• Excel Fundamentals and Formula Building
• Keyboard Shortcuts (to make you 8 times faster)
• Formula Debugging and Auditing using ChatGPT
• Inputs vs. Formulae: ChatGPT-Enhanced Understanding

Building Flexible Formulas in Excel

• Relative vs. Absolute Referencing
• Using Names to Increase Formula Efficiency
• Formula Layout Simplification with ChatGPT Tips
• Logical Statements: IF, AND, OR functions
• Advanced Logicals with Flags: ChatGPT Explained Examples
• Conditional Formatting with ChatGPT Insights

Data Retrieval and Report Presentations in Excel

• HLOOKUP, VLOOKUP, CHOOSE
• INDEX, INDEX/MATCH
• OFFSET: Understanding with ChatGPT
• ChatGPT Assisted Data Retrieval Strategies
• Report Presentation Tips from ChatGPT

Working with Text and Dates in Excel

• Text Strings (Dynamic Text)
• TEXT Functions: Exploring with ChatGPT
• Date Functions: Simplified by ChatGPT

Building Flexible Charts in Excel

• Form Controls for Flexible Reporting and Charts
• Chart Shortcuts, Setups and Formatting

Analysing the Output

• Macros and Automation in Excel with ChatGPT Tutorials
• Adhoc Reporting and Data Analysis with Pivot Tables: ChatGPT Enhanced Techniques

This is a 2-day intensive programme where participants will get to apply their knowledge with hands-on exercises, guided by the Trainer. Participants are required to bring along their laptops, equipped with Excel 2010 and above with full installation. Participants should have basic knowledge of Excel.

Participants' laptops should ideally be internet-enabled as some exercises will require online access. Participants without internet access will still be provided with connected files to benefit from the session.

This workshop qualifies for 14.0 CPE hours in Information Technology (Category 5).

What you will learn

By the end of the workshop, you will :

• Learn how to develop a “toolkit” of Excel tips and techniques
• Learn how to debug formulas and stress test Excel outputs from models
• Learn how to understand and solve problems within an Excel spreadsheet environment
• Use with confidence Excel’s keyboard shortcuts to improve their speed and efficiency
• Develop with confidence Excel formulae in order to build robust solutions
• Learn to quickly and consistently format presentation-quality reports

Laptop Requirements

Participants are required to bring along their laptops, equipped with Excel 2010 and above with full installation. Participants should have basic knowledge of Excel.

Participants' laptops should ideally be internet-enabled as some exercises will require online access. Participants without internet access will still be provided with connected files to benefit from the session.

Target Audience

Professionals and Business Managers

Expert Speaker

Dr Lim Thou Tin

Dr. Lim is a business graduate from the NUS. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a Doctor of Business Administration with research interests in information systems and business modelling. He is also a certified business intelligence professional with specialisation in business analytics.

Dr Lim’s work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives / projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia and Thailand.

Dr Lim continues to be involved in senior management education at local tertiary institutions, teaching information and accounting topics at degree and postgraduate level with research and publishing interests in knowledge management and business intelligence.