Working with Text e.g. upper, lower, proper, trim, concatenate, replace, left/right Functions etc.
Working with Mathematical Function e.g., Mod, Quotation, Sqrt, power, round fun. , small, large, median functions etc.
Logical Function such as IF, And , OR, Array etc.
Working with Banking Function Such as PMT, FV, PV, RATE, IRR Etc.
Working with lookup, vlookup, hlookup, Index functions.
Create & use macros
Create Macros Buttons in Upper, Lower functions.
Introduction to Chart
Create a simple Graph/Chart
Create a pivot table & Pivot Chart
Practical Assignment & Practical Notes
Hours: 15 Hours
Course Fee: 2500
2 Free Demo Classes
Free Course Material
What Student Says
I proudly say that I was a student of Matrix Computers. I did Java and Adv. Java from Bhatia sir. Foundation laid by Bhatia sir and Matrix family has been the sole reason for the growth of my skills and Expertise, thus giving my carrer a new high.
Best place to learn programming in Jaipur is Matrix Computers. The course is taught in simple and awesome way! The assignments are given after each chapter which are designed to boost our confidence and increase our interest in programming.
Poornima University, Jaipur
My best decision in the direction of my career was joining the core Java classes of Bhatia sir at Matrix Computers. I got an indepth knowledge of all topics that helped me to excel in my interviews and projects. Thank You sir.