Microsoft Access

Microsoft Access Introduction
2 Day Class |  8:30am-4:30pm EST
$499

Learn to create basic tables, forms, queries, and reports, to understand table relationships, data management, filtering, query, and report design, listing, grouping, and calculations.

2023
Wed-Thu: 1/4 & 5
Wed-Thu: 3/8 & 9
Tue-Wed: 4/4 & 5
Tue-Wed: 6/13 & 14
Tue-Wed: 8/8 & 9
Mon-Tue: 10/2 & 3
Wed-Thu: 11/1 & 2
Thu-Fri: 12/7 & 8

Microsoft Access Intermediate
2 Day Class |  8:30am-4:30pm EST
$499

Prerequisite: Intro to Access. Learn the principals of effective database design, create forms, form controls, parameter queries, action queries, command buttons, and switchboard forms.

2023
Wed-Thu: 1/18 & 19
Wed-Thu: 3/22 & 23
Mon-Tue: 5/1 & 2
Tue-Wed: 6/20 & 21
Thu-Fri: 8/17 & 18
Tue-Wed: 10/10 & 11
Wed-Thu: 11/15 & 16

Microsoft Access Advanced
2 Day Class |  8:30am-4:30pm EST
$499

Prerequisite: Intermediate Access. Learn to use joins, indexes, summary queries, crosstab queries, calculating controls, report controls, import, export, and link data, automate processes with macros.

2023
Thu-Fri: 2/23 & 24
Wed-Thu: 4/26 & 27
Mon-Tue: 6/26 & 27
Thu-Fri: 8/24 & 25
Thu-Fri: 10/26 & 27
Mon-Tue: 12/11 & 12

Microsoft Excel

Microsoft Excel Introduction
1 Day Class |  8:30am-4:30pm EST
$250

Learn to set up new spreadsheets, create formulas, use mathematical functions, use AutoSum and Auto-Fill, format cells for value, date, text, manage print settings, add headers and footers, and create graphs from spreadsheet data.

2023
Mon: 1/9
Wed: 2/1
Thu: 3/2
Mon: 4/3
Wed: 5/3
Fri: 6/8
Thu: 7/6
Tue: 8/1
Tue: 9/12
Wed: 10/4
Fri: 11/3
Wed: 12/6

Microsoft Excel Intermediate
1 Day Class |  8:30am-4:30pm EST
$250

Prerequisite: Intro to Excel. Topics include using Excel functions, creating custom templates, using styles, linking formulas, summarizing data, using 3-D references, using absolute references, protecting sheets, filtering, sorting, and hyperlinks.

2023
Thu: 1/12
Mon: 2/13
Fri: 3/3
Wed: 4/12
Fri: 5/5
Mon: 6/12
Wed: 7/12
Mon: 8/7
Wed: 9/13
Thu: 10/5
Mon: 11/6
Thu: 12/14

Microsoft Excel Advanced
2 Day Class |  8:30am-4:30pm EST
$499

Prerequisite: Intermediate Excel. Topics include using advanced Excel functions, advanced filters, data grouping, data analysis tools, data validation, conditional formatting, pivot tables, pivot charts, and recording macros.

2023
Mon-Tue: 1/23 & 24
Tue-Wed: 2/21 & 22
Mon-Tue: 3/20 & 21
Wed-Thu: 4/19 & 20
Tue-Wed: 6/20 & 21
Wed-Thu: 7/26 & 27
Mon-Tue: 8/14 & 15
Wed-Thu: 9/20 & 21
Mon-Tue: 10/16 & 17
Mon-Tue: 11/13 & 14
Mon-Tue: 12/11 & 12

Visualizing Data with Microsoft Excel
1 Day Class |  8:30am-4:30pm EST
$250

Prerequisite: Advanced Excel. Learn to build effective data models for successful dashboarding. Make use of pivot tables and use charts to show trends, bucket data, and display performance. Build user-controlled dashboards by using macros and slicers for interactivity.

2023
Fri: 2/17
Fri: 3/ 17
Thu: 6/15
Wed: 8/23
Thu: 11/9

