technology
Computer File Management
Need 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 .
w Apr 4 | 6:30-8:30 pm | 1 Session | Fee : $ 39 M | Staff Dev Ctr | AL077-1F02-S1 | 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 : Computer Basics or strong equivalent to topics covered .
w Apr 5 & Apr 12 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F06-S1 | Mills 1
w Apr 7 & Apr 14 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F06-S2 | Mills
Excel 102
Graduate from simple worksheets to managing large lists of data . Learn sort commands and methods to apply drop-down 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 .
w Apr 19 & Apr 26 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F07-S1 | Mills 1
w Apr 21 & Apr 28 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F07-S2 | 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 re-designed templates in Excel . They ’ ll help you jumpstart any project quickly and professionally . Prerequisite : Excel 102 .
w May 10 & May 17 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F08-S1 | Mills 1
w May 12 & May 19 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F08-S2 | Mills
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 .
w May 31 & Jun 7 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F09-S1 | Mills 1
w Jun 2 & Jun 9 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F09-SU1 | Mills
Get Smart with Your Android Smartphone
Phones are no longer just phones . In fact , making a phone call is now only the sixth most common use for a mobile phone . Mobile devices have become our schedule keepers , navigation devices , cameras , entertainment centers , alarm clocks and money managers . This hands-on class will show you functions you can use on a daily basis and offer you the tools to learn more advanced tricks at your own pace . Bring your charged Android smartphone .
w April 26 | 10 am-12 pm | 1 Session | Fee : $ 29 T | Sandburg Edu Ctr | AL077-1F60-S1 | Holcomb
w Jun 7 | 6:30-8:30 pm | 1 Session | Fee : $ 29 T | Staff Dev Ctr | AL077-1F60-SU1 | Holcomb ƒ
Don ’ t miss emails from us ! Course reminders and links to online classes are sent from the address ced _ adulted @ ahschools . us . Please add us to your email contact list so you don ’ t miss important information .
4 SPRING / SUMMER 2022 | 763-506-5766 | www . discovercommunityed . com