technology
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 Jan 25 & Feb 8 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F06-W1 | Mills
w Jan 27 & Feb 3 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F06-W2 | Mills
w Apr 5 & Apr 12 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F06-S1 | Mills
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 Feb 15 & Feb 22 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F07-W1 | Mills
w Feb 17 & Feb 24 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F07-W2 | Mills
w Apr 19 & Apr 26 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F07-S1 | Mills
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
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
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 Feb 8 | 10 am-Noon | 1 Session | Fee : $ 29 T | Sandburg Edu Ctr | AL077-1F60-W1 | Holcomb
w Feb 22 | 6:30-8:30 pm | 1 Session | Fee : $ 29 T | Staff Dev Ctr | AL077-1F60-W2 | Holcomb
4 WINTER 2022 | 763-506-5766 | www . discovercommunityed . com