Microsoft Project

Microsoft Project Essentials
2 Days | 8:30am-4:30pm EST
$499

Learn to establish project parameters, create calendars, enter and link tasks, enter and assign resources and costs, set deadlines, set baselines, track progress and report on progress.

2023
Tue-Wed: 1/10 & 11
Mon-Tue: 2/6 & 7
Mon-Tue: 3/6 & 7
Mon-Tue: 4/10 & 11
Tue-Wed: 6/6 & 7
Mon-Tue: 7/10 & 11
Wed-Thu: 8/2 & 3
Mon-Tue: 9/18 & 19
Mon-Tue: 10/2 & 3
Tue-Wed: 11/7 & 8
Mon-Tue: 12/4 & 5

Microsoft Project Advanced
2 Days | 8:30am-4:30pm EST
$499

Prerequisite: Project Essentials. Learn to manage scheduling issues, resolve conflicts, establish a shared resource pool, report on earned value, customize views, filters, reports, and fields.

2023
Tue-Wed: 2/14 & 15
Mon-Tue: 4/17 & 18
Thu-Fri: 6/22 & 23
Mon-Tue: 8/21 & 22
Tue-Wed: 10/24 & 25
Tue-Wed: 11/28 & 29

Shared Information Management: SharePoint – Teams

Microsoft SharePoint Introduction
2 Days | 8:30am-4:30pm EST
$750

Learn to administer a SharePoint site as a site owner. Topics include creating site pages, adding and configuring web parts, and creating and managing lists, libraries, and calendars. Learn to create views and enable check in, check out and versioning. Manage users and set user permissions. Learn the ways that SharePoint, Teams and Outlook are designed to work together.

2023
Thu-Fri: 2/2 & 3
Wed-Thu: 4/12 & 13
Mon-Tue: 6/26 & 27
Thu-Fri: 8/10 & 11
Wed-Thu: 10/18 & 19
Wed-Thu: 11/1 & 2

SharePoint Workflows
2 Days | 8:30am-4:30pm EST
$750

Prerequisite: Intro to SharePoint. Learn to automate processes in SharePoint using Power Automate. Understand how to use triggers, actions and conditions. Create notification, data collection and approval workflows.

This class is scheduled by request.

Email info@keepitsimple.net to be added to the waiting list.

Microsoft Teams Essentials
1 Day | 8:30am-4:30pm EST
$250

Learn to use Microsoft’s full featured communication platform complete with online meetings, document sharing, powerful chat, and convenient video calling. Explore the extremely useful apps that are integrated into Teams, such as Planner and OneNote. Learn to collaborate with your colleagues in real-time in Word, Excel, and PowerPoint. Whether you’re a Team member or a Team leader, this class will give you the skills to get up and running in no time.

2023
Fri: 1/20
Tue: 5/9
Mon: 7/3
Tue: 9/26
Mon: 11/20

Microsoft PowerPoint

Microsoft PowerPoint Introduction
1 Day Class |  8:30am-4:30pm EST
$250

Learn to create business presentations, to use views, create text slides, insert and format images, create drawings, use Smart Art, create charts from number data, use themes, transitions, and timings.

2023
Fri: 1/6
Fri: 2/10
Mon: 3/27
Mon: 6/5
Thu: 8/10
Fri: 9/15
Thu: 10/12
Wed: 12/13

Microsoft PowerPoint Advanced
1 Day Class |  8:30am-4:30pm EST
$250

Prerequisite: PowerPoint Intro. Learn to work with slide masters to create custom templates, use sound, audio, and animations, and build interactive presentations, with links and action buttons.

2023
Fri: 2/17
Fri: 4/21
Fri: 6/16
Fri: 8/11
Fri: 10/13
Fri: 11/17

Microsoft Word

Microsoft Word Introduction
1 Day Class |  8:30am-4:30pm EST
$250

Learn to use Word to create, edit and format professional-looking documents using font options, alignment, tabs, indents, lists, and proofing and page layout options.

