Excel 8: If Statements, And/Or, & Countifs/Sumifs (Intermediate Level)
Hands-on Training from Experts
Live Online
If Statements, And/Or, & Countifs/Sumifs
This course includes
- 1.25 hours of live, project-based training from experts
- Software Access
- Retake for free within 1 year
- Access to class recordings (30 days)
- Verified digital certificate of completion
- Small class sizes
This class is in the intermediate tier of our twelve-part mini Excel class series. Fundamental Excel experience is required to attend.
Learn intermediate Microsoft Excel skills in this one hour and 15-minute session:
- If Statements
- If Error
- And/Or
- Countifs/Sumifs
This course has a prerequisite
Students must have Excel proficiency equivalent to Excel 1, Excel 2, Excel 3, and Excel 4 or Excel for Business Fundamentals, including basic functions and formulas, printing, formatting, basic charts, and tables.
Course Reviews
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Learn the Skills Guarantee™
Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.
Hands-on training in small groups
Work on projects proven to boost retention
Time-tested curriculum and supporting materials
Refined over many cohorts for an optimal learning experience
Excellent classes and excellent venue! It has just the right level of personal attention and class participation. I would highly recommend NYIM and look forward to taking future classes there. – Hazel S.
Learn from industry experts with teaching experience
Experienced educators who are driven to help you succeed
Retake the course for free within one year
Refresh the materials and gain additional practice
Interactive Training
Attend this course Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
Unlike other providers, these are not mass open-enrollment classes. At NYIM Training, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.
Live Online Remote, from anywhere
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
- Live, interactive class
- Experienced instructor teaching over Zoom
- Remote setup assistance provided
Earn a Certificate of Completion
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
Free Retake & Class Recordings
Missed a session or need a refresher? We have you covered!
Free Retake
We offer a single free retake of the class within a year.
Class Recordings
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
Frequently Asked Questions
Is this course open to beginners?
Students must have Excel proficiency equivalent to Excel 1, Excel 2, Excel 3, and Excel 4 or Excel for Business Fundamentals, including basic functions and formulas, printing, formatting, basic charts, and tables.
Do you offer payment plans or student financing for this course?
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
Can I take this course online (remote learning)?
Sorry, but this training is not available online.
What happens if I need to miss a session?
You have some options:
- You can watch a recording of the session. We will provide any course materials.
- If you can’t come into the classroom but can still attend remotely, we will provide you with the Zoom login information.
- You can use your free retake to make up any missed class time.
What’s included with my tuition?
- A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement
- Expert instructors who are industry professionals and experienced educators that are driven to help you succeed
- Access to industry-standard software during your training
- Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience
- A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice
- 30-day access to class recordings to review material at your own pace
- A certificate of completion to verify your accomplishment
Are there any additional fees or expenses?
There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.
Do you offer any discounts for this course?
We don’t currently offer discounts as we do our best to affordably prices our courses.
