34 matches found
In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 2016 worksheets. Other topics will include an exploration of just a few of the hundreds of functions available in Excel. We will learn how to find a specific function, as well as how to get help while entering arguments.
InDesign is a desktop publishing program by Adobe. In this 6-hour workshop, we start with the basics, we progress to creating multi-column threaded text, formatting type and paragraph styles, working with colors, images, and finish by packaging for distribution.
This 6-hour course covers work with transitions and animations; slide masters; and practice skills using audio and video files in their presentations. Finally students will learn about more features and methods for delivery an effective presentation.
This 6-hour course introduces the basics of Adobe Lightroom. Participants will work on the organization and management of photos, learning the Lightroom environment, managing images and workflow, reviewing images, sorting and organizing images as well as managing an image catalog.
This 3-hour class introduces the query object. Topics include working in design view; creating a simple query by adding and removing fields and adding criterion. We will create multi-table queries; calculated fields and set field properties; explore a totals query, parameter query, action queries, find duplicates query, unmatched records query and basic SQL query.
In this 2-hour workshop, participants will learn the basics of using the drawing tools in Adobe Illustrator CC, including how to use the Pencil and Curvature tools, how to edit paths. Then we will look at layers, including how to create, edit, and organize content. We will also learn the basics of transforming and editing artwork in Adobe Illustrator CC.
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.
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.
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.
This 6 hour course will prepare you to use the most common basic features of Adobe Photoshop CC.
In this 2-hour workshop, participants will learn how to create and open InDesign documents, navigate the user interface, modify a document, import graphics, and manipulate basic text and text frames.