Prep Junction

Use Code FLAT30 and get flat 30% discount


Advanced Excel

Certification Course

Learn advanced Excel today!

₹ 1499  ₹ 3000

Key Highlights



30 days

Estimated Time

15 June 2021

Next Batch Starts


  • Course Objective
  • Introduction
  • Importance of Excel
  • User Interface
  • Customizing Quick Access Toolbar
  • Basic Terminology
  • Keyboard shortcuts
  • Navigate in Excel
  • Basic Data Entry
  • Auto Fill and Flash Fill
  • Working with multiple sheets and workbooks

  • Basic Functions and Calculation
  • Understanding the Order of Operation
  • Relative and Absolute Cell Reference
  • SUM() and AUTOSUM
  • MAX() and MIN()
  • Modifying Data
  • Move, delete, insert, rename, duplicate worksheets
  • Cut, paste, insert, delete rows, columns and cells
  • Manage data
  • Worksheet Protection
  • Hide and unhide worksheets
  • Excel Formatting
  • Merge, Color change and align cells
  • Freeze and unfreeze rows and columns
  • Format painter
  • Customized value formats
  • Conditional Formatting
  • Printing worksheets

  • Advanced Functions
  • Text Functions
  • Date-Time Functions
  • Logical Functions
  • Financial Functions
  • Lookup Functions
  • Data Validation
  • Create a Drop-down list

  • Data Preparation
  • Find and remove duplicates
  • Sort and Filter
  • Slicer
  • Named range
  • Pivot Table
  • Charts
  • What-if Analysis

  • Project discussion
  • Next Steps

What Project will You be Working on?

Creating a Dashboard using Pivot Table

You will create a dashboard using pivot table, slicer and other concepts to analyse and visualize data.

Rithik Raina

Placed at ZS Associates in
Strategy Insights and Planning 
Hindu College, Delhi 


The mock test that I took gave me a good idea beforehand, about the questions I got in ZS’s test. This gave me an advantage over other students.

Anupriya Bammi

Placed at Deloitte USI as
Audit Assistant
IPCW, Delhi 


The mock sessions conducted by Prep Junction was really helpful and informative. They help us build our confidence, especially for the group discussion round.

Pratistha Gupta

Placed at Deloitte USI as
Audit Assistant
Gargi College, Delhi 


Prep junction’s mock test helped me in understanding the types of questions and their difficulty  levels that would come and helped me in my practice.

Prep Junction Advantage

Hands on learning
No boring lectures, learn while solving real-life problems
Placement Support
Free Resume Builder and other tools to ace the interview
Doubt Resolution
Ticketing based system to clear your doubts anytime
Personal Career Guide
All the support that you need to prepare for your dream career
Researched Curriculum
Courses curated with inputs from industry experts
Limited Batch Size
Optimum intakes per batch to enhance quality of learning


₹ 1499  ₹ 3000


All the courses are carefully curated with inputs from industry experts and different stakeholders to enable learners to have an enriching learning experience. The foundation of each courses are Live Classes, projects, notes, quizzes, practice tests and reports – all designed to enhance the learning experience of the students. You can visit the curriculum section for further details. Please feel free to contact us in case of any queries. The medium of discussion will be English.

Yes, we do provide scholarship to selected deserving candidates. Please apply here.

Yes, you can opt for more than one course at a time and there are no restrictions on the number of courses taken. We would like you to learn and utilize the opportunity to the maximum. However, we suggest you to get in touch with us for proper selection of courses according to your goal and profile. Please feel free to contact us at support@prepjunction.com

We do allow late joining in few courses to a maximum of 2 weeks. However, kindly contact us so that we can check you won’t lose anything.

The starting dates for different batches have been mentioned on the website, therefore advised to proceed accordingly. If you have any queries, please feel free to reach out at support@prepjunction.com.

Kindly mail us at support@prepjunction.com. We will reach out to you shortly.

We will mail you the details of your program schedule and materials after the successful purchase of the courses.

Yes, a certificate will be provided after the successful completion of the course. However, we encourage you to focus on the learning instead of earning the certificate.

If you have any other questions about Prep Junction, you can contact us here.