Kick off the course with an introduction to the instructor, course objectives, and an overview of the skills to be mastered. Discuss the importance of advanced Excel and AI tools in modern data analysis.
Deep dive into Excel's advanced interface, including ribbons, quick access toolbar, and customization. Learn essential shortcuts and productivity hacks for efficient workflow.
person_outline
3. Data Importing & Cleaning Fundamentals
1 hr
expand_more
Learn to import data from various sources (CSV, web, databases) and apply basic cleaning techniques such as removing duplicates, handling blanks, and formatting data.
person_outline
4. Power Query for Data Transformation
1 hr
expand_more
Explore Power Query to automate data cleaning and transformation. Practice merging, appending, and shaping data for analysis.
person_outline
5. Data Validation & Error Checking
1 hr
expand_more
Learn to set up data validation rules, use error checking tools, and ensure data integrity for large datasets.
Master IF, IFS, VLOOKUP, HLOOKUP, XLOOKUP, and INDEX-MATCH to perform complex data analysis and automate decision-making.
person_outline
7. Array Formulas & Dynamic Arrays
1 hr
expand_more
Understand traditional array formulas and new dynamic array functions like FILTER, SORT, UNIQUE, and SEQUENCE for powerful data manipulation.
person_outline
8. Text Functions & Data Parsing
1 hr
expand_more
Learn to use TEXT, LEFT, RIGHT, MID, FIND, SEARCH, and TEXTJOIN to clean and restructure textual data for analysis.
person_outline
9. Date & Time Functions for Analysis
1 hr
expand_more
Explore DATE, TIME, EOMONTH, NETWORKDAYS, and other functions to analyze and visualize time-series data.
person_outline
10. Conditional Formatting for Insights
1 hr
expand_more
Apply advanced conditional formatting rules to visualize trends, identify outliers, and enhance data-driven storytelling.
About the course
This instructor-led course empowers students to master advanced Excel functions, analyze large datasets, and automate repetitive tasks using both traditional Excel tools and cutting-edge AI technologies like Microsoft Excel Copilot and ChatGPT. Through hands-on projects and real-world datasets, participants will learn to clean and structure raw data, create insightful dashboards, and build AI-assisted Excel models. Ideal for students, professionals, and entrepreneurs, this course delivers practical skills that boost productivity and keep you ahead in today's data-driven world.
Availability
2 enrollment options available
Apr 26 (Sun)
6:00 PM
computer
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Sachin Arayans
Apr 26 (Sun)
1:00 PM
computer
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Sachin Arayans
About the academy
Computer training institute in Gurugram offering practical, job-oriented courses in Excel, Data Analytics, Programming, Tally, Web Development, and Design. With live projects and AI tools, GFCA helps students and professionals build real-world skills and become confident, job-ready.