MS Excel Conditional Tools: IF functions, Data Validation, (VIRTUAL class)

Add power and complexity to your Excel spreadsheets! In this 90-minute webinar we'll talk about about one of the most powerful functions in Excel - the IF function. We'll also talk about other logical functions like AND/OR as well as functions like SUMIF and AVERAGEIF. Many tools in Excel are condition-based. So what is a condition??? We'll look at several areas of Excel that serve different purposes, but use the same underlying concept of condition. Understanding how conditions are used in Excel not only extends your knowledge of different tools in Excel, but adds to your overall understanding of Excel.

Registration ends by 5pm the day prior to the Webinar. Once you register on Eventbrite, you will receive an email from the instructor through GoToWebinar with the link to join this class.

• If you need to cancel, please cancel 48 hours prior so someone else on the waiting list can use your seat.

• PLEASE do not register and then no show.

For an optimal webinar experience when registering and attending these virtual workshop, the following is recommended:

• USE the following email accounts-Gmail (google.com) or Outlook (outlook.com)
• Register and attend the workshop with either browser-Google Chrome or Microsoft Edge
• If you don’t receive the emails in your inbox, please check your JUNK/SPAM Folder
• Sessions are CST
• Sign in 10 minutes prior to the webinar

You’ll receive the following emails. Last two have Join Webinar/LINK to attend

1. Eventbrite: Email Confirmation from Eventbrite which is ONLY your E-Ticket Summary
2. GoToWebinar: Email Registration Confirmation of Computer Webinar from instructor to Click JOIN WEBINAR (LINK)
3. GoToWebinar: Email Reminder ONE DAY PRIOR to Computer Webinar from instructor to Click JOIN WEBINAR (LINK)

Note: There’s NO access code, you’ll receive JOIN WEBINAR/LINK in your 2nd& 3rd emails.

Information/Cancel workshop-send email to webinar.organizer6@gmail.com

You can also send a note via Eventbrite website in the ticket order email section.

The American Job Center is committed to providing all customers with quality, professional services as well as a safe and comfortable learning environment. The use of our resources implies acceptance of our Customer Code of Conduct, which is based on the principle of respect for all customers and staff. READ: https://www.northcookjobcenter.com/wp-content/uploads/2020/08/Customer-Code-of-Conduct-handout.pdf

QUESTIONS? EMAIL: contact@bcsillinois.org

Subject to change without notice.