Training Highlights
Instructor Led Training
Weekly Doubt Clearing Sessions
Lifetime Assistance for Revision
Lifetime Login Access to Student Dashboard
World-Wide Valid Certification
Study Material, Assignments and Projects
Course Summary
About Course
The Advanced Excel course is designed for professionals looking to deepen their Excel skills. Learn advanced functions, data analysis techniques, and automation tools to handle complex data tasks efficiently. This course helps you leverage Excel's full potential for business analysis and decision-making.
Topics include
Advanced Formulas and Functions
- Array Formulas
- Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Conditional Formulas
- Text Functions and Date Functions
Data Analysis and PivotTables
- Creating and Customizing PivotTables
- Pivot Charts and Reports
- Data Analysis Toolpak
- What-If Analysis (Data Tables, Goal Seek, Solver)
Automation and Scripting
- Introduction to Macros and VBA
- Recording and Editing Macros
- Creating Custom Functions and Forms
- Automating Repetitive Tasks
Advanced Data Visualization
- Creating Complex Charts (Combo Charts, Sparklines)
- Using Conditional Formatting
- Dynamic Dashboards and Data Models
Project Work
- Building a Complex Financial Model
- Creating a Data Dashboard
Duration: 2 months
How will you get your certificate?
Excerpt Technologies IT Training Services is a pioneer in CS/IT training and most of the industries give great recognition to its certificate throughout India and abroad. Excerpt Technologies IT Training Services Certificates are ISO verified which makes it highly reputed comparing to the other local brands and helps the student get prioritized while going for job opportunities in the industry. Excerpt Technologies IT Training Services Software Training is conducted by highly knowledgeable trainers which help students to enhance their skill set by putting great emphasis on project-based learning.
is a leading IT solutions and services company established with a specific mission of providing comprehensive, top of the line solutions.
Contact Us
ITI Estate, Whitefield Road,
Mahadevpura Post Bangalore,
Karnataka-560048