We have launched our mobile APP get it now. Or Call us on- 9354229384, 9354252518, 9999830584.
Study IQ offers Online coaching courses for MS EXCEL through its Pendrive courses. Switch your learning to e-learning from top faculties of India and make your education digital that too with a comfort of home. Grab this course and prepare for MS EXCEL (Basic to Advance Level).

NOTE:  This Course is available in Hinglish Only (Written in English + Explained In Hindi).

Exam Covered

About Authors

Shivank Mittal

In House Faculty

  • B.C.A. Graduate from Institute of Management Studies.
  • Working as an Analyst in MNC.
  • Having 5+ years of experience in the field of Data Analysis.
  • Pursuing M.C.A and exploring new technologies in market.

Demo Videos

Course Content


  • Overview By Shivank Mittal

  • Name, Range By Shivank Mittal

  • Filters By Shivank Mittal

  • Sorting By Shivank Mittal

  • Operation & Reference By Shivank Mittal

  • Function & Formula By Shivank Mittal

  • Error Handling By Shivank Mittal

  • Conditional Formatting By Shivank Mittal

  • Data Validation By Shivank Mittal

  • Data Table By Shivank Mittal

  • Pivot Table By Shivank Mittal

  • Slicer & Timeline By Shivank Mittal

  • Charts By Shivank Mittal

  • What If Analysis By Shivank Mittal

  • Paste Special By Shivank Mittal

  • Protection By Shivank Mittal

  • Share Workbook By Shivank Mittal

  • Text To Column By Shivank Mittal

  • Flash Fill By Shivank Mittal

  • Data Tricks & Tips By Shivank Mittal

Our Packages



Offer Valid Till 31st Oct'21


Validity: 6 Months..
  • New Videos
Buy Now



Offer Valid Till 31st Oct'21


Validity: 12 Months..
  • New Videos
Buy Now



Offer Valid Till 31st Oct'21


Validity: 18 Months..
  • New Videos
Buy Now

For Pendrive / Android Courses Related Enquiries Call on 9354229384, 9354252518

Need Any Help ? Call 95-8004-8004 or

FAQ's Frequently asked questions

What will be the storage Capacity of the Memory Card??

32 GB As Per The Course Requirment

Can I Change the Mobile Phone Later?

No, You cant change the device.

Does it need Internet Connection ?

No, Internet not required For Course Content, But For New Videos You Need Internet Connection at the Time Of Download.

What do you mean by validity ?

As Videos are encrypted with time validity. Videos won’t play after given validity of time

How will I ask doubts (If any) related to any subject ?

You can email them, each faculty has given their email id in the course.

Can I extend validity later on ?

No, Validity is Pre-Fixed. It cannot get increased later on. so, chose validity accordingly

If anyone can download New Videos then, why would i pay extra ?

New videos will be authorised by our Pendrive only you have to plug our Pendrive(Dongle) in your computer/laptop. then only you will be able to play videos. After given validity, you would not be able to play New videos also. so choose validity wisely.

What do you mean by New Videos and how would I access them?

we will provide new videos for only Pendrive users on weekly basis (We start providing New videos on Daily Basis, When any big exam notification out). Go to the Download page to check New Videos.

How much time it will take to get delivered ?

Delivery totally based on the location of the user, if the user is in Delhi/NCR then only he/she get pendrive within 2-3 working days, else i will take 5-7 working days to get delivered at the address provided.

How can i get this course ?

You can purchase the course only from our website, then you have to visit pendrive courses section then you can see different available courses on that pendrive courses page then look at the course content and then you can purchase the course via "BUY NOW" Buton, payment will be done online via different modes of payment like Credit Cards, Debit Cards, Net Banking, E-wallets, UBI.

Can I Purchase A Single Subject Video material or Only One Subject From The Course?

No, the course is made for a dedicated job that contains all the subjects needed to crack that exam and course fee is calculated on the basis of all the subjects not to be sold subject-wise.

What If Android Has Lost, Damaged, Broken or Misplaced.

We Will Provide New License Key For Android User, in Case Phone Is Lost, Broken, Misplaced or Damaged.


Book Now

Offer Valid Till 31st Oct'21