Community Education - current class catalogs Adult classes and activities - Winter 2019 | Page 4

technology Computer Basics Excel 101 Refresher Discover the essentials of working with computers. Learn how to work with screens and menus, create your own files, store them and delete them when you don’t need them anymore. Jump on the internet and visit websites. This is a step-by-step, fun class to get you started on computers. No previous experience necessary. Class fee: $39 Have you taken an Excel 101 class and feel like you need a little more help before moving on to the next level? Or maybe you have picked up some basic Excel skills on your own and want to gain a little more confidence in your abilities. Expand your knowledge and learn how to work smarter with this essential program. Class fee: $45. w Mar 5 | 6:30 - 8:30 pm | 1 Session T | Staff Dev Ctr | AL077-1F01-W1 | Mills w Jan 22 | 6:30 - 8:30 pm | 1 Session Th | Staff Dev Ctr | AL077-1F05-W1 | Mills Computer File Management Need some help knowing where to save that picture, document or file so you can easily find it? Feel like your computer files are a mess or you never really understood how to keep things organized in the first place? Gain an understanding of basic file management so you never again have to wonder where your saved file, document or photo went. Learn how to create folders; move, delete, sort and find files; create shortcuts; discuss file naming; and back-up files. Class fee: $39. w Mar 19 | 6:30 - 8:30 pm | 1 Session T | Staff Dev Ctr | AL077-1F33-W1 | Mills 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 Basics or strong equivalent to topics covered. Class fee: $75; call for a $10 discount when registering for three or more Excel classes. w Jan 17 & Jan 24 | 6:30 - 8:30 pm | 2 Sessions Th | Staff Dev Ctr | AL077-1F06-W1 | Mills w Apr 23 & Apr 25 | 6:30 - 8:30 pm | 2 Sessions T/Th | Staff Dev Ctr | AL077-1F06-S1 | Mills w Apr 15 | 6:30 - 8:30 pm | 1 Session M | Staff Dev Ctr | AL077-1F05-S1 | Mills 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. w Jan 31 & Feb 7 | 6:30 - 8:30 pm | 2 Sessions Th | Staff Dev Ctr | AL077-1F07-W1 | Mills w Apr 30 & May 2 | 6:30 - 8:30 pm | 2 Session T/Th | Staff Dev Ctr | AL077-1F07-S1 | Mills 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 pre-designed templates in Excel. They’ll help you jumpstart any project quickly and professionally. Prerequisite: Excel 102. Class fee: $75; call for a $10 discount when registering for three or more Excel classes. w May 9 & May 16 | 6:30 - 8:30 pm | 2 Sessions Th | Staff Dev Ctr | AL077-1F08-S1 | Mills 4 WINTER 2019 | 763-506-5766 | www.discovercommunityed.com