BEST ADVANCE EXCEL TRAINING INSTITUTE IN DELHI NCR

XPERT SHIKSHA is one of top-notch Advance Excel  course provider institute in Delhi, it is the place where enthusiastic Excel experts share his experience and knowledge to aspiring marketers. Xpert Shiksha offers advance excel course to Students, Working Professional, Business Owners at its Advance Excel Training Institue In Delhi Ncr.

The best part of our Training program is that all our courses are practical based and full of innovation. The reason is simple, we believe in quality training and our syllabus is developed and taught by award-winning Data Analytic professionals. The live project training, live case studies, boot camps makes this training program more effective and compelling. 

As a result, it becomes the perfect platform for getting experience and much-needed exposure of Excel.

BECOME XPERT AT XPERT SHIKSHA

 

BOOK A SEAT NOW




PROGRAM HIGHLIGHTS

Instructor-led

Live interactive and classroom training will include the practical approach and assessments on regular basis.

Live Case Study

Case study using industry specific data helps you to get hands on with a good exposure.

Assignments

Assignments which helps in conceptual understanding, Prepared for interview training & techniques.

Lifetime Technical Support

We support our programs for as long as you go with it with FREE technical support by phone or email. No extra money will be charged.

Certification

After successful completion of the training and case study XPERT SHIKSHA will certify you as XPERT SHIKSHA certified Tally Xpert.

ADVANCE EXCEL COURSE MODULES

# MODULE 1

Excel User Interface

# MODULE 2

Auto Series

# MODULE 3

Addition and Subtraction

# MODULE 4

Multiply and Divide

# MODULE 5

Conditional Formula – IF

# MODULE 6

Complex Conditional Formula IF

# MODULE 7

AND OR Function

# MODULE 8

Fix Reference

# MODULE 9

Working with Date

# MODULE 10

Working with Time

# MODULE 11

Cell Formats

# MODULE 12

Conditional Formatting

# MODULE 13

Paste Special

# MODULE 14

Charts and Graphs

# MODULE 15

Filter and Sorting

# MODULE 16

Pivot Table

# MODULE 17

Slicer and Timeline Filters

# MODULE 18

Spark-lines

# MODULE 19

Power View

# MODULE 20

Freeze Pane

# MODULE 21

Protecting Sheets

# MODULE 22

Data Validation

# MODULE 23

Removing Duplications

# MODULE 24

V and H Lookup

# MODULE 25

Importing Data

# MODULE 26

Navigating

# MODULE 27

Working with Sheets

# MODULE 28

Excel Contingency Table

# MODULE 29

Printing Sheets

# MODULE 30

Page Break

# MODULE 31

Flash Fill

# MODULE 32

Loan EMIs (PMT)

# MODULE 33

Fixed Deposits (FV)

# MODULE 34

Recurring Deposits (FV)

# MODULE 35

Investment (PV)

# MODULE 36

Interest Rate

# MODULE 37

Goal Seek

# MODULE 38

Min and Max

# MODULE 39

Average Function

# MODULE 40

Count Function

# MODULE 41

Misc. Functions

# MODULE 42

Navigation Shortcuts

# MODULE 43

Powerful Tricks

# MODULE 44

Macros in Excel

FREQUENTLY ASKED ADVANCE EXCEL QUERIES

Xpert Shiksha is the premier marketing training institute in Delhi Ncr. We have experienced Google Certified Trainers who focus on practical training on Live projects. There are many hidden techniques and strategies which can help you in higher in the search engine and you can easily increase leads and sales once you become an Xpert.

Absolutely NOT. Topics are explained through step by step process in a very simple language which is easy for students to understand and learn. The entire Tally Online Course is designed to meet the requirements of industry and are approved from C.A. & Business Experts.

Generally it takes 30 to 45 days to complete entire Tally Course. However you can access entire course till 1 year. DVD and Download Link Contents come with Serial Key protection with 1 year validity on 1 computer.

We provide Email Support till 1 year for doubts and queries.

Once you complete your course, you can appear for Online Exams which are in MCQ format. On passing exams, you will be awarded with Tally Expert Course. Passing Marks 60% and you will get 3 attempts.

Yes we have created Tally Company Data for each and every session that you will learn.  This will help you to focus on the Topic you want to learn in a more Practical Way.

Government makes changes from time to time in Accounting and Taxation Rules and hence Tally Software always keep updating it’s features. We provide new Videos for update and new features in Tally Software absolute FREE upto ONE year. After 1 year, if you want, you can renew your subscription by paying 50% of Course Fees. (Optional)

STILL CONFUSED ABOUT DECISION?

Join our FREE Demo Session on ADVANCE EXCEL

We will answer all your questions about ADVANCE EXCEL  and career, salary, jobs etc. Then you can take decision

FREE DEMO

OUR LOCATION

BOOK A SEAT NOW




Career Assistance

The XPERT SHIKSHA Careers Assistance team provides you assistance throughout the program to guide and navigate ample career options.

RESUME BUILDING

Refining and polishing the candidates resume with insider tips to help them land their dream job

INTERVIEW PREP

Preparing candidates to ace HR and Technical interview rounds with model interview questions and answers

MOCK INTERVIEWS

Preparing candidates to face interview scenarios through 1:1 and panel mock interviews with industry veterans