Excel Essentials


16 Mar




Total Videos: 94

Duration: 5 sessions of 2 hours each

Training Fee: Rs. 5,000/-

Training mode: Online training


'The Welcome course' contains following topics. 

  1. Basic Conditional Formatting (Learning conditional formatting will help you to visualize your data in Excel reports, charts, pivot tables, etc.)
  2. Paste Special (Learning paste special helps you to copy and paste only values, formulas, formats, comments and so on).
  3. Data Validation (Learning data validation helps you to restrict the users to enter data in worksheet only as per your needs. You will also learn to create drop-down list. Use of data validation is widespread in Excel dashboards).
  4. Pivot Table Basics (Learning basics of pivot table is must to become successful in data analysis. Once you are well versed with basics, you will be able to learn more complex and advanced pivot table tools and techniques, data model and power pivot).
  5. Flash Fill (This tool is a great time saver. You will learn to parse or concatenate your data without using complex formulas, that too in a matter of seconds).

This course is available for both male and female trainees in online format. 

Male trainees can request home visit by paying Rs.1,500/- per session.


Terms and Conditions:

  1. Full advance payment needs to be made through Net Banking before beginning the training.
  2. Post payment training cancellation will attract 10% cancellation charges per person. Sessions already conducted won't be refunded.
  3. Only 2 sessions can be postponed during training. Further, Rs.200 will be charged from the person postponing the training. This is to ensure timely completion of training.
  4. Optionally, you can buy the video tutorials by paying Rs.10,000/- extra.


Comments
* The email will not be published on the website.