Key Highlights
- Learn 57+ concepts, 62+ formulas and functions
- Certificate of Training from Prep Junction
- Hands-on Learning - 4 assignments and 1 project
- Placement Assistance - FREE access to Placement Preparation Crash Course (Self-paced)
ONLINE
Methodology
30 days
Estimated Time
1 March 2021
Next Batch Starts
Curriculum
- 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()
- AVERAGE(), MEDIAN() and COUNT()
- 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.
Placement Assistance
Placement Preparation
Crash Course (Self-paced)
Get FREE access and learn how to build a winning Resume and LinkedIn profile and a holistic learning approach to prepare for personal interview to convert your dream job.
- Online Training Sessions by IIM Alumni (Self-paced)
- Winning Resume and Cover Letter Templates
- 5+ Comprehensive and Sectional Aptitude Tests
Prep Junction
Community Membership
Get FREE access to Prep Junction Community Membership for a year and get insights about hiring processes of Top companies across industries.
- 25+ Career and Industry Insights Sessions in a year
- 25+ Career & Skill Development Webinars in a year
- Opportunity to interact with industry experts
Prep Junction Advantage

Personal Career Guide

Hands on learning

Limited Batch Size

Researched Curriculum

Placement Support

24/7 Doubt Resolution

Alerts & Notifications

Industry Interaction

Free Study Materials
- Learn 57+ concepts, 62+ formulas and functions
- Certificate of Training from Prep Junction
- Hands-on Learning - 4 assignments and 1 project
- Placement Assistance - FREE access to Placement Preparation Crash Course (Self-paced)
FAQs
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.