- This course is intended for students who are experienced Excel users who want to work with some more advanced Excel features. Material covered includes: performing advanced data analysis (such as LookUp functions); working with multiple worksheets and workbooks; sharing and protecting workbooks; applying data validation and formula auditing; and forecasting data. You’ll also learn to collaborate with colleagues; automate complex or repetitive tasks; and use conditional logic to put the full power of Excel at your fingertips. Taught with Excel for Windows, but generalizable to the Mac version. Cost includes workbook; please register a week in advance. If you want to copy the class files that go with the workbook, please bring a flash drive to class. This class is three sessions: Tuesday, Thursday, Tuesday.