To view full lecture click on Enroll This Course.


Bank PO

Instructed by S P SHARMA
Validity: 120 days
Online ₹100.00 ₹300.00 67% off

Published    02-Mar-2017      Bilingual

Bank PO exams mainly covers the following topics:

  • Computer Hardware and Controls
  • Basic Computer Terminology
  • Basic Internet Knowledge and Protocol
  • Database Management System
  • Number System
  • Operating System
  • History of Computer
  • Network basics
  • Computer Abbreviation
  • Security Tool
  • Virus
  • Hacking
  • Software names and Usage
  • Computer Shortcut

Section 1: MICROSOFT EXCEL (In this section you will learn the following:
  • Basics of MS Excel
  • Functions and formulas
  • Usage of Excel in Practical
  • Random Functions
  • Random Dates
  • ExcelText
Lecture 1 Microsoft Excel: Introduction (You will begin with the definition of the MS.Excel. Basically MS. Excel is an application software and is a component of MS Office package. It is not only useful for banking but also for professional career. MS Excel has a huge demand in the market. It is now the requirement for many vacancies. So this topic need your utter attention. Further you will learn it practically. You will begin with instructions on how to open it and then move to different bars or buttons of Excel and their uses. You will further learn it Application name, default file name, Default number of menu and their respective names ans many more thimgs. You will learn the complete basics of Excel which is very helpful for a good career growth.)
Lecture 2 Microsoft Excel: Random Functions (In this video Sir has discussed the Practical of Excel wherein you will learn functions and formulas. Here in this video you will learn how OTP are basically generated, difference between Rand() and Rand between(), their syntax , generating random character and more. This is going to be a practical experience for you. You will learn much faster when actually try these functions practically. SP Sharma Sir has very well explained everything and has even discussed the types of questions asked in the exams. He has made the class very interactive .His friendly way of teaching will help you the most.He is also giving you practice questions and has even shared his email-id for your doubts.)
Lecture 3 Microsoft Excel: Random Dates (It is not just a lecture but a complete guidance. With this lecture you will master Excel. You need practice a lot and for your practice we will provide you practice sheets, Quiz with all the important questions and doubt sessions. You can ask your queries and you will 100% get your answer within 36 hours of your queries. Do not ever hesitate to raise any doubt. Particularly in this lecture you will learn about random date. You will learn to calculate days between two given dates. You learn how to work on dates. This is a step by step learning session. You're requested to watch the videos in the given sequence only to have a proper grasp of everything. This lecture will let you learn the different format of writing date, date value, commands to find the date value and age of a person if DOB is given with some funny tips to learn. As you finish dates you will different shortcut keys ans how to add text in cells and how to change the format and everything will be taught to you practically. You will get familiar with the techniques and important formulas of Excel like conditional formatting which includes sorting, filter, Pivot table, Vlookup, countif, count, sum, sumif and Address as per the requirement of syllabus.)
Lecture 4 Microsoft Excel: Text (This lecture is all about the text in MS.Excel. You will again learn some new formulas and these formulas are more than enough to finish the entire topic. MS. Excel is a very interesting topic with many formulas. Mugging up formulas is just a wastage of time as at the end you will forget and it becomes trash. The best way to learn these formulas is by making use of them as much as you can. Make a list of everything you do in your daily life, calculate your daily expense and there are lot many ways to utilize it. This lecture is the last topic of Excel but not the least to learn.)


Phone: 99********62 Email: sps********
Address: Parashar Technologies - T 82, 3rd Floor, Vardhman Plaza, Nehru Vihar, Delhi-110054 Institute:

About Us

Mr. S P SHARMA, director of Parashar Technologies & S P SHARMA CLASSES, is the ultimate option for all IT students and professionals who are keen in honing their IT skills to keep updated and handle various job profiles such as in IT companies, banks, insurance companies, investments companies etc. His way of teaching is very interactive and easy to grasp. With his 06 years of experience, he exactly feels the pulse of IT technology to keep himself abreast with the latest software’s available in the industry and their application in respective fields. His modules and teaching style includes customized text and diagrammatical presentations on each and every topic that helps the students to understand the concept better. His style of teaching is very different and he believes in concept clarity of every student along with the proper explanation. He has accumulated practical examples with the conceptual clarity to make the subject easy. He trains his students with his unique teaching skills in a way that studies become useful for them even after the classes. He keeps the class throughout interactive and gives an environment to students where they can share their doubts easily. He provides them the best help when his students require it. He has trained more than 2000 candidates across companies including Ministry of Defence, Ministry of Labour and Employment, Dish TV, Samsung, and PNB-HFL, Parashar Technologies, DAV-ITC, Alchemist. He has also 02 years Industry experience as a Software Developer in Mack Group of Companies. He has passed out B.Sc.(PCM), MCA, M.Tech. (IT).


B.Sc. (PCM), MCA, M.Tech. (IT)


06+ Years

Courses taught by S P SHARMA