Advance Excel Course

A to Z of Excel in one course. Learn everything from start.

  • 3.5 Hrs on Demand Video
  • 7 Articles
  • 15 Downloadable Resources
  • Full Life Time Access
  • Assignments and Interview Cases
  • Certificate of CompletioN
Best Seller (4.89)
4.8/5
Play Video

Course Summary

  • Master Microsoft Excel for daily work
  • Work with Logical and Conditional Operators
  • Use Sumifs, Counties, and Average ifs with data and solve problems
  • Create beautiful and easy-to-understand charts in excel for data visualisation
  • Practice interview cases related to real interviews
  • The course in the live class variant will have 10 Hrs classes plus 8 Hrs of doubt solving.
No prior knowledge or skills required. You only need a laptop and Excel. Rest we will take care of.
  • Get lifetime validity of portal access and updates
  • Get Course completion certification on completion of the course requirements

Course Description

Are you looking to learn Excel, but finding it very difficult with all the technical jargons and concepts been thrown around?

Are you looking to make your life easier and make Excel work for you and save time?

Then you are at the right place. Excel is one of the most widely tool use for various kinds of tasks and makes your life easy at work. If you do not know how to use excel, you are missing on a superpower that Excel provides in your work. So buckle up and learn with us and become a superhero at work.

This course does not require you to have any pre-requisite knowledge or skills. This course will teach everything from beginning. This course has got you covered for everything.

 

In this course, you will learn the following:

Excel Introduction: Here you will learn how excel is structured. You will learn about Excel Worksheets, cells, and tabs. You will learn about Cell Referencing and its importance.

Excel Operators: In this section, how to write a function in Excel and make use of different functions and operators, such as logical operators and conditional operators, which are available in Excel.

Excel Data Analysis: Excel is widely used to analyse data and build models. Here you will learn how you can analyse data using Pivot, VlookUp and create various charts and dashboards for Data Visualization.

What do you get:

· Well-designed focussed content on explaining concepts and building skills

· Extensive question bank and case studies for practice

· Downloadable course materials

· Regular course updates

· Forum doubt-solving answers quickly

· This course has 30-day Money Back guarantee. We believe in providing value to the student. So, you get to explore the course and make an informed choice.

· You will get 24×7 doubt solving access.

· All concepts covered with practical application

We always strive to put student’s learning experience over everything else. So, we do look-out for your feedback on how we can improve our course and give our students a better learning experience. So, any suggestions for improving the learning experience is always welcomed.

Recommended For

Advance Excel Course Fees

Self Paced - Basic

  • Pre-recorded Videos

  • Forum Support 

  • 1 Year Content Access

  • Course Certification

  • Fees – ₹1999  (+ GST)

Self Paced - Plus+

  • Personal Mentorship*

  • Lifelong Content Access*

  • Course Certification

  • Community Access

  • Fees – ₹2999  (+ GST)

Live Online - Basic

  • Live Online Classes *

  • Personal Mentorship*

  • Interview Cases

  • Lifetime Content Access

  • Fees – ₹3999  (+ GST)

Course Content

Excel LayoutPreview
Home RibbonPreview
Other RibbonsPreview
  • Quiz
 
Relative Referencing19:42 Mins
One Dimensional Data Table05:11 Mins
Case Study Relative Referencing 
  • Relative Referencing Quiz
Daily Functions06:40 Mins
Daily Excel Quiz0.8 Mins
Case Study30 Mins
The Need of Logical Operators04:06 Mins
IF Function09:46 Mins
Nested If Function09:55 Mins
  • Logical Operators Quiz
  • Nested If Stock Market Indicator Case
Conditional Operators07:57 Mins
Quiz05:00 Mins
Case study02:00 Mins
Pivot Table20:24 Mins
Vlook Up12:27 Mins
Index & Match Function09:42 Mins
  • Quiz of Vlook up
  • Quiz Pivot Table
Excel Charts35:00 Mins
Data Visualisation Best Practices19:49 Mins
Data analysis assignment30:00 Mins
  • Case study Data Set
  • Analysis Questions
  • Solution File
  • Market Crash Indicator
  • Quiz
  • Solution File

Completion Certificate

Instructor Profile

Allen Aravindan, CFA

Rythum Verma,CFA Level III

Amit K,FMS Delhi

Reviews

Pratik bhute
Pratik bhute
2022-06-22
They have the best Financial modeling training program, Course is very well designed and faculty is highly professional and supportive.
Nidhisha Rai
Nidhisha Rai
2022-05-31
I've taken up Financial modeling course here and the experience is great so far. I would definitely recommend this course to someone who wants to build their career in this field.
Adwait Niphadkar
Adwait Niphadkar
2022-05-31
All the mentors are well experienced and well qualified. They teach everything from the basics which is very helpful to understand each and everything in detail.
Jai Chawla
Jai Chawla
2022-05-31
The financial modeling course is highly recommended for a career in finance. Mentor me carrer is offering the best curiculam in this. Along with this faculties are really good and they are always ready to help you in every circumstances during the course. I'm happy to be a part of mentor me .
Pranav Pathak
Pranav Pathak
2022-05-29
Mentor Me has helped me gain valuable skills and helped me polish skills that i had and that somewhat were rusty.They have great teaching style and faculties were prompt in helping out whenever i was stuck.
Akash Gupta
Akash Gupta
2022-05-29
The journey with Mentor Me Careers is quite rewarding. The knowledge was there, but this course transformed that talent into a job landing skill. The Financial Modelling and Valuations Course perfectly aligns you to the skills which will be required in your future finance role. The course is very well designed, and the portal does not let you skip learning outcomes. Assignments are issued for you to implement your skills side by side. The faculties here explain everything along with practical examples. I would personally like to thank Mr. Allen Aravindan, who guided me like a mentor in my job hunt process, and Anirudh Hingmire as he helps you a lot with managing your course. The placement team goes out of the way to assist you landing a job.
Sumit Borgave
Sumit Borgave
2022-05-28
Excellent Financial Modeling Program.. I liked real life business scenario examples and also placement assistance.

Frequently Asked Questions

Since mentor me stands for learning, each mentor listed on mentor me can run as many courses as they want but can only take 20 mentees( students) in batch to maintain delivery and at a time mentor 20 students overall.

You will have access two methods of doubt solving, provided that you are the basic plus or the Live variant.

  • Weekly Two sessions on Zoom, which can be accessed either from phone or desktop.
  • Customer service widget, post your doubt and an expert will reply withing 12 Hrs.

Apart from the above two methods, more complicated doubts will be handled on a one to one call.

The live sessions are availble for one full batch. If you want to attend the next batch, then the 20% processing fee will be charged on the course price. 

The online classes are conducted on the Zoom platform, which are fully interactive Cameras on sessions where you can see, talk and share your screen.

No, and we never will.

Online classes are

  • Saves your time
  • More Personalised
  • Saves Fuel
  • Safe
  • It can be accessed from anywhere in the world

Why would we ever start a physical class?

24 Hrs is the time limit for a refund for any reason. Once Paid there is a no-refund policy.

By paying the difference amount of your variant and the variant, you wish to enrol for. The student relations officer would guide you 24 x7 for any such requirements