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