Community Education - current class catalogs Adult classes and activities - Fall 2017

technology

NEW | Access 101

Take advantage of your data with the power of Microsoft Access, without writing code or becoming a database expert. You will then learn to design and create databases and tables, query those tables, and create forms and reports. Class fee: $ 75.

Excel 101

Establish essential skills in Microsoft Excel. Enter data, manage ranges, columns and rows. Change number and date settings, font colors, add borders / shading. Learn to incorporate formulas with various projects, applying the Sum, Average, Count and Min and Max functions. Prerequisite: Computers Made Easy or strong equivalent to topics covered. Class fee: $ 75; call for a $ 10 discount when registering for three or more Excel classes.

Excel 102

Graduate from simple worksheets to managing large lists of data. Learn sort commands and methods to apply dropdown filters to include or to extract specific data, plus ways to use the subtotal versus sum function to recalculate any filter applied. Introduce headers and footers plus repeating column headings for printed worksheets. Prerequisite: Excel 101 or strong equivalent to topics covered. Class fee: $ 75; call for a $ 10 discount when registering for three or more Excel classes.

Excel 103

Take formula skills to the next level. Work with absolute references and settings to link cells and workbooks together. Learn logical, date / time, text and lookup functions as well as what-if analysis. Use templates to create an amortization schedule and begin other projects with Excel’ s pre-designed templates. They’ ll help you jump-start any project quickly and professionally. Prerequisite: Excel 102. Class fee: $ 75; call for a $ 10 discount when registering for three or more Excel classes.

Excel 104

Discover how to use pivot tables to organize, summarize and calculate lists of data in just seconds! Learn to group dates, insert additional calculated fields and calculate percentage of growth using pivot tables. Using chart as well as pivot chart features, you will learn to display your data visually and professionally, including pie, bar, area, stock, pie-in-pie and many more custom chart settings. Prerequisite: Excel 103. Class fee: $ 75; call for a $ 10 discount when registering for three or more Excel classes.

PowerPoint Tips and Tricks

Creating a unique PowerPoint can make or break the effectiveness of your presentation. Discover shortcuts to design your presentation more quickly and efficiently, utilize templates and other techniques to make it stand out, and discover hidden tricks which could save your presentation in a pinch. We will explore effective animation and develop a style guide for you to use PowerPoint effectively to keep your audience engaged. Class fee: $ 39. w Oct 16 | 6:30- 8:30pm | 1 Session M | Staff Dev Ctr | AL077-1F14-F1 | Mills

Word Tips and Tricks

Most people use only a fraction of the features in Microsoft Word. Improve your productivity with useful tips on some of the most overlooked features. Acquire techniques to customize and format your document and utilize shortcuts to increase your efficiency. Find out what you didn’ t know you didn’ t know. Class fee: $ 39. w Oct 30 | 6:30- 8:30 pm | 1 Session M | Staff Dev Ctr | AL077-1F30-F1 | Mills

NEW | Quickbooks Online

Learn to use features of this online software that will allow you to work from anywhere. Send invoices, manage bank accounts and capture receipts. Many features are accessible from a variety of devices. Manage your business from anywhere you have secure internet. Prerequisite: Familiarity with Windows and browsing the internet. Class fee: $ 89. w Sep 26- Oct 10 | 6:30- 9 pm | 3 Sessions T | Staff Dev Ctr | AL077-1F62-F1 | Holcomb

4 FALL 2017 | 763-506-5766 | www. discovercommunityed. com

Community Education - current class catalogs Adult classes and activities - Fall 2017 | Page 4

technology