Learn to format a standard applicant tracking system, compliant resume including how to set tabs correctly, insert stored text, and track changes.   Many companies use Applicant Tracking Systems (ATS) to manage resumes and applications. If the ATS can’t read or understand the information on your resume, your application might not be evaluated or considered. For…

VLOOKUP is a must-have Excel function that’s used to manipulate data. In this 90-minute webinar we’ll explore VLOOKUP and the additional options that make it such a useful tool. We’ll also look at some alternatives to VLOOKUP like INDEX/MATCH. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Once you register,…

In this 90-minute webinar we’ll explore Sheets – Google’s web-based alternative to Excel. Learn to use this powerful spreadsheet program to create spreadsheets, work with functions, add formatting, and sort/filter data. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class.   Once you register, you will receive the link to…

Learn the basics of Pivot Table construction in Excel. We’ll discuss data organization, define what a pivot table does, and create several examples of this need-to-know Excel feature. Familiarity with the Sorting and Filtering tools in Excel is recommended. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP!  Registration closes 24 hours prior to class. Once you…

Excel Focus on Functions- Work with Text and Dates: CONCATENATE, TODAY, Flash Fill and Delimited Text Text strings and dates can cause big problems in a spreadsheet if you’re not aware of how to identify and manipulate them! In this 90-minute webinar we’ll talk about basic text functions like CONCATENATE and date functions like TODAY.…

In this 90-minute webinar we’ll dive deeper into Pivot Tables exploring Pivot Charts, Slicers, Timelines, Calculated Fields and Custom Grouping. Familiarity with basic pivot tables recommended. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Once you register, you will receive the link to enter class shortly before class. Please…