Excelit Training Catalogue

Updated on 21/11/2026

| Table of Content | Download Catalogue

| Table of Content | Table of Contents 1. Microsoft Office & Productivity Tools .......................................................................................... 4 1.1 Microsoft Excel ................................................................................................................................. 4 ➔ Microsoft Excel Advanced with Artificial Intelligence – Rs 25,000 ( NEW) ........................................ 5 ➔ Getting Started with Microsoft Excel – Rs 10,000............................................................................. 11 ➔ Advanced Features of Microsoft Excel – Rs 12,000 ( BEST SELLER)............................................... 15 ➔ Digital Skills & Artificial Intelligence for Young Professional – Rs 30,000............................................ 18 2. Artificial Intelligence & Digital Transformation ......................................................................... 25 ➔ Applied Generative AI for Office Productivity – Rs 22,500 ................................................................. 26 ➔ Business Process Optimisation with AI – Rs 30,000......................................................................... 29 3. Leadership, Management & Professional Skills ......................................................................... 35 ➔ Communicating with Clarity, Confidence, and Emotional Intelligence – Rs 9,000 .............................. 36 Catalogue is presently UNDER CONSTRUCTION

| Table of Content | 1. Microsoft Office & Productivity Tools 1.1 Microsoft Excel Microsoft Excel Advanced with Artificial Intelligence

| Table of Content | ➔ Microsoft Excel Advanced with Artificial Intelligence – Rs 25,000 (🆕 NEW) Duration: 18 hrs Trainers: 1. Ziyad Peerbaye 2. Rachel Luquet Target Audience Professionals who already have an intermediate knowledge of Microsoft Excel and wish to develop advanced spreadsheet, data analysis and automation skills using traditional Excel features and AI- assisted techniques. Course Overview This course develops participants' ability to use advanced Excel functions, analyse business data, automate repetitive tasks and produce meaningful reports. It combines established Excel techniques with practical applications of Microsoft Copilot and AI-assisted problem-solving. Participants will learn to perform tasks using traditional Excel features and explore how AI can assist in formula creation, data-quality analysis, reporting, financial modelling, conditional formatting and VBA development. The course emphasises accuracy, critical evaluation of AI-generated outputs and the responsible use of AI in a professional environment. Course Objectives: By the end of the course, participants should be able to: • Apply advanced logical, mathematical, statistical and financial functions to business problems. • Create lookup formulas and perform what-if analysis. • Validate, organise and analyse structured datasets. • Build PivotTables, PivotCharts and business summaries. • Import, export and prepare data for analysis. • Use analytical tools to evaluate alternative business scenarios. • Record, understand and modify macros, and use AI assistance to draft and troubleshoot VBA code. • Apply conditional formatting to communicate information effectively. • Use Copilot or an approved AI assistant to generate formulas, interpret data, identify potential errors and support reporting tasks. • Verify AI-generated formulas, analysis and code before using them in business workbooks. Module 1: Advanced Functions and AI-Assisted Formula Creation Duration: 2.5 hours Traditional Excel skills • Logical functions: IF, AND, OR, NOT and IFERROR. • Nested functions and conditional calculations. • Mathematical and statistical functions: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF and AVERAGEIFS. • Financial functions, including PMT for loan repayment calculations. • Understanding, displaying and troubleshooting formulas. AI and Copilot applications • Using natural-language prompts to generate complex Excel formulas. • Asking AI to explain formulas in plain language. • Converting business rules into logical tests and calculations. • Using AI to identify potential formula errors and suggest corrections. • Testing formulas against boundary conditions and sample data.

| Table of Content | Practical exercise: Create a sales commission calculator using several commission thresholds. Develop the formula manually, ask Copilot to propose an alternative and compare the results against test cases. Module 2: Lookup Functions, Data Tables and AI-Assisted Formula Design Duration: 2 hours Traditional Excel skills • Using VLOOKUP, HLOOKUP and XLOOKUP. • Using INDEX and MATCH to retrieve information from tables. • Combining lookup functions to solve business problems. • Creating one-variable and two-variable data tables. • Applying lookup techniques to employee, product, customer or sales records. AI and Copilot applications • Translating a business requirement into a lookup formula. • Asking AI to explain lookup logic and handle missing matches. • Identifying potential problems caused by duplicate keys or inconsistent identifiers. • Using AI to recommend an appropriate formula structure based on the workbook's data layout. Practical exercise: Retrieve employee salary grades from a reference table, handle missing employee IDs and compare a manually constructed lookup formula with an AI-suggested solution. Module 3: Advanced List Management and Data Quality Duration: 1.5 hours Traditional Excel skills • Data validation rules and controlled data entry. • Creating dropdown lists and custom validation messages. • Database functions, including DSUM, DAVERAGE and DCOUNT. • Applying criteria to structured lists. • Identifying invalid or inconsistent entries. AI and Copilot applications • Asking AI to identify potential data-quality issues. • Detecting inconsistent labels, missing values and possible duplicate records. • Developing a structured data-cleaning checklist. • Translating business requirements into data-validation rules. • Distinguishing confirmed errors from records that require human review. Practical exercise: Review a customer or employee dataset containing inconsistent labels, missing information and potential duplicates. Produce a data-quality report and implement appropriate Excel corrections. Module 4: PivotTables, PivotCharts and AI-Assisted Data Analysis Duration: 2.5 hours Traditional Excel skills • Creating and configuring PivotTables. • Rearranging fields and changing data summaries. • Filtering, grouping and refreshing PivotTable data. • Applying PivotTable styles and number formats. • Creating and modifying PivotCharts. • Using PivotTables to compare business performance. AI and Copilot applications • Using natural language to explore questions about business data.

