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 Feb 1 | 6:30 - 8:30 pm | 1 Session | Fee : $ 39 M | Staff Dev Ctr | AL077-1F02-W1 | Mills
w Feb 8 | 6:30 - 8:30 pm | 1 Session | Fee : $ 39 M | Online | AL077-1F02-W2 | Mills
PowerPoint
PowerPoint is a great tool , yet many of its best features are not widely known or used . We will explore how to use this Microsoft platform to its full advantage . You will learn how to design slide and notes master , customize bullets , use SmartArt and express your creativity with slide transitions and animations .
w Mar 22 & Mar 29 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 59 M | Online | AL077-1F10-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 : Computer Basics or strong equivalent to topics covered .
w Jan 26 & Feb 2 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F06-W1 | Mills
w Jan 28 & Feb 4 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F06-W2 | Mills
w Apr 8 & Apr 15 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F06-S1 | 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 16 & Feb 23 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F07-W1 | Mills
w Feb 18 & Feb 25 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F07-W2 | Mills
w Apr 22 & Apr 29 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 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 re-designed templates in Excel . They ’ ll help you jumpstart any project quickly and professionally . Prerequisite : Excel 102 .
w Mar 2 & Mar 9 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F08-W1 | Mills
w May 13 & May 20 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F08-S1 | 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 Mar 23 & Mar 30 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F09-W1 | Mills
w May 27 & Jun 3 | 6:30 - 8:30 pm | 2 Sessions | Fee : $ 75 T | Staff Dev Ctr | AL077-1F09-S1 | Mills
4 WINTER 2021 | 763-506-5766 | www . discovercommunityed . com