

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!