Program Category: End User IT

This comprehensive one-day training equips executives and managers with the knowledge and skills to effectively harness the power of AI tools like ChatGPT in their job roles.

Artificial Intelligence (AI) has revolutionized the way we work, offering powerful tools that can enhance productivity and efficiency. Cutting-edge AI models like ChatGPT offer to assist and streamline various managerial tasks.

In this training, executives and managers will gain the knowledge and skills required to leverage AI tools like ChatGPT effectively through prompt engineering, improve their daily workflows, and maximize productivity while maintaining ethical standards and data security.

Contents

Session 1: Introduction to AI and ChatGPT

Session 2: Practical Implementation

Session 3: Advanced Use of AI Tools and Ethical Considerations

By the end of this program, participants will be prepared to boost their productivity, streamline decision-making, and automate repetitive tasks, all while adhering to ethical standards and data security. AI is a game-changer for managerial efficiency, and this training will help managers unlock its full potential.

This course is designed for executives who possess intermediate or advanced level Excel skills. Business executives need access to accurate data – presented in a clear and understandable way. This training program will teach the participants skills needed to use this data to build powerful reports on any aspect of their business using Excel.

Carefully built dashboard report help you clearly see insights into any aspect of the business. The training program will cover advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep information informative and relevant, analyzing and automating information for a fully functional and complete dashboard.

Contents

Chart and Dashboard Introduction

Dashboard Tools and Techniques

Interactive Dashboards, Functions and Conditional Formatting

Reporting Using Pivot Table

Working with Databases and Using Pivot Charts

Advance Dashboard Tools and Techniques

Dynamic Graphs Using Macros and VBA

Using VBA Advance Examples

Adobe Photoshop is the standard for creating and editing images including all aspects of design process from the importing of images right through to final production considerations for finished art work. Working with these Adobe applications you will learn how to create all types of different media such as magazines, business cards, letterheads, marketing materials (fliers, menus) – anything you can imagine you can design using these Adobe tools.

Contents

• Photoshop Toolbox
• Acquiring Images
• Importing & exporting images
• Creating a text frame
• Defining a text path
• Type styles and fonts
• Creating paths and drawings
• Open vs. closed paths
• Combining and grouping
• Tracking user actions
• Exporting for print and online distribution
• PDF configuration and settings

This course aims to give participants an opportunity to have hands-on experience of financial modeling by blending accounting, corporate finance and excel skills. Financial models are one of the most widely used techniques to calculate, forecast or estimate various financial situations and scenarios. Building a robust financial model helps professionals in gaining deeper understanding of various financial outcomes of their business and hence making better and informed decisions.

Contents

• Introduction to advanced features of Excel
• Profit and loss forecast and projections
• Cash flow forecast and projections
• Balance Sheet construction and forecast
• Break-even analysis
• Data validation and protection of your model
• Capital budgeting formulas and functions
• Banking models and loan calculators
• What-if-analysis
• Performing macros to automate a financial model

This intensive course is designed for those who are beginners or who need a refresher in the overall suite of applications within MS Office. This entirely hands on course includes specially prepared exercises that give participants practical exposure to Word, Excel, PowerPoint and Outlook

Contents

Microsoft Word
Editing, Formatting, Tables & Graphs, Mail Merge, OLE

Microsoft PowerPoint
Auto Content Presentations, Formatting Presentations, Graphs and Tables, Slide Transitions, Animations, OLE

Microsoft Excel
Editing & Formatting Worksheets, Formulas & Functions, Charts & Graphs, Protecting Workbooks, Consolidation, Goal Seeking, OLE

Microsoft Outlook
Advanced Email Features, Organizing Information, Creating Appointments, Working with Calendar, Using Contact List, Working with Tasks

Microsoft Excel is the MS Office spreadsheet and analysis program. It gives professionals the tools they need to manage critical business data, and everyday users the power to get the most out of their information. It provides an impressive array of tools for planners, engineers, accountants and operations staff to handle and analyze data

This Excel Advanced course aims to show the participants how to create more sophisticated worksheets, incorporating advanced formatting options, charts and graphics.

Contents

-Working with complex Formulas & Functions
-Data Manipulation & Pivot Tables
-Outlining & Consolidation Features
-Data Sorting & Filtering
-Linking Spreadsheets
-Publishing Worksheets as HTML & Email Collaboration