Excel and SPSS

Mode- Live Online/Offline
100% practical sessions
Latest syllabus and Case studies
50+ Marketing tools
Learn from Industry expert

Excel and SPSS

4 Months

Course Duration

16 Modules

Course Modules

Offline/Online

Mode

Overview

Master the art of data analysis with our Advanced Excel course and IBM SPSS Course, designed to equip you with industry-relevant skills for handling and analyzing complex datasets. In today’s data-driven world, proficiency in Excel and SPSS is essential for professionals in fields like business analytics, research, and data science.

This comprehensive course covers everything from advanced Excel functions, data visualization, and automation using VBA to statistical analysis and predictive modeling with IBM SPSS.

Tools Covered

Download Brochure

Course Curriculum

→ Overview of the Excel Interface
→ Navigation and Ribbon Customization
→ Creating and Saving Workbooks
→ Basic Cell Operations (Enter, Edit, and Delete)
→ Shortcuts and Productivity Tips

→ Basic Formulas: SUM, AVERAGE, COUNT
→ Text Functions: CONCATENATE, LEFT, RIGHT, MID
→ Logical Functions: IF, AND, OR
→ Date and Time Functions: TODAY, NOW, DATEDIF

→ Sorting and Filtering Data
→ Conditional Formatting
→ Data Validation
→ Creating Drop-Down Lists

→ VLOOKUP and HLOOKUP
→ INDEX and MATCH
→ Combining INDEX-MATCH with Arrays
→ Advanced Logical Functions: IFS and SWITCH

→ Creating and Formatting Charts
→ Pivot Tables and Pivot Charts
→ Conditional Formatting with Data Bars and Heat Maps
→ Creating Interactive Dashboards

→ Data Cleaning Techniques
→ Removing Duplicates
→ Splitting and Merging Data

→ Introduction to Macros
→ Recording and Running Macros
→ Editing Macros with VBA
→ Automating Repetitive Tasks

→ Data Analysis ToolPak
→ Goal Seek and Scenario Manager
→ Solver for Optimization
→ Forecasting and Trend Analysis

→ Overview of SPSS Interface
→ Importing and Managing Data Files
→ Understanding Variable Types
→ Creating and Labeling Variables

→ Sorting and Filtering Data
→ Recoding Variables
→ Merging and Splitting Data Sets
→ Data Cleaning in SPSS

→ Measures of Central Tendency: Mean, Median, Mode
→ Measures of Dispersion: Standard Deviation, Variance
→ Frequency Tables
→ Cross-Tabulations

→ Introduction to Hypothesis Testing
→ T-Tests (One-Sample, Independent, Paired)
→ Chi-Square Test
→ ANOVA (One-Way and Two-Way)

→ Pearson and Spearman Correlation
→ Simple Linear Regression
→ Multiple Linear Regression
→ Interpreting Outputs and Model Summary

→ Advanced Statistical Analysis
→ Cluster Analysis
→ Logistic Regression
→ Time Series Analysis

→ Creating Graphs and Charts
→ Customizing Visualizations
→ Exporting Reports and Graphs
→ Interactive Dashboards in SPSS

→ Hands-on Projects Integrating Excel and SPSS
→ Data Analysis Workflow for Business Problems
→ Data Analysis Workflow for Business Problems
→ Final Project Evaluation and Feedback

Certificate

Secure your career with an industry-recognized certificate that validates your expertise in Excel and IBM SPSS, you will also be certified by Microsoft which will further boost your credibility, enhance your resume, and open the doors to limitless career opportunities

Certificate from company

Course completion certificate

Get certified by leading global companies

Authorized training and certification programs powered by top MNCs. Learn from the best, get globally recognized

Get future-ready with Global certifications

Authorized IBM Certification Partner

Earn an official
certification by

IBM

Professionals at Your Service

Vikas Singh
Cyber Security expert

Vivek Singh has exposure to many Indian tech companies like HCL, Tech-Mahendra, and many more, He has handled many Network security and cybersecurity projects.

Ravi Singh
Performance Marketer

Ravi has got more than 5 years of experience in Performance marketing he has handled more than 50cr budget for various realestate and education brands.

Amar P
Sr. Performance Marketer

Having more than 14 years of experience in Digital marketing, have managed agencies and have handled domestic and international brands with budget capacity as high as 100 million US dollars.

Ankush P
AI engineer

Ankush is an AI engineer, IIIT graduate, and GATE-qualified professional currently working in an AI firm. he has expertise in Lang Chain, Llama Index framework, and agentic.