| Table of Content | • Asking AI to recommend appropriate summaries, PivotTable layouts and charts. • Identifying trends, unusual results and performance differences. • Generating concise explanations of findings. • Checking AI-generated conclusions against actual figures and source data. Practical exercise: Analyse sales by region, product and quarter. Create a PivotTable and PivotChart, then use Copilot to identify the strongest and weakest areas and explain the findings using supporting figures. Module 5: Importing, Exporting and Preparing Data Duration: 1.5 hours Traditional Excel skills • Importing and exporting text-based data. • Understanding file-format limitations. • Working with XML data and structured data sources where applicable. • Retrieving information from external databases. • Checking imported data for consistency and suitability for analysis. AI and Copilot applications • Asking AI to explain common import and formatting problems. • Developing data-preparation and reconciliation checklists. • Identifying potential date, number-format and text inconsistencies. • Documenting data-cleaning steps and preparing data for analysis. • Exploring Power Query as a repeatable data-preparation method, where available. Practical exercise: Prepare a sample transaction file for analysis, identify common import issues and develop a repeatable procedure for cleaning the data before reporting. Module 6: Analytical Tools, What-If Analysis and AI-Assisted Decision Support Duration: 2 hours Traditional Excel skills • What-if analysis and Goal Seek. • Introduction to Solver and its use in constrained optimisation. • Using the Analysis ToolPak where available. • Creating and comparing scenarios. • Using financial calculations to evaluate alternative business decisions. AI and Copilot applications • Translating business questions into analytical models. • Asking AI to identify variables, assumptions and constraints. • Generating alternative scenarios for comparison. • Interpreting model outputs and explaining their implications. • Using AI to suggest sensitivity checks and identify unrealistic assumptions. Practical exercise: Develop a loan or profitability model. Use Goal Seek to achieve a target result, compare alternative scenarios and use AI to explain the assumptions and limitations of the analysis. Module 7: Macros, VBA and AI-Assisted Automation Duration: 2 hours Traditional Excel skills • Understanding the purpose and limitations of macros. • Recording and running macros. • Saving macro-enabled workbooks. • Reviewing and editing VBA code.

| Table of Content | • Introduction to user-defined functions. • Testing and troubleshooting simple automation routines. AI and Copilot applications • Generating VBA code from clearly defined requirements. • Asking AI to explain existing VBA code. • Using AI to troubleshoot errors and suggest improvements. • Documenting code and identifying potential risks. • Testing AI-generated macros on copies of workbooks before deployment. Practical exercise: Develop a macro to format a report, apply consistent number formats and adjust column widths. Compare a recorded macro with an AI-assisted VBA solution and test both against a defined checklist. Module 8: Conditional Formatting, Visual Reporting and AI-Assisted Presentation Duration: 1 hour Traditional Excel skills • Applying data bars, colour scales and icon sets. • Creating conditional formatting rules. • Highlighting exceptions and performance indicators. • Using appropriate visual cues to improve spreadsheet readability. • Introduction to SmartArt for communicating structures and processes. AI and Copilot applications • Translating business rules into conditional formatting requirements. • Asking AI to recommend visual approaches for highlighting performance. • Developing concise explanations of spreadsheet findings. • Reviewing formatting choices for clarity and accessibility. Practical exercise: Create a sales performance table that highlights results below target, near target and at or above target. Use AI to propose the rules, then implement and test them in Excel. Module 9: Integrated Practical Assessment and AI Verification Duration: 3 hours Participants complete an integrated business case using the skills developed throughout the course. Assessment activities • Prepare and validate a business dataset. • Use advanced formulas and lookup functions to perform calculations. • Analyse the results using a PivotTable, PivotChart or appropriate summary. • Apply conditional formatting to highlight significant results. • Use AI to assist with formula design, data interpretation or automation. • Verify AI-generated outputs against the underlying data and business requirements. • Present the results and explain the decisions supported by the analysis. Expected output: A functional Excel workbook containing calculations, analysis and visual reporting, accompanied by a short explanation of the methodology and the checks performed on AI-assisted work. Duration Summary Module Duration 1. Advanced Functions and AI-Assisted Formula Creation 2.5 hrs 2. Lookup Functions, Data Tables and AI-Assisted Formula Design 2.0 hrs 3. Advanced List Management and Data Quality 1.5 hrs 4. PivotTables, PivotCharts and AI-Assisted Data Analysis 2.5 hrs 5. Importing, Exporting and Preparing Data 1.5 hrs

