Advanced MS Excel for Data Analytics

4,8

About Course

Welcome to Talentele’s Data Analytics Masters Program, where we embark on a transformative journey to unlock the power of data and propel your career to new heights. Our Data Analytics course helps you learn essential skills for analyzing data effectively.

Over five months, you’ll work with real data and tools like SQL, Excel,Tableau,Power BI and Python. Our online format lets you study at your own pace, fitting around your schedule. You’ll gain a solid foundation in analytics, making you valuable to any organization.

We don’t just teach theory; we prepare you for real-world jobs with interview practice and resume workshops. Whether you’re new to data or want to advance your career, our course is for you. Join us and unlock the power of data analytics for your future success.

Featured Curriculum

Complete live classes with recorded training sessions.
Capstone projects.
Mock interviews (Technical, HR, Managerial).
1-1 Doubt-clearing sessions with SME.
Students Reversal Training programm twice a month.
Soft skill training with communication building.
6 Months Internship Certificate as Data Analyst Intern.
Resume crafting with ATS clearance.
Pre-placement assistance.
Free course certification support from IBM, Accenture, Infosys etc.
Profile Enhancement on different job portals.
Free Spoken English

Syllabus

• Introduction to Excel
• Referencing, Named ranges, Uses, Arithmetic Functions
• Logical Functions
• Referencing data from Tables
• Advanced Functions (Text , Date , Numeric)
• IF, NestedIF , AND , OR , NOT Functions
• Lookup Functions (Vlookup, Xlookup,index,match)
• Date & Time Functions
• Data Handling & Data Cleaning
• Data Summarization
• Data Visualization
• Pivot Table , Dashboards