0
Total:
Need Support

MS Excel - 20 hrs Certification Programme

Course Mode

Face to Face 3,000
Intro Video Enroll

134 Students Enrolled

Course Review

  • Description
  • Session Details
  • Other FAQs
  • Curriculum
  • Reviews
  • Enroll Now

Duration - 20 Hours

 

Start Date -  7th July 2019

 

Timing - 7th July 2019- 12:30 pm to 2:30 pm

All other classes will be from 10:30 - 12:30

 

Classes every Sunday.

 

Session 1

Mathematical Functions, Formatting Functions, and Autofill Series.

 

Session 2

Freeze Panes, Formulae Cell Referencing and Rounding Numbers/Values.

 

Session 3

Data Filter, Data Sorting, Joining Separate Data and Paste Special.

 

Session 4

Printing Techniques & Issues, Vlookup and Hlookup.

 

Session 5

Conditional Formatting, Protect-Unprotect Data cells/sheets and Removing Duplicate Entries.

 

Session 6

Pivot Table and Data Validation.

 

Session 7

Text to Columns, Trimming Data and Extract Text from a Text String.

 

Session 8

SUMIFs, Subtotal and Go to Special.

 

Session 9

Develop Charts/Graphs and Hyper linking sheets/files/tabs.

 

Session 10

Designing Macros, Goal Seek Concept for Business and Nested IFS Formulae.

 

What if I have missed?

You can join the classes in the next session, as every session is independent of another. The missed session can be covered up through our online video recordings or by attending the session at any time within a year of your enrolment.

Will I get a certificate?

Yes, on completion of all the 10 sessions.

Do I need to bring my laptop?

No, you have to attend the classes in our computer lab.

Are the classes available in Pen drive?

Not right now. It will be available soon.

  • Introduction Video
  • 00:06:00

Post Review

Course Review

0

5
80% Complete (danger)
4
80% Complete (danger)
3
80% Complete (danger)
2
80% Complete (danger)
1
80% Complete (danger)

OR

Popularity
Most Recent