Divya Bansal
Research Analyst

Divya has extensive work experience of more than 8 years in the research industries like IPSOS, AC Nielsen, and many more, She has handled research work for many organizations.

A Vasisht
Senior Data Scientist

A. Vasisht is a seasoned Senior Data Scientist with over 10 years of experience, having worked with leading organizations such as Qatar Development Bank, Ernst & Young, Optum, and several other multinational firms.

FAQ’s

This course is ideal for professionals, students, and researchers who want to enhance their data analysis skills using advanced Excel techniques and IBM SPSS.

Basic knowledge of Excel and statistical concepts is recommended but not mandatory, as the course starts with foundational topics.

You’ll master functions like VLOOKUP, INDEX-MATCH, Pivot Tables, data visualization, macros, VBA automation, and advanced data analysis techniques.

Topics include data management, descriptive statistics, hypothesis testing, regression analysis, factor analysis, and advanced statistical modeling.

The course is divided into 16 modules covering both Advanced Excel and IBM SPSS, with practical assignments and real-world projects.

Student feedback and experiences

Students appreciate Analytics and AI Academy's hands-on training, expert guidance, and actionable in...

Ansh Bargoti Jain

Application Engineer II @ Flipkart

Analytics And AI Academy empowers students with real-world business strategies, mentorship, and prac...

Abhishek Bora

Analyst/SDE @ Capgemini

The faculty at Analytics and AI Academy are awesome they focus on hands-on experience, which enhance...

Ayushi Mathur

Engineer @ Naagrro

Students thrive at the Analytics and AI Academy through interactive learning, industry insights, and...

Zubair Ahmed

Growth Intern @ Languify

Analytics And AI Academy's structured approach, industry-driven mentorship, and real business case s...

Tushar Bhardwaj

SDE Intern @ Microsoft

Students value the Analytics and AI Academy for its immersive AI learning, expert-led coaching, and...

Bikul Parakh

SDE @ Thomson Reuters

Analytics and AI Academy transforms students’ analytics perspectives with hands-on training, industr...

Mayani Srivastava

SDE @ RafterOne

With Analytics and AI Academy's AI insights, students develop problem-solving skills, strategic thin...

Mohammad Amir Idreesi

SDE @ BUDDI AI

Analytics and AI Academy fosters student growth through expert-led training, business development st...

Rahul Ray

MTS 2 - Backend @Aquera

I would like to thank the Analytics and AI Academy for its invaluable mentorship, business acumen de...

Santhosh Medarametla

DevOps Engineer I @ DP World

Analytics And AI Academy equips students with the right tools, knowledge, and mentorship to excel in...

S Nandhini

Project Management Consultant I @ FICO

Through Analytics and AI Academy's interactive learning approach, students gain real-world exposure,...

Twinkle Gupta

Engineer at Q2

Students experience business transformation at Analytics And AI Academy , gaining strategic knowledg...

Pranav Kutty

SWE at Lowe's India

Analytics and AI Academy provides students with hands-on AI training, expert mentorship, and strateg...

Prerit Chaudhary

SDE @InsuranceDekho

Students gain real-world business knowledge, mentorship, and practical experience at Analytics and A...

Rittike Ghosh

SDE 1 at Clover Bay Technologies Pvt Ltd

Analytics and AI Academy's structured learning, expert-led coaching, and real-life case studies help...

Saumya Srivastava

DevOps Engineer @ LeadSquared

Through Analytics and AI Academy, I got a placement in my desired role, I recommend students to take...

Akash Chauhan

Software Developer @ LeadSquared

Analytics and AI Academy enhances students’ tech acumen with practical learning, expert guidance, an...

Harsh Dubey

Digital Technology Analyst at NTT Data Company

Students appreciate Analytics And AI Academy's immersive entrepreneurial training, mentorship, and h...

Avinash singh

Digital marketing manager

The Academy transformed my understanding of AI and analytics. Real datasets, expert guidance, and pr...

Ankit Shukla

SDE-II at InsuranceDekho

Analytics and AI Academy provides top-notch training. The sessions are interactive, the mentors are...

Guttapalyam Praveen Kumar

R & D Software Engineer at Tejas Networks

AAA is a great institute that focuses on practical learning. Their experienced faculties are from to...

Laxmi Rai

SDE @Exotel

Analytics and AI Academy offers insightful, industry-relevant learning with practical exposure. Exce...

ARIJIT ROY

Engineer 1 @ PowerSchool

I want to thank Analytics and AI Academy for getting me with Phone Pe as a Digital marketing executi...