Community Education - current class catalogs Adult activities and classes - spring/summer 2020 | Page 4

technology
Computer Basics Excel 102
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. 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 Mar 24 | 6:30 - 8:30 pm | 1 Session
T | Staff Dev Ctr | AL077-1F01-W1 | Mills
Computer File Management
w Apr 21 & Apr 28 | 6:30 - 8:30 pm | 2 Sessions
T | Staff Dev Ctr | AL077-1F07-S1 | Mills
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. Excel 103
w Apr 2 | 6:30 - 8:30 pm | 1 Session
Th | Staff Dev Ctr | AL077-1F02-W1 | Mills w Jun 2 & Jun 4 | 6:30 - 8:30 pm | 2 Sessions
T/Th | Staff Dev Ctr | AL077-1F08-S1 | Mills
Excel 101 Excel 104
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 Basic or strong
equivalent to topics covered. Class fee: $75; call for a $10
discount when registering for three or more Excel classes.
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.
w Apr 7 & Apr 14 | 6:30 -8:30 pm | 2 Sessions
T | Staff Dev Ctr | AL077-1F06-S1 | Mills 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. Class
fee: $75; call for a $10 discount when registering for three or
more Excel classes.
Excel 101 Refresher w Jun 9 & Jun 11 | 6:30 - 8:30pm | 2 Sessions
T/Th | Staff Dev Ctr | AL077-1F09-S1 | Mills
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 Apr 1 | 6:30 - 8:30 pm | 1 Session
W | Staff Dev Ctr | AL077-1F05-S1 | Mills
4
SPRING/SUMMER 2020 | 763-506-5766 | www.discovercommunityed.com