Wed, Dec 19
9:00am - 12:30pm
88 classes have spots left
WorkShop Includes: Logical Test IF, AND, OR Functions SUMIFS Function INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data Date Function Table Objects
Wednesday Dec 19th, 9am - 12:30pm
AWS Technical Essentials introduces you to AWS products, services, and common solutions. It provides you with fundamentals to become more proficient in identifying AWS services so that you can make informed decisions about IT solutions based on your business requirements and get started working on AWS. Skills Gained This course teaches you how to:...
Tuesday Dec 18th, 9am - 5pm
This comprehensive Photoshop course enables students to create professional, complex graphics and edit images. Learn to manipulate photos and graphics for both print and web. Whether you’re new to Photoshop or been using it for years, you will have solid skills and be able to create, edit, and manipulate images with ease in our Adobe Photoshop class....
Monday Dec 17th, 9am - 4pm(3 sessions)
System Operations on AWS is designed to teach those in a Systems Administrator or Developer Operations (DevOps) role how to create automatable and repeatable deployments of networks and systems on the AWS platform. The course covers the specific AWS features and tools related to configuration and deployment, as well as common techniques used throughout...
Wednesday Dec 19th, 9am - 5pm(3 sessions)
Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields,and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.
Monday Dec 17th, 9am - 4pm
After an introduction to Outlook’s window components, students will read and send e-mail messages using several techniques. Then they will learn how to manage e-mail messages and attachments, configure message options, and use search folders. Students will also learn to manage contacts and use the People Pane, work with tasks, and create appointments....
Monday Dec 17th, 9am - 4pm
WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work...
Wednesday Dec 19th, 1pm - 4pm
This hands-on class is suitable for PowerPoint 2010/2013/2016 users. You will learn to create more dynamic and visually appealing presentations using the more advanced features of PowerPoint. The course covers transitions and animation, themes, slide masters, advanced formatting, using templates, collaborating with others and more. Live face-to-face...
Friday Jan 4th, 9am - 4:30pm
Students will learn how to navigate documents. Then they will enter and edit text, create and save documents, and learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof, and insert graphics.
Thursday Jan 3rd, 9am - 4pm
Illustrator CC Level 2 Advanced: This course will build upon the knowledge obtained in Level I. We will use the Appearance Panel to add fills, strokes and effects to shapes and type, then save and use a Graphic Style. We will explore different effects such as warp, 3-D and distortion. Students will draw with many different tools, pencil, blob and the...
Thursday Dec 20th, 9am - 4pm(2 sessions)
Students will gain proficiency in creating procedures that run in response to specific events, working with control structures,developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Thursday Dec 20th, 9am - 4pm
Students will work with styles, sections, and columns and will use the Navigation pane to work with outlines. They will format tables, print labels and envelopes, and work with graphics. They will also use document templates, manage document revisions, and work with Web features.
Friday Jan 4th, 9am - 4pm
Thousands of classes. No expiration. You choose the $ amount. Select a category or let the recipient pick.
Students will learn the basics of the Photoshop work area and image manipulation. You will work with color, retouch images with filters and other methods, create layered images, and use masks. Course Outline: Lesson 1: Getting started Using Adobe Bridge Organizing & Customizing the Photoshop Workspace Lesson 2: Basic Images Image Elements...
Saturday Jan 5th, 9am - 4pm
Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Course Outline Unit 1: Using multiple worksheets and workbooks Topic A: Using multiple workbooks Topic B: Linking worksheets with 3-D formulas Topic C: Linking workbooks Topic D: Managing workbooks Unit 2: Advanced formatting ...
Tuesday Dec 18th, 9am - 4pm
The focus of this class is the design of an Access database. You will learn how to create tables and basic forms, basic queries, and basic reports. We will cover planning a database, finding records, editing data, and using sorting and filters. Input masks and validation will be covered to help get correct information into your database.
Wednesday Jan 2nd, 9am - 4pm