Enquiry For Demo
Advance Excel Course
Advance Excel Certification
Boost up Program for Mastermind & Growth Hack
On Campus
Placementship Plus
Course Duration- 180 Hours
Course Objectives:
Master advanced functions, formulas, and arrays for complex calculations.
Analyze and summarize large datasets using PivotTables, PivotCharts, and Power Pivot.
Create interactive dashboards and advanced visualizations for data insights.
Social Media Expert Certification
Module 1: What If Analysis
- Goal Seek
- Scenario Analysis
- Data Tables
Module 2: Logical Functions
- IF Function
- How to Fix Errors - if_error
- Nested IF
- Complex IF & or functions
- Uses of AND, OR, NOT with IF Function
Module 3: Data Validation
- Number, Date & Time Validation
- Text and List Validation
- Custom validations based on formula for a cell
- Dynamic Dropdown List Creation using Data Validation - Dependency List
Module 4: Lookup Functions
- VLOOKUP / HLOOKUP
- Index and Match
- Creating Smooth User Interface Using Lookup
- Nested VLookup
- Reverse lookup using Choose Function
- Worksheet linking using Indirect
- Vlookup with Helper Column
Module 5: Pivot Tables
- Creating Simple Pivot Tables
- Basic and Advanced Value Field Setting
- Classic Pivot table
- Filtering PivotTables
- Modifying PivotTable Data
- Calculated Field & Calculated Items
- Advanced Use of formulas with Array
- Charts and slicers
- Manage Primary and Secondary Axis of Charts
Module 6: Working with Data Simulations
- Using Advance Methods of VLOOKUP and HLOOKUP
- Creating Database in Excel using Multiple Sheets and Formatting
- Uses of Data Validation for Inserting Data in Database
- Manipulating Data on Other Sheets
Module 7: MIS Reports
- Creating Structure of any Sales or Product or Required Data
- Filter Data with Dynamic Charts
- Show and Present Data using Search Bar
Module 8: Major Assignment & Job Profile
- Hands-on Major Project: Building Complete MIS Dashboard
- After Learning Job Profile:
- Office Experts / Computer Operator
- Data Entry Operator / Online Operator
- MIS Executive
- Data Analyst (Entry Level)
Latest posts
End-to-End Career Assistance
Comprehensive Career Support to Help You Shine
Resume Build
Upgrade and polish resumes to make them stand out to potential employers.
Industry Relevant Training
Learn From digital marketing industry experts with real-world experience.
Project Presentation
Develop presentation skills and refine projects with constructive feedback from peers and instructors.
Career Guidance
Dedicated Assistance to help figure out the right step for your career.
Personalize Emphasis
We ensure each student receives focused as we teach them key concepts
Mock Interview Drill
Comprehensive Guidance to master interview skills & land your dream job.
Be in the spotlight by getting certified!
Industry-Recognized Certificate
Aonsectetur adipiscing elit Aenean scelerisque augue vitae consequat Juisque eget congue velit in cursus leo
Stand Out in Job Market
Hammer out we need to socialize the comms with the wider stakeholder community exposing new ways to evolve
Your Passport to Career Growth
Focus on the customer journey we need to socialize the comms with the wider stakeholder community upsell window-licker
Offline
Online
Recorded
Total Program Fee:
รขโยน30,500 รขโยน25,500
- Live instruction from Industry Veterans
- Vibrant community just like a College Campus
- Hands-on curriculum with Real-Life Projects
Apply Now
Most Popular Courses
Data Analytics And Machine Learning
After working in coffee shops around the world Mark finds himself.
Data Analytics And Machine Learning
After working in coffee shops around the world Mark finds himself.
Our Alumni @ Top Company - OJD Placement Cell
.png)
Our Recuiters @ OJD Placement Cell
