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 Oct 18 | 6:30-8:30 pm | 1 Session | Fee : $ 39 M | Online | AL077-1F02-F1 | 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 Oct 5 & Oct 12 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F06-F1 | Mills
w Oct 7 & Oct 14 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F06-F2 | 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 Oct 19 & Oct 26 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F07-F1 | Mills
w Oct 21 & Oct 28 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F07-F2 | 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 Nov 11 & Nov 18 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F08-F1 | Mills
w Nov 16 & Nov 23 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F08-F2 | 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 Dec 7 & Dec 14 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 T | Online | AL077-1F09-F1 | Mills
w Dec 9 & Dec 16 | 6:30-8:30 pm | 2 Sessions | Fee : $ 75 Th | Staff Dev Ctr | AL077-1F09-F2 | Mills
How to Cut the Cable Cord
Cable or satellite television is the single most expensive utility for many households . Discover viewing options that are free or much lower in cost . We ’ ll discuss the pros and cons of cable , how to get internet without cable , how to view television channels on your computer and much more . Find out why and how thousands of people are ditching cable forever .
w Oct 21 | 7-8:30 pm | 1 Session | Fee : $ 39 Th | Staff Dev Ctr | AL077-1F52-F1 | Timm
www . discovercommunityed . com | 763-506-5766 | FALL 2021 5