Online & Offline Training Institue

Advanced Excel

Program Duration- 20 Hrs | Platform – Online / Classroom

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

    Pay After Placements

    Top instructors will teach millions of students

    No cost EMI are available
    Top instructors from around the world teach millions of students