2023
Tue: 1/17
Fri: 4/7
Wed: 7/5
Thu: 9/14
Fri: 10/6
Fri: 12/1

Microsoft Word Intermediate
1 Day Class |  8:30am-4:30pm EST
$250

Prerequisite: Word Intro. Learn to control document layout using tables, templates, building blocks, quick parts, section breaks, columns, and graphics.

2023
Fri: 1/27
Thu: 4/13
Thu: 6/8
Fri: 8/4
Fri: 10/20
Mon: 11/27

Microsoft Word Advanced
1 Day Class |  8:30am-4:30pm EST
$250

Prerequisite: Word Intermed. Learn advanced formatting techniques, document protection, change tracking, versions, macros, mail merge, tables of contents, indexes, and forms.

2023
Thu: 2/16
Fri: 4/21
Wed: 6/28
Wed: 8/16
Mon: 10/23
Thu: 12/14

Personal Information Management: Outlook – OneNote

Microsoft Outlook Essentials
1 Day | 8:30am-4:30pm EST
$250

Learn to use email, contacts, calendars, and tasks, to organize, categorize, flag, and attach Outlook items, plan meetings, create multiple calendars, and effectively use and assign tasks.

2023
Fri: 1/13
Fri: 3/10
Fri: 7/7
Fri: 9/29
Fri: 11/3

Microsoft OneNote Essentials
1 Day | 8:30am-4:30pm EST
$250

Learn to create notebooks, sections, pages, text, image, audio, and video notes, organize, share, collaborate, research and integrate with Outlook.

2023
Thu: 3/30
Fri: 6/2
Fri: 9/22
Wed: 12/13

Adobe Creative Cloud: Online Training

Adobe InDesign Introduction
2 Days | 8:30am-4:30pm EST
$499

Learn to navigate the work area, create and modify text and graphic frames, import text and graphics, use master pages, thread text, define colors and swatches, use fills, strokes, and gradients, set text wrap, and package for a service provider.

2023
Mon-Tue: 3/13 & 14
Mon-Tue: 7/17 & 18
Mon-Tue: 11/13 & 14

Adobe Photoshop Introduction
2 Days | 8:30am-4:30pm EST
$499

Learn to apply image adjustments, make photo corrections, balance light, contrast, saturation, and color, manipulate and edit layers, extract from images using selection tools, use layer effects, transparency, gradients, use type, and repair photos.

This class is scheduled by request.

Email info@keepitsimple.net to be added to the waiting list.

Adobe Acrobat Essentials
2 Days | 8:30am-4:30pm EST
$499

Convert various types of documents to PDF, modify PDF documents, add page numbers, bookmarks, links, security, advanced reviewing, and to create fill-in forms for electronic distribution.

2023
Wed-Thu: 1/25 & 26
Wed-Thu: 3/15 & 16
Mon-Tue: 7/24 & 25
Wed-Thu: 9/27 & 28
Mon-Tue: 11/20 & 21

Scheduled at Your Request

The classes listed in this section are scheduled based on demand. We require a minimum of 4 students to schedule a class. To be added to the waiting list for the class of your choice, email your request to info@keepitsimple.net or call 410.535.1545.

Adobe InDesign Advanced
2 Days | 8:30am-4:30pm EST
$499

Prerequisite: InDesign Intro. Learn advanced uses of master pages, styles, libraries, tables, data import techniques, advanced page techniques, create tables of contents, indexes, and use the InDesign book feature.

Adobe Photoshop Advanced
2 Days | 8:30am-4:30pm EST
$499

Learn to create color patterns, overlays, layer comps, clipping masks, and Smart Objects. Students will learn how to create and edit vector paths, how to apply a variety of creative effects such as warp, liquefy, and vanishing point.

Adobe Illustrator Introduction
2 Days | 8:30am-4:30pm EST
$499

Topics include using drawing tools to create objects, applying colors, strokes, and gradients, using layers, working with type and artistic text, using brushes and paint, creating type on a path, and preparing files for print and Web use.