Skip to content
+91 98881-12947
+91 98882-12947
+91 99881-12947 (Reception)
contact@uiitedu.com
SCF 6 (2nd & 3rd Floor) , Phase 11, Mohali
Online Test
Our Courses
Basic Courses
Computer Typing Course
Basic Computer Crash Course (90Hrs)
English Language Course
Advanced Courses
Web Development
Full Stack
Back-end
Front-end
React JS
Digital Marketing Course
Designing Courses
Programming Languages
Tally & Accounting Course
ISO Certified Courses
Industrial Training & Internship
Spoken English Course
Advance Excel Professional Course
MS Office Professional Course
Special Add On Course for Office Work
Diploma in Computer Application (DCA)
Computer Hardware Course
Data Analytics Course
Machine Learning (ML) Course
Artificial Intelligence (AI)
Beginner Level
For Below 10th Students
Job Oriented Course
For 10th Above Students
IT Courses
For College & University Students
Professional Courses
For Office Professionals & Businessmen
About Us
What Makes Us Different?
Our Team
Job-Placed Students
Gallery
Certificate Verification
Blogs
Contact
X
Advanced MS Excel
Course Duration : 3 Months or 120 Hours
Topics to be
Covered
:
Basic Excel, All Shortcuts, Google Spreadsheet
All Options / Sub-Options, 150+ Formulas including Text, Logical, Date/Time, LookUp, Maths & Financial
Expertise in VLookUp / HLookUp, Power BI Overview
Pivot Table/Chart, Power Queries, AI with Excel
References (Relative, Absolute, Mixed)
Data Analysis Techniques, Interactive Dashboards
Automatic Attendance Sheet, Salary Sheet
Advanced Filters, Multilevel Sorting, File Protection
Data Validations, Macros & MIS Reports
Full COURSE Fee : Just 8,400 /-
Monthly Fee : Just 3,300 /-
