Community Education - current class catalogs Adult activities and classes - Winter 2020 | 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 24 | 6:30 - 8:30 pm | 1 Session T | Staff Dev Ctr | AL077-1F01-W1 | Mills w Apr 1 | 6:30 - 8:30 pm | 1 Session W | Staff Dev Ctr | AL077-1F05-S1 | Mills Computer File Management Excel 102 Need some help knowing where to save that picture, document or file so you can easily find it? Uncertain of how and when to create folders? 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 Apr 2 | 6:30 - 8:30 pm | 1 Session Th | Staff Dev Ctr | AL077-1F02-W1 | Mills Word 101 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: $45. 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 Feb 4 & Feb 11 | 6:30 - 8:30 pm | 2 Sessions T | Staff Dev Ctr | AL077-1F07-W1 | Mills w Apr 21 & Apr 28 | 6:30 - 8:30 pm | 2 Sessions T | Staff Dev Ctr | AL077-1F07-S1 | Mills Excel 103 w Jan 14 | 6:30 - 8:30 pm | 1 Session T | Staff Dev Ctr | AL077-1F12-W1 | Mills 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 re-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. Excel 101 w Jun 2 & Jun 4 | 6:30 - 8:30 pm | 2 Sessions T/Th | Staff Dev Ctr | AL077-1F08-S1 | Mills 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 21 & Jan 28 | 6:30 - 8:30 pm | 2 Sessions T | Staff Dev Ctr | AL077-1F06-W1 | Mills w Apr 7 & Apr 14 | 6:30 - 8:30 pm | 2 Sessions T | Staff Dev Ctr | AL077-1F06-S1 | Mills 4 WINTER 2020 | 763-506-5766 | www.discovercommunityed.com