top of page
Turn Data into Decisions: Analyse Data with Excel & AI
Turn Data into Decisions: Analyse Data with Excel & AI

Wed, 02 Dec

|

Free Live Webinar (Zoom)

Turn Data into Decisions: Analyse Data with Excel & AI

Free Live Webinar: Join British Alumni Network and McGraw Hill for a practical webinar and discover how Excel & AI can transform data into insights. Earn ₹2,949 discount on your Career Discovery Report - Register now!

Time & Location

02 Dec 2026, 4:00 pm – 5:30 pm IST

Free Live Webinar (Zoom)

About the event

Free Live Webinar | 02nd December 2026 | 4:00 pm IST

Jointly organised by British Alumni Network and McGraw Hill


Analyse Smarter. Work Faster. Make Better Decisions.

Data is everywhere. The ability to analyse it efficiently, uncover meaningful insights and turn information into informed decisions is a valuable professional skill.


Join us for a practical, demonstration-led webinar exploring how Microsoft Excel 365 and Artificial Intelligence can simplify data analysis, improve productivity and automate repetitive tasks.


Led by Mr Kogara Surendra Reddy, Microsoft Certified Trainer (MCT), this session will introduce participants to advanced Excel techniques, AI-powered analytical capabilities and practical business applications.


Whether you are a university student, recent graduate or early-career professional, discover how modern Excel tools can support smarter, more efficient working.


What Will You Learn?

01 | Smart Data Analysis with PivotTables & PivotCharts

Learn how to transform large datasets into meaningful summaries.

  • Understand how PivotTables simplify data analysis.

  • Create interactive data summaries.

  • Customise layouts to highlight business insights.

  • Visualise findings using PivotCharts.


02 | Advanced Excel Formulas for Real-Time Analysis

Explore powerful Excel functions used to analyse and organise information.

  • XLOOKUP & VLOOKUP: Find and retrieve information efficiently.

  • SUMIFS & COUNTIFS: Analyse data using multiple conditions.

  • FILTER: Extract relevant records from datasets.

  • SORT & UNIQUE: Organise and identify distinct information.

  • VSTACK: Combine multiple datasets into a single structure.


03 | Excel + AI: Smarter Data Analysis

Discover how AI-powered features in Excel 365 can support faster analysis and interpretation.

  • Introduction to AI in Excel.

  • Explore the Analyse Data (Ideas) feature.

  • Identify trends and patterns.

  • Understand smart data types such as Stocks and Geography.

  • Explore practical business applications of AI-assisted analysis.


04 | Power Query: Data Cleaning & Automation

See how Power Query can simplify data preparation and reduce repetitive manual work.

  • Import data from different sources.

  • Clean and transform unstructured datasets.

  • Merge and append data.

  • Automate repeatable data preparation steps.

  • Prepare datasets for analysis and reporting.


Webinar Agenda

4:00-4:05 PM | Welcome & Introduction

Introduction to the session and its practical objectives.

4:05-4:15 PM | Smart Data Analysis

PivotTables, PivotCharts and interactive reporting.

4:15-4:30 PM | Advanced Excel Formulas

XLOOKUP, VLOOKUP, SUMIFS, COUNTIFS and dynamic array functions.

4:30-4:45 PM | Excel + Artificial Intelligence

AI-powered insights, trend detection and business applications.

4:45-5:00 PM | Power Query & Automation

Data cleaning, transformation and workflow automation.

5:00-5:15 PM | Beyond Learning: Building Career-Ready Digital Skills

Explore how structured digital learning, practical assessments and digital credentials can help students develop, validate and showcase their skills.

5:15–5:25 PM | Interactive Q&A

Engage with speakers and explore questions about Excel, Artificial Intelligence, digital skills and professional development.


Meet the Speakers

Mr Kogara Surendra Reddy

Microsoft Certified Trainer (MCT) | Corporate Trainer, Mentor & Consultant



With over 18 years of corporate experience, including 8+ years in professional training and consulting, Mr Surendra Reddy specialises in Microsoft Excel, Power BI, Microsoft 365 Copilot and AI-powered productivity tools.

Having worked with organisations including EY, Deloitte, Capgemini and AtkinsRéalis, he brings practical business experience to his training sessions. He has delivered training to over 25,000 professionals and students, helping learners apply technology to real-world business challenges.


Session Focus: Smart Data Analysis, Advanced Excel Formulas, AI-Powered Insights and Automation.


Mr Rahul Kalia

Associate Director | McGraw Hill



With over 14 years of international business experience across India, the UK and Ireland, Mr Rahul Kalia specialises in educational technology, digital transformation and enterprise learning solutions.

At McGraw Hill, he works across digital learning platforms, supporting technology adoption and partnerships. An MBA graduate in International Business from Nottingham Trent University, UK, he brings insights into structured learning, digital skills development and the role of technology in modern education.


Session Focus: Beyond Learning - Building Career-Ready Digital Skills.


Who Should Attend?

This webinar is suitable for:

  • University students and recent graduates.

  • Students exploring careers in Data Analytics, Business Analytics, Finance or Marketing.

  • Beginners interested in developing practical Excel skills.

  • Individuals curious about the professional applications of Artificial Intelligence.

  • Early-career professionals seeking to strengthen their analytical capabilities.

No prior Excel or AI experience is required to attend.


Exclusive Webinar Participant Benefit
Certificate of Participation

Eligible participants attending the webinar will receive a Certificate of Participation, recognising their engagement in the learning session jointly organised by British Alumni Network and McGraw Hill.


Discover Your Career Direction with the Career Discovery Report: Just ₹1

As a special benefit, eligible participants attending the Turn Data into Decisions: Analyse Data with Excel & AI webinar can access the personalised Career Discovery Report by British Alumni Network at an exclusive price.


Regular Price: ₹2,950/-

Exclusive Webinar Participant Price: ₹1 ONLY


The Career Discovery Report helps you discover:

  • Top Career Matches

  • Your Personality Traits

  • Key Strengths

  • Academic Recommendations

  • Gap Analysis and development areas

  • Strongest capabilities

  • Technical skills you need

An exclusive opportunity to explore your career potential for just ₹1.

Redemption details will be shared with eligible webinar participants.


Beyond the Webinar: Put Your Skills into Practice

Interested in developing these skills further?

Explore the SIMnet Skills Training + AI Industrial Training Externship pathway offered by Academy by British Alumni Network.


Ready to Turn Data into Decisions?

Join this free live webinar to discover how Excel and AI can support smarter data analysis, better productivity and professional skill development.


Wednesday, 02 December 2026 | 4:00-5:30 pm IST

Free Registration | Live Online Webinar


Exclusive Webinar Benefits

Attend the live Excel & AI webinar and receive:

  • Certificate of Participation

  • Career Discovery Report for just ₹1 (Regular Price: ₹2,950)


Register Now - Reserve My Seat!

Share this event

bottom of page