Maharishi Nagar, Noida, India - 201304
29
Details verified of ONLINE COMPUTER CLASS✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
All Computer Courses are available
Online Computer Class Only
Maharishi Nagar, Noida, India - 201304
Landmark: Head Office-: Fin Computer Class Sector 107 Noida UP
Phone Verified
Email Verified
Report this Profile
Is this listing inaccurate or duplicate? Any other problem?
Please tell us about the problem and we will fix it.
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Teaches following Excel features
Basic Excel, Excel Macro Training
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Teaches
Tally ERP 9
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Information Technology Engineering Diploma Subject
Object Oriented Programming, Visual Basic
Engineering Diploma Branch
Information Technology Engineering Diploma, Computer Engineering Diploma
Computer Engineering Diploma Subject
Computer Network, Computer Hardware and Maintenace, Basics of C Programming
Type of class
Crash Course, Regular Classes
Class strength catered to
One on one/ Private Tutions
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Proficiency level taught
Advanced C++, Basic C++
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Board
State, NIOS, CBSE, International Baccalaureate, ICSE
Subjects taught
Computers, Computer Science
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
BCA Subject
Programming in C++ , Computer Oriented Numerical Techniques , English, Visual Programing, Systems Analysis and Design , Internet Concepts and Web Design , Database Management Systems , Network Programming and Administration , IT, C Language Programming, E-Commerce , Object Oriented Technologies, Mathematics, Computer Networks , Operating System Concepts and Networking Management , Cryptography and Network Security, Data Communication and Networks, Problem Solving and Programming , Computer Architecture, Web Programming, Communication Skills , Business Communication , Software Engineering , Java Programming, Computer Basics and PC Software
Type of class
Crash Course, Regular Classes
Class strength catered to
One on one/ Private Tutions, Group Classes
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Type of Computer course taken
Training in Computer tools usage, Software Programming, Training in Software application usage, Basics of Computer usage
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
5 out of 5 5 reviews
Riya Sultana
BCA Tuition
"Thanks to UrbanPro for recommending me his contact. He is very polite and hardworking. He tries his best to make the students more engaged towards studies and motivates them a lot. He also provide assignments after every class.The things that he taught me helped me a great deal in this class as well as in my lecture. Because of his explanations I am doing very well in my classes. Because of the help and attention that he provided me with, I understand and enjoy all classes. "
Vijay
Microsoft Excel Training
"A teacher is good. Gives very much time to the student . The teacher had good knowledge on the subject. Gives extra to the student as well. "
Yogesh Deshpande
Computer Course
"Good technology skills along with ability to make it simple or easier to learn through Practice way. My son is enjoying learning computer. "
Suriyamoorthi
MS Outlook
"Good. Our teachers clear all doubts and teaching methodology is excellent. He coaches by giving everyday homework and motivates to learn the subject well. "
Reply by YATENDRA
Thankyou Sir
1. What Excel features do you teach?
Basic Excel and Excel Macro Training
2. Which classes do you teach?
We teach Adobe Photoshop Training, BCA Tuition, C Language, C Sharp, C++ Language, Class I-V Tuition, Computer, DTP (Desktop Publishing), Engineering Diploma Tuition and HTML Classes
3. Do you provide a demo class?
Yes, We provide a free demo class.
4. Where are you located?
We are located in Maharishi Nagar, Noida.
Answered on 11/05/2020 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Excel Dashboard
You Can Use Dateif Formula
For Example-:
Date of Birth will in I2 Cell and Date of current date will in L2 Cell
=DATEDIF(I2,L2,"y" )& " " &"Year" & " " & DATEDIF(I2,L2,"ym")&" "& "Month" & DATEDIF(I2,L2,"md")& " " & "Day"
in Steps
First Try for Year that will
=datedif(Date of Birth Cell Address, Current Date Cell Address, "Y")
than Try for Month
=datedif(Date of Birth Cell Address, Current Date Cell Address, "M")
Than Try for Day
=datedif(Date of Birth Cell Address, Current Date Cell Address," D")
Now Marge all three formulas by using And (&) Operator
Example-:
=datedif(Date of Birth Cell Address, Current Date Cell Address, "Y") & datedif(Date of Birth Cell Address, Current Date Cell Address, "M") & =datedif(Date of Birth Cell Address, Current Date Cell Address," D")
Now do some extra work to make output meaning full
Like
use of Y before M in Month formula "YM" for getting Month
same for D like "MD" for getting Days
Now it will give a perfect output.
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Teaches following Excel features
Basic Excel, Excel Macro Training
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Teaches
Tally ERP 9
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Information Technology Engineering Diploma Subject
Object Oriented Programming, Visual Basic
Engineering Diploma Branch
Information Technology Engineering Diploma, Computer Engineering Diploma
Computer Engineering Diploma Subject
Computer Network, Computer Hardware and Maintenace, Basics of C Programming
Type of class
Crash Course, Regular Classes
Class strength catered to
One on one/ Private Tutions
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Proficiency level taught
Advanced C++, Basic C++
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Board
State, NIOS, CBSE, International Baccalaureate, ICSE
Subjects taught
Computers, Computer Science
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
BCA Subject
Programming in C++ , Computer Oriented Numerical Techniques , English, Visual Programing, Systems Analysis and Design , Internet Concepts and Web Design , Database Management Systems , Network Programming and Administration , IT, C Language Programming, E-Commerce , Object Oriented Technologies, Mathematics, Computer Networks , Operating System Concepts and Networking Management , Cryptography and Network Security, Data Communication and Networks, Problem Solving and Programming , Computer Architecture, Web Programming, Communication Skills , Business Communication , Software Engineering , Java Programming, Computer Basics and PC Software
Type of class
Crash Course, Regular Classes
Class strength catered to
One on one/ Private Tutions, Group Classes
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Type of Computer course taken
Training in Computer tools usage, Software Programming, Training in Software application usage, Basics of Computer usage
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Class Location
Online (video chat via skype, google hangout etc)
At the Institute
Answered on 11/05/2020 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Excel Dashboard
You Can Use Dateif Formula
For Example-:
Date of Birth will in I2 Cell and Date of current date will in L2 Cell
=DATEDIF(I2,L2,"y" )& " " &"Year" & " " & DATEDIF(I2,L2,"ym")&" "& "Month" & DATEDIF(I2,L2,"md")& " " & "Day"
in Steps
First Try for Year that will
=datedif(Date of Birth Cell Address, Current Date Cell Address, "Y")
than Try for Month
=datedif(Date of Birth Cell Address, Current Date Cell Address, "M")
Than Try for Day
=datedif(Date of Birth Cell Address, Current Date Cell Address," D")
Now Marge all three formulas by using And (&) Operator
Example-:
=datedif(Date of Birth Cell Address, Current Date Cell Address, "Y") & datedif(Date of Birth Cell Address, Current Date Cell Address, "M") & =datedif(Date of Birth Cell Address, Current Date Cell Address," D")
Now do some extra work to make output meaning full
Like
use of Y before M in Month formula "YM" for getting Month
same for D like "MD" for getting Days
Now it will give a perfect output.
Share this Profile
Also have a look at
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.