Advanced Excel
Program Duration- 20 Hrs | Platform – Online / Classroom
- Live Class
- Industry projects
- 1:1 mentorship
- Secure Placement Assistance
Course Overview
Learn the most advanced formulas, functions, and types of financial analysis to be an Excel power user. This advanced Excel training course builds on our free Excel Fundamentals – Formulas for Finance. It is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.
This advanced tutorial will help you become a world-class financial analyst for careers in investment banking, private equity, corporate development, equity research, and FP&A. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, rewatch, and repeat exercises until you’ve mastered them.
Curriculum
Advanced Excel
- Basic Excel
- Paste Special
- Copying only formats
- Converting formulas into values.
- Doing mathematical operations.
- Paste Link
- Conditional formatting.
- Advanced Filtering.
- Data Consolidation
- Data Validation.
- Purpose of data validation.
- Mathematical Functions.
- Look-up Functions.
- Text Functions.
- Text Functions.
- Data Visualization By Conditional Formatting.
- What-If Analysis.
- Pivot Table.
Register Now
- Eligibility- B.E | B. Tech | BCA | BSc | MCA | M. Tech
Throughout 50% and Above
Program Duration- 20 Hrs
Platform – Online / Classroom
Send your queries
Enquire Now
Tools Used
Key Features
Upskill your Profile
Get a Job Guarenteed Course
20+ Professional Courses
Great place to Learn
1:1 Mentorship
100% Placement Assistance
Live Project
Global Certification
Professional Grooming
100% Assured Job
Upcoming Batches
What learners say about us
Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt labore
Mikel Haris
Student History
I believe in lifelong learning and they are a great place to learn from experts. I have lot of recommend it
James Smeeth
Student Biology
Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt labore
Leo Marea
Student Math
I believe in lifelong learning and they are a great place to learn from experts. I have lot of recommend it
John Dowson
Student Physics