| Table of Content | 6. Analytical Tools and What-If Analysis 2.0 hrs 7. Macros, VBA and AI-Assisted Automation 2.0 hrs 8. Conditional Formatting and Visual Reporting 1.0 hr 9. Integrated Practical Assessment and AI Verification 3.0 hrs Total 18.0 hrs Practical Exercises Practical exercises will be adapted as per the participants’ needs. 1. Table of Content | 2. Download

| Table of Content | Getting Started with Microsoft Excel

| Table of Content | ➔ Getting Started with Microsoft Excel – Rs 10,000 Duration: 15 hrs Trainers: 1. Nafizah Jaufuraully 2. Ziyad Peerbaye Target Audience The target audience will be new Ms Excel users who find themselves for the first time using the application or have learn by themselves some basic features of Microsoft Excel Course Overview This course is designed to enable you to create simple spreadsheets, edit data, format the data as well as print the information. Course Objectives: By the end of the course, participants should be able to: • Identify the main components of the Microsoft Excel interface and navigate worksheets efficiently. • Enter, edit and manage text, numerical data and formulas in a worksheet. • Use AutoFill to populate data series and copy formulas. • Move, copy and organise data within worksheets and between cells. • Apply basic Excel functions such as SUM, AVERAGE, MIN, MAX, COUNT and COUNTA to perform calculations. • Format worksheets by adjusting fonts, alignment, row heights, column widths, borders, colours and number formats. • Apply Conditional Formatting and table styles to improve data presentation and readability. • Create, modify and format charts to present information graphically. • Manage large workbooks using multiple worksheets, Freeze Panes, Split and Hide/Unhide features. • Prepare worksheets for printing by configuring page orientation, margins, headers, footers, print areas and page breaks. Module 1: Getting Started Duration: 1 hour 1. Important terms 2. The use of the $ 3. Flash Fill Module 2: Entering and Editing Data Duration: 2 hours 1. Entering and editing text and values a. Entering text and values b. Editing text c. Using AutoFill to fill series 2. Entering and Editing Formulas a. Entering a formulas by typing b. Entering cell references with the mouse 3. Working with pictures a. Inserting and modifying a picture 4. Saving and updating workbooks Module 3: Modifying a Worksheet Duration: 2 hours 1. Moving and copying data a. Moving Data in a worksheet

| Table of Content | b. Copying data in a worksheet c. Moving and Copying data using drag-and-drop d. Moving and copying formulas e. Using autofill to copy a formula Module 4: Using Functions Duration: 2 hours 1. Entering functions a. Entering a SUM function b. AutoSum c. Using the AutoSum Button 2. Other useful functions a. Using AVERAGE b. Using MIN c. Using MAX d. Using COUNT and COUNTA Module 5: Formatting Worksheets Duration: 2 hours 1. Formatting Text a. Using the Font group to format text b. Using the Format ell Dialog Box to format text 2. Formatting rows and columns a. Changing column width and row height b. Applying color to row 3. Setting alignment 4. Applying borders to ranges a. Using the border-drawing pencil 5. Using the Past Special Option 6. Removing a border 7. Formatting numbers 8. Conditional formatting a. Creating a conditional format b. Editing and deleting a conditional format 9. Copying formats and applying table format a. Copying formats b. Applying call and table styles 10. Using Find and Replace to change cell format Module 6: Printing Duration: 2 hours 1. Preparing to print a. Checking spelling in a worksheet b. Finding and replacing text 2. Page Setup Options a. Setting page orientation b. Setting margins c. Creating and editing header and footers d. Hiding gridlines and headings 3. Printing worksheet a. Printing a worksheet 4. Working with print area Module 7: Creating Charts Duration: 2 hours 1. Chart basics

| Table of Content | 2. Using an embedded chart 3. Modifying charts 4. Printing charts Module 8: Managing Large Workbooks Duration: 2 hours 1. Chart basics 2. Using an embedded chart 3. Modifying charts 4. Printing charts Duration Summary Module Duration 1. Getting Started 1 hrs 2. Entering and Editing Data 2 hrs 3. Modifying a Worksheet 2 hrs 4. Using Functions 2 hrs 5. Formatting Worksheets 2 hrs 6. Printing 2 hrs 7. Creating Charts 2 hrs 8. Managing Large Workbooks 2 hrs Total 15.0 hrs

| Table of Content | Advanced Features of Microsoft Excel Advanced Features of Microsoft Excel

| Table of Content | ➔ Advanced Features of Microsoft Excel – Rs 12,000 (⭐ BEST SELLER) Duration: 15 hrs Trainers: 3. Nafizah Jaufuraully 4. Ziyad Peerbaye Target Audience Basic to intermediate Ms Excel users who have lots of reporting and analysis to do from a raw data. Course Overview This course is designed to extend your knowledge into some of the more specialized and advanced capabilities of Microsoft Excel by using more complex functions. Those functions will allow the user to build automated reports. Course Objectives: By the end of the course, participants should be able to: • Apply advanced Excel functions, including logical, mathematical, statistical and text functions, to solve complex data-processing tasks. • Use lookup functions such as VLOOKUP, HLOOKUP, XLOOKUP, INDEX and MATCH to retrieve and analyse information efficiently. • Create and manage structured Excel tables to organise data and support dynamic reporting. • Apply Data Validation and create dynamic drop-down lists to improve data accuracy and consistency. • Create, format and manage Pivot Tables and Pivot Charts to summarise and analyse large datasets. • Use Slicers and dynamic Pivot Tables to improve data filtering and reporting. • Record and run macros to automate repetitive tasks in Excel. • Assign macros to buttons and configure auto-open macros to streamline workbook operations. • Understand and perform basic modifications to VBA code modules and create custom functions Module 1: Review of the Basics Duration: 2 hours 4. Important terms 5. The use of the $ 6. Flash Fill Module 2: Advanced Functions Duration: 3 hours ● Logical Functions • IF • OR, AND and NOT • Nested IF • IFERROR ● Math and statistical Functions • SUMIF | SUMIFS • COUNTIF | COUNTIFS • AVERAGEIF | AVERAGEIFS • ROUND ● Text Functions • LEFT | RIGHT | LEN • TEXT

| Table of Content | Module 3: Lookups and Data Tables Duration: 2 hours 7. VLOOKUP | HLOOKUP | XLOOKUP 8. MATCH | INDEX Module 4: Table Structure Duration: 2 hours ● Analyze Table ● Create Dynamic Table Module 5: Advanced Data Management Duration: 2 hours ● Data Validation ● Dynamic Drop-Down Lists Module 6: Pivot Tables and Pivot Charts Duration: 2 hours ● Creating Pivot Tables ● Adding Slicers on Pivot Table ● Refreshing Dynamic Pivot Table ● Formatting Pivot Table ● Creating Pivot Charts Module 7: Introduction to Macros Duration: 2 hours ● Recording a Macro • Running a Macro • Assigning a macro to a button • Creating an auto-open macro ● Working with VBA code module • Observing a VBA code module • Basic Editing of VBA Code ● Creating Custom Functions Duration Summary Module Duration 1. Review of the Basics 2 hrs 2. Advanced Functions 3 hrs 3. Lookup and Data Tables 2 hrs 4. Table Structure 2 hrs 5. Advanced Data Management 2 hrs 6. Pivot Tables and Pivot Charts 2 hrs 7. Introduction to Macros 2 hrs Total 15.0 hrs

| Table of Content | Digital Skills & Artificial Intelligence for Young Professional

| Table of Content | ➔ Digital Skills & Artificial Intelligence for Young Professional – Rs 30,000 Duration: 30 hrs Trainers: 1. Ziyad Peerbaye 2. Rachel Luquet Target Audience Students who have completed their SC or HSC examinations, and young people who wish to develop practical digital skills before entering further education or the employment market. Course Overview The programme equips participants with practical knowledge of Microsoft Office applications, with particular emphasis on Microsoft Excel, alongside an introduction to Artificial Intelligence (AI) and Microsoft Copilot. Participants develop the ability to prepare professional documents, organise and analyse spreadsheet data, create presentations, communicate using email and calendar tools, and use AI assistants to support everyday office tasks. The course adopts a hands-on approach, using exercises based on personal finance, sales, employee information and routine business activities. It emphasises practical application, accuracy, responsible use of AI and verification of AI-generated outputs. Course Objectives: By the end of the programme, participants should be able to: • Create, format and manage professional documents using Microsoft Word. • Use Microsoft Excel to organise data, perform calculations and prepare basic reports. • Apply common Excel functions and formulas to solve practical problems. • Organise and analyse information using sorting, filtering, lookup functions and Pivot Tables. • Create basic charts and dashboards to present information. • Design and deliver professional presentations using Microsoft PowerPoint. • Use Microsoft Outlook for professional email communication and calendar management. • Understand the fundamentals of Artificial Intelligence and generative AI. • Use AI tools and Microsoft Copilot, where available, to improve productivity and assist with office tasks. • Verify AI-generated content and apply appropriate confidentiality and responsible-use practices. Module 1: Microsoft Word – Professional Documents Duration: 3.0 hours Session 1 – Creating and Formatting Documents Topics: • Introduction to Microsoft Word and its interface. • Creating, opening and saving documents. • Text formatting: fonts, sizes, colours and styles. • Paragraph formatting, alignment, bullets and numbering. • Page layout, margins, orientation and printing. Practical exercise: Prepare a professional business letter. Session 2 – Preparing Professional Documents Topics: • Creating and formatting tables, headers and footers. • Page numbering, pictures, shapes and hyperlinks. • Spelling and grammar tools.

| Table of Content | • Exporting documents to PDF. • Preparing a professional CV and cover letter. Practical exercise: Create a professional CV and an accompanying job application letter. Module 2: Microsoft Excel – Spreadsheet Skills and Data Analysis Duration: 3.0 hours This is the core technical module. Participants develop practical spreadsheet skills through exercises based on personal finance, sales, employee information and business reporting. Session 3 – Introduction to Excel and Data Management Topics: • Understanding the Excel interface, workbooks, worksheets, rows, columns and cells. • Entering, editing and formatting information. • Number, date, currency and percentage formats. • Adjusting column widths and row heights; basic keyboard shortcuts. Practical exercise: Create a personal monthly budget. Session 4 – Basic Formulas and Calculations Topics: • Understanding formulas and cell references. • Addition, subtraction, multiplication and division. • SUM, AVERAGE, MIN, MAX, COUNT and COUNTA. • Relative and absolute references; copying formulas. • Understanding common Excel errors. Practical exercise: Calculate monthly expenses and prepare a summary of expenditure. Session 5 – Logical Functions and Business Calculations Topics: • Introduction to IF and basic logical operators. • Multiple conditions and conditional calculations. • SUMIF and COUNTIF. • Percentage calculations and basic date functions. • Applying formulas to business situations. Practical exercise: Calculate employee commissions and prepare a simple performance report. Session 6 – Organising and Validating Information Topics: • Sorting and filtering data. • Creating and managing Excel Tables. • Data validation and dropdown lists. • Conditional formatting. • Identifying and correcting inconsistent data. Practical exercise: Create an employee or customer information register. Session 7 – Lookup Functions and Data Retrieval Topics: • Introduction to VLOOKUP and XLOOKUP. • Using IFERROR and basic text functions. • Retrieving information from reference tables. • Combining information from different tables. • Applying lookup functions to business records. Practical exercise: Retrieve employee or product information from a master database. Session 8 – Data Analysis and Pivot Tables Topics: • Introduction to data analysis and Pivot Tables.

| Table of Content | • Creating and modifying Pivot Tables. • Grouping, summarising, sorting and filtering results. • Refreshing Pivot Table data. • Introduction to Pivot Charts and slicers. Practical exercise: Analyse a monthly sales database using Pivot Tables. Session 9 – Charts and Business Dashboards Topics: • Understanding common chart types. • Creating column, bar, line and pie charts. • Formatting charts and presenting key performance indicators. • Creating a simple dashboard. • Using charts and tables to communicate business information. Practical exercise: Prepare a sales performance dashboard. Session 10 – Excel Productivity and Reporting Topics: • Page setup, print areas and preparing professional reports. • Protecting worksheets and workbooks. • Managing multiple worksheets and organising workbooks. • Reviewing and checking calculations. • Spreadsheet best practices. Practical exercise: Prepare a formatted monthly business report ready for printing or PDF distribution. Session 11 – Excel Practical Consolidation and Assessment Topics: • Review of formulas, functions and cell references. • Applying Excel skills to a business scenario. • Data organisation, validation and calculations. • Preparing a summary and reporting results. Practical exercise: Complete a guided business spreadsheet assignment incorporating formulas, data management and reporting. Module 3: Microsoft PowerPoint – Presenting with Confidence Duration: 3.0 hours (2 Sessions) Session 12 – Creating Professional Presentations Topics: • Introduction to PowerPoint and creating slides. • Slide layouts, themes and organising content. • Formatting text and inserting images, shapes, tables and charts. • Professional presentation principles. Practical exercise: Create a five-slide personal introduction presentation. Session 13 – Presentation Techniques Topics: • Transitions and animations. • Slide design and visual consistency. • Using speaker notes and presentation mode. • Exporting presentations to PDF. Practical exercise: Prepare and deliver a short presentation on a business idea.

| Table of Content | Module 4: Microsoft Outlook – Workplace Communication Duration: 3.0 hours (2 sessions) Session 14 – Professional Email Communication Topics: • Introduction to Outlook and the email interface. • Sending, receiving, replying to and forwarding emails. • Understanding To, CC and BCC. • Attaching documents and creating a professional email signature. • Email etiquette and professional communication. Practical exercise: Prepare a job application email with an attached CV. Session 15 – Calendar and Task Management Topics: • Managing folders and searching emails. • Creating calendar appointments and scheduling meetings. • Sending meeting invitations. • Creating reminders and managing tasks. • Organising daily activities professionally. Practical exercise: Organise a sample working week using Outlook Calendar and reminders. Module 5: Artificial Intelligence and Microsoft Copilot Duration: 4.5 hours (3 Sessions) Session 16 – Introduction to Artificial Intelligence Topics: • Understanding Artificial Intelligence and generative AI. • Overview of AI assistants and Microsoft Copilot. • Understanding prompts and writing effective instructions. • AI limitations, inaccuracies and responsible use. • Protecting personal and confidential information. Practical exercise: Use an AI assistant to research a topic, summarise information and prepare a professional email. Session 17 – Using AI for Office Productivity Topics: • Using AI to draft and improve professional documents. • Correcting grammar and improving written communication. • Generating ideas and structuring presentations. • Preparing summaries and reports. • Reviewing and validating AI-generated content. Practical exercise: Use AI to prepare a CV profile, business letter and presentation outline. Session 18 – AI with Microsoft Excel Topics: • Using AI to understand Excel formulas. • Requesting assistance with spreadsheet calculations. • Generating and explaining formulas. • Analysing data and identifying trends or unusual information. • Introduction to Microsoft Copilot capabilities in Excel, where available. Practical exercise: Use an AI assistant to analyse a sample sales dataset, generate formula suggestions and interpret the results.

| Table of Content | Module 6: Integrated Practical Project and Assessment Duration: 3.0 hours (2 sessions) Session 19 – Integrated Business Project Topics: • Prepare a business letter or quotation using Word. • Create a sales register using Excel and apply formulas. • Generate a summary report using a Pivot Table. • Prepare a short presentation using PowerPoint. • Draft a professional customer email using Outlook. • Use AI to improve selected documents and analyse information. Practical exercise: Complete an integrated simulated small-business assignment using the applications covered. Session 20 – Final Practical Assessment and Feedback Topics: • Completion and submission of the integrated practical project. • Individual review of submitted work. • Practical assessment of key learning outcomes. • Trainer feedback and recommendations. • Course review and participant feedback. Practical exercise: Submit the final practical portfolio and discuss the completed work with the trainer Duration Summary Module Duration Sessions Module 1 – Microsoft Word 3.0 hrs 2 Module 2 – Microsoft Excel 13.5 hrs 9 Module 3 – Microsoft PowerPoint 3.0 hrs 2 Module 4 – Microsoft Outlook 3.0 hrs 2 Module 5 – Artificial Intelligence and Microsoft Copilot 4.5 hrs 3 Module 6 – Integrated Practical Project and Assessment 3.0 hrs 2 TOTAL 30.0 hrs 20 Training Methodology The programme will be delivered through live, instructor-led online sessions. The methodology emphasises practical application, active participation and guided exercises based on everyday office and business activities. • Live trainer demonstrations using screen sharing. • Guided practical exercises and individual practice. • Sample business datasets and realistic workplace scenarios. • Interactive discussions, questions and answers. • Practical assignments and an integrated final project. • Use of AI tools to support learning, problem-solving and productivity. Recommended session structure: Activity Duration Introduction and recap 10 minutes Trainer demonstration 20 minutes Guided practical exercises 40 minutes Individual practice 15 minutes Questions and session review 5 minutes TOTAL 90 minutes

| Table of Content | Assessment Strategy Assessment will be continuous and practical, allowing participants to demonstrate their ability to use the applications covered in the programme. Assessment component Weight Microsoft Word practical exercise 10% Microsoft Excel practical exercises 35% Microsoft PowerPoint assignment 10% Microsoft Outlook practical exercise 10% AI practical exercises 10% Final integrated practical project 25% TOTAL 100% Assessment methods will include practical exercises, individual assignments, observation of practical application, review of completed documents and spreadsheets, and a final integrated project. Suggested achievement benchmark: Participants should obtain at least 50% overall to demonstrate satisfactory completion, subject to the institution's applicable assessment and certification requirements. Expected Learning Outcomes Upon successful completion, participants should be able to: • Prepare professional business documents and CVs. • Use Microsoft Excel for everyday calculations and data management. • Apply common formulas and functions to solve practical problems. • Organise and analyse data using tables, filters, lookup functions and Pivot Tables. • Prepare basic business reports and dashboards. • Design and deliver professional presentations. • Communicate effectively through professional emails and calendar management. • Use AI assistants to improve productivity and support office-related tasks. • Apply responsible AI practices and verify generated information. • Demonstrate basic digital competencies relevant to entry-level office and administrative roles. Participant Requirements • Basic computer knowledge. • Access to a laptop or desktop computer (smartphone-only participation is not suitable). • Reliable internet connection. • Working microphone and preferably a webcam. • Access to Microsoft Word, Excel, PowerPoint and Outlook through an eligible Microsoft account or other permitted access arrangements. • Access to an AI assistant for practical AI exercises. Training Resources Excelit Co Ltd will provide online training sessions, practical exercise files, sample datasets, supporting learning materials, practical assignments, trainer guidance and final assessment activities. Certification Participants who successfully complete the programme and satisfy the applicable attendance and assessment requirements may be awarded a certificate of completion, subject to the institution's relevant approval and certification arrangements. Practical Digital Skills for Tomorrow's Workplace.

| Table of Content | Advanced Features of Microsoft Excel

| Table of Content | 2. Artificial Intelligence & Digital Transformation Applied Generative AI for Office Productivity

| Table of Content | ➔ Applied Generative AI for Office Productivity – Rs 22,500 Duration: 6 hrs Trainers: 1. Renveer Ramsaha 2. Bruno Monteiro Target Audience Working professionals across functions such as administration, marketing, human resources, customer service, and operations who are required to apply generative artificial intelligence within their professional tasks. The programme is suitable for trainees with basic digital literacy. The training is accessible to people with disabilities. Course Overview This 6-hour programme equips the trainee with the practical competencies required to apply generative artificial intelligence to professional tasks in a structured and accountable manner. It progresses from the formulation of effective instructions, through the grounding and verification of AI outputs against source information, to the design of reusable assistants and the application of AI to core professional tasks. Throughout, emphasis is placed on responsible and verified use, with the trainee remaining accountable for every output. Course Objectives: By the end of the course, participants should be able to: • Formulate and refine effective AI instructions using role, context, task, output format and tone to generate relevant and structured responses. • Provide appropriate source documents and information to AI tools to obtain context-based outputs rather than relying solely on generic knowledge. • Retrieve, extract and summarise relevant information from multiple documents using natural- language queries and verify the accuracy of AI-generated outputs against original sources. • Identify inaccurate or fabricated AI-generated information and apply appropriate verification measures before using or sharing the results. • Design and configure reusable AI assistants with defined roles, contexts and instructions to perform specific professional tasks consistently. • Apply generative AI tools to draft professional communications, prepare documents and presentations, and produce summaries and analyses to support everyday workplace activities. • Select appropriate AI approaches for different professional tasks and review generated outputs to ensure their accuracy, relevance and suitability before use. • Apply generative AI responsibly, maintaining professional judgement and accountability for all AI-assisted outputs. Module 1: Structuring and Controlling AI Instructions Duration: 1.5 hours 9. Construct an instruction using the four core components of role, context, task, and output format, including tone. 10. Provide worked examples to guide the system towards a required style or structure. 11. Specify and control the length, structure, and register of the generated output. 12. Refine an instruction iteratively and explain why successive responses to an identical instruction may differ. Module 2: Grounding AI Outputs in Source Information and Verifying Results Duration: 1.5 hours ● Supply the system with appropriate source material, such as documents, records, and meeting transcripts, so that responses reflect organisational reality rather than generic knowledge. ● Retrieve relevant documents and passages through natural-language queries, and recognise the limitations of keyword-based search.

| Table of Content | ● Extract and summarise information across multiple documents while citing the underlying sources. ● Verify outputs by examining the cited sources and the reasoning, identify fabricated or inaccurate content, and confirm material information before relying on it. Module 3: Designing Reusable AI Assistants Duration: 1.5 hours 13. Configure a reusable assistant by defining a fixed role, context, and set of instructions, removing the need to restate these at each use. 14. Design single-purpose assistants that perform one defined task reliably, such as classifying incoming items into pre-defined categories. 15. Apply these assistants within everyday working tools and share them with colleagues to standardise practice across a team. Module 4: Applying AI to Core Professional Tasks Duration: 1.5 hours ● Draft and refine professional written communications, adapting tone, length, and format to the intended recipient. ● Produce and structure documents and presentations from existing content. ● Generate concise summaries and analyses of source material to support decision-making. ● Select the appropriate approach for a given task and review the result before use. Duration Summary Module Duration 1. Structuring and Controlling AI Instructions 1.5 hrs 2. Grounding AI Outputs in Source Information and Verifying Results 1.5 hrs 3. Designing Reusable AI Assistants 1.5 hrs 4. Applying AI to Core Professional Tasks 1.5 hrs Total 6.0 hrs Practical Exercises Practical exercises will be adapted as per the participants’ needs.

| Table of Content | Business Process Optimisation with AI

| Table of Content | ➔ Business Process Optimisation with AI – Rs 30,000 Duration: 12 hrs Trainers: 1. Renveer Ramsaha 2. Bruno Monteiro Target Audience All employees wishing to integrate AI into their daily work. This training is suitable for Marketing, Human Resources, Customer Service, and Operations departments. The training is accessible to people with disabilities. Course Overview This 12-hour training programme aims to make teams operational in the use of generative AI. It focuses on transforming theory into immediate practical application by concentrating on real business processes. Participants will learn to master tools such as ChatGPT and Gemini to improve productivity through a progressive learning approach structured around 4 key stages. Course Objectives: By the end of the course, participants should be able to: • Explain the fundamentals, capabilities and limitations of generative AI tools and large language models (LLMs), such as ChatGPT and Gemini. • Identify opportunities to integrate AI into existing business processes to automate tasks, improve efficiency and enhance productivity across different business functions. • Formulate, structure and refine effective prompts using appropriate prompt engineering techniques to obtain relevant and useful AI-generated results. • Apply generative AI tools to practical business activities, including professional writing, summarisation, content creation, brainstorming and information analysis. • Use AI to address specific operational requirements and challenges within departments such as Marketing, Human Resources, Customer Service and Operations. • Evaluate AI-generated outputs critically, identify potential inaccuracies or hallucinations, and apply appropriate verification methods before relying on the results. • Recognise potential AI-related risks, including algorithmic bias, confidentiality breaches and ethical concerns, and apply responsible AI practices within the workplace. • Select appropriate AI applications and approaches to improve existing workflows while maintaining professional judgement, data confidentiality and accountability. Module 1: AI Fundamentals and Language Models Duration: 3.0 hours 16. Understanding the AI ecosystem: Gain a clear understanding of the role, capabilities, and limitations of language models (LLMs) such as ChatGPT and Gemini. 17. First steps: Perform initial interaction tests to understand the tool. 18. Conversational logic: Learn how the machine “thinks” to communicate with it more effectively. Module 2: Methodology and Prompt Engineering Duration: 3.0 hours ● Supply the system with appropriate source material, such as documents, records, and meeting transcripts, so that responses reflect organisational reality rather than generic knowledge. ● Retrieve relevant documents and passages through natural-language queries, and recognise the limitations of keyword-based search. ● Extract and summarise information across multiple documents while citing the underlying sources. ● Verify outputs by examining the cited sources and the reasoning, identify fabricated or inaccurate content, and confirm material information before relying on it.

| Table of Content | Module 3: Business Skills and Use Cases Duration: 3.0 hours 19. Industry-specific applications: Apply AI to the specific needs of your profession (Marketing, HR, Customer Service, etc.). 20. Productivity and creativity: Adopt practical use cases (writing, summarisation, ideation) to improve efficiency. 21. Practical workshops: Hands-on exercises based on real scenarios from participants’ professional environments. Module 4: Governance, Ethics, and Security Duration: 3.0 hours ● Responsibility and bias: Learn how to avoid, detect, and correct algorithmic biases in AI outputs. ● Risk management: Understand AI hallucinations and learn how to verify results. ● Confidentiality: Master best practices for data confidentiality and raise awareness of ethical challenges within the organisation. Duration Summary Module Duration 1. AI Fundamentals and Language Models 3.0 hrs 2. Methodology and Prompt Engineering 3.0 hrs 3. Business Skills and Use Cases 3.0 hrs 4. Governance, Ethics, and Security 3.0 hrs Total 12.0 hrs Practical Exercises Practical exercises will be adapted as per the participants’ needs.

| Table of Content |

| Table of Content |

| Table of Content |

| Table of Content |

| Table of Content | 3. Leadership, Management & Professional Skills Communicating with Clarity, Confidence and Emotional Intelligence

| Table of Content | ➔ Communicating with Clarity, Confidence, and Emotional Intelligence – Rs 9,000 Duration: 3 hrs Trainers: 5. Abtaheebh Syllymunjeeajee Target Audience This course is designed for Anyone who interacts frequently with colleagues, customers, or stakeholders. Professionals who want to strengthen clarity, confidence, and connection in the workplace Course Overview Foundations of Effective Communication is an engaging, activity-based program designed to help professionals understand how communication really works — and why breakdowns occur so easily. Participants will learn the essential principles of communication, discover how assumptions and “noise” distort messages, and explore how emotional intelligence (EQ) shapes their interactions. Through hands-on activities, simulations, and real workplace examples, they will develop stronger awareness of their own communication habits and learn practical tools to communicate more clearly and confidently. Course Objectives: By the end of the course, participants should be able to: • Explain the fundamental principles of effective communication and the importance of clear, accurate and purposeful communication in the workplace. • Apply the 7Cs of Effective Communication to improve the clarity, structure and effectiveness of workplace messages. • Describe the communication process and identify how noise, assumptions, personal filters and different communication channels can affect the understanding of messages. • Recognise common barriers to effective communication and apply practical strategies to minimise misunderstandings in workplace interactions. • Demonstrate emotional intelligence by recognising how emotions influence communication, tone, reactions and interpersonal relationships. • Apply appropriate communication techniques when dealing with stressful situations, disagreements and workplace conflicts. • Identify their own communication style, strengths and areas for improvement to build greater confidence and more effective professional relationships. • Develop a personal action plan with practical objectives to strengthen their communication skills and improve interactions with colleagues, customers and stakeholders. Module 1: Introduction to Effective Communication Duration: 20 minutes 22. What is effective communication & why it matters 23. The cost of miscommunication in the workplace 24. The 7Cs of Effective Communication Module 2: The Communication Process Duration: 30 minutes ● Shannon & Weaver Communication Model ● How messages get distorted (noise, assumptions, filters) ● Verbal vs non-verbal channels Module 3: Barriers to Communication Duration: 35 minutes 25. Types of barriers 26. How biases and assumptions shape meaning 27. Workplace examples and quick solutions

| Table of Content | Module 4: Emotional Intelligence & Communication Duration: 40 minutes ● Goleman’s EQ framework ● How emotions affect tone, clarity, and reactions ● How to communicate under stress & during conflict Module 5: Understanding Your Communication Style Duration: 30 minutes ● Overview of common communication styles ● Micro-reflection: What is my natural style? Module 6: Personal Reflection & Action Plan Duration: 25 minutes ● Identify communication strengths & blind spots ● Set one communication improvement goal ● Guided discussion ● Closing and Q&A Duration Summary Module Duration 1. Introduction to Effective Communication 20 min 2. The Communication Process 30 min 3. Barriers to Communication 35 min 4. Emotional Intelligence & Communication 40 min 5. Understanding Your Communication Style 30 min 6. Personal Reflection & Action Plan 25 min Total 3.0 hrs

| Table of Content |