SB Academy: Advanced Excel
When: June 7, 2022 | 9:00 am - 12:00 pm
Where:
Technology Resource Center
1165 Franklin Street
#100
South Bend, IN 46601 United States
Contact
Francie Fink
southbendtrc@gmail.com
219.465.8186
Join us! This course is for individuals who have completed Intermediate Excel and/or are ready to learn nested formulas, data cleaning tools, etc.
RSVP here for SB Academy’s Advanced Excel Course on June 7th, from 9:00 AM to 12:00 PM:
https://www.eventbrite.com/e/sb-academy-advanced-excel-tickets-321536473247
Located at the Technology Resource Center
1165 Franklin St. #100,
South Bend IN 46601
June's SB Academy Learning objectives:
- Data cleaning using tools like text to columns, remove duplicates, find + replace
- Set up data validation
- Use advanced formulas such as LEFT/RIGHT/MID, VLOOKUP, INDEX
- Use nested formulas and formulas with multiple AND/OR criterion
- VBA and macros for simple, repetitive tasks
Original source can be found here.
Alerts Sign-up