TutorMe homepage
Subjects
PRICING
COURSES
Start Free Trial
Roberto R.
Teacher for 10 years
Tutor Satisfaction Guarantee
Microsoft Excel
TutorMe
Question:

Is there a way to count only elements that meet a specific criteria?

Roberto R.

Hello Lucy, of course there is and here is how to do it. Suppose you have column A titled AGE with the ages of ten people (from A2 to A11 because the title is in A1), if you want to show in cell B1 the result of counting how many ages are lower than 30 then you would use the following formula in cell B1: =COUNTIF(A2:A11,"<30") The name of the formula is COUNTIF, then specify the range to be counted (from A2 to A11) and finally separated by a coma we specify the criteria to be used using quotation marks, this also works for equal to ("=30") or higher than (">30"). Additionally, if you want to use multiple criteria like higher than 20 and lower than 30 you can use the formula: =COUNTIFS(A2:A11,">20",A2:A11,"<30") As you can see it is very similar, the name of the formula is COUNTIFS, specify the range and criteria just as the previous example followed by the range and second criteria. I hope this answers your request and if you have any additional questions please let me know.

Education
TutorMe
Question:

What is a lesson plan and how can I create one?

Roberto R.

Hi Carol, that is a great question. A lesson plan is basically a map that will guide you along the road of the class, it tells you where you will start from, the important places that must be visited along the way and how the trip should end. Since there is no official lesson plan format or template it is common for schools to create one that suits their needs, a lesson plan describes the objective of the class, the activities that will be performed and how the assessment will take place. A common mistake in lesson plans is not to consider the resources of the school and students, if they do not have a computer lab with internet access it will impossible for the teacher to follow a lesson plan regarding Google’s searches. Here is an example of a lesson plan for us to analyze...

Communication
TutorMe
Question:

Do you have any tips on creating a great presentation?

Roberto R.

Hello Kevin, that is a very interesting question. There are 3 elements that must be covered in every presentation you give no matter the size of the audience if you want them to move to action. Emotion is the first one, when your presentations is felt more than just heard and the audience relates to your information and examples they lower their affective filters and they start welcoming your message. Logic is the second one, this means that your numbers and arguments are congruent with what they already know, miracle solutions that sound too good to be true are rejected almost immediately. Ethic is the third one no matter how good the offer of your message is, if it means someone has something to lose or made less then sooner or later it will face its doom in the mind of your audience. Let me show you the necessary techniques to make your presentation be emotionally powerful, logically undeniable and ethically approved...

Send a message explaining your
needs and Roberto will reply soon.
Contact Roberto