Monday, November 11, 2019
Tuesday, November 12, 2019
In this 6-hour course, you will import and export data into Excel 2016, work with conditional formatting, and learn about macros. Additional topics will include summarizing data using subtotals and data validation; and analyzing data using Goal Seek and Solver along with what if scenarios. Prerequisite: Completion of Excel 2016 Level 1 or equivalent knowledge
Attendees will become familiar with the Outlook 2016 calendar interface (including the enhanced Ribbon tools). You will also learn how to schedule and edit an appointment; work with calendar labels and tasks displayed on the Calendar. We will schedule meetings with the Scheduling Assistant and practice scheduling a conference room.
Wednesday, November 13, 2019
In this 3-hour class learn how to create and work with Access reports. Create a basic report and explore layout and design view. Use the report wizard to create reports. In design view add controls and set properties for those controls; learn about calculated controls, apply sort & group feature to report data, finish up with graphics (themes and conditional formatting).
Lightroom Level 2 is the second course in Lightroom, utilizing the Develop module, to concentrate on making image corrections in a non-destructive manner. Topics include: Develop module basics, Image adjustment basics, working with color, fixing common image problems like straightening and cropping, as well as more advanced topics like creating snapshots and panoramas.
Wish you had a smarter, more efficient way to arrange your Outlook 2016 email and more? In this two-hour workshop, you will learn how to use the conversation view; how to insert a screenshot into a message; sorting messages; advanced searching techniques, including filters; working with folders; using flags, color categories, and rules.
Thursday, November 14, 2019
In this 3 hour course, participants will learn how to create and edit OneNote notebooks, search and export notes. We will enter data into OneNote from a variety of sources, from existing documents to webpages to images.
Friday, November 15, 2019
In this 2-hour workshop participants will learn how to use Photoshop to do basic photo correction, use selection tools, manipulate, save, and store images. No prior knowledge of Photoshop is required.