Community Education - current class catalogs Adult activities and classes - Fall 2019 | Página 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 Oct 10 | 6:30 - 8:30 pm | 1 Session
Th | Staff Dev Ctr | AL077-1F01-F1 | Mills
Computer File Management
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.
w Oct 24 | 6:30 - 8:30 pm | 1 Session
Th | Staff Dev Ctr | AL077-1F33-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: Computers Basics or strong
equivalent to topics covered. Class fee: $75; call for a $10
discount when registering for three or more Excel classes.
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. Class fee: $75; call for a
$10 discount when registering for three or more Excel classes.
w Nov 12 & Nov 26 | 6:30 - 8:30 pm | 2 Sessions
T | Staff Dev Ctr | AL077-1F08-F1 | Mills
Excel 104
w Sep 16 & Sep 23 | 6:30 - 8:30 pm | 2 Sessions
T | Staff Dev Ctr | AL077-1F06-F1 | 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 Dec 3 & Dec 10 | 6:30 - 8:30 pm | 2 Sessions
T | Staff Dev Ctr | AL077-1F09-F1 | 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 Oct 15 | 6:30 - 8:30 pm | 1 Session
T | Staff Dev Ctr | AL077-1F05-F1 | Mills
4
w Oct 22 & Oct 29 | 6:30 - 8:30 pm | 2 Sessions
T | Staff Dev Ctr | AL077-1F07-F1 | Mills
Quickbooks for Desktop Pro 2019
QuickBooks can make your bookkeeping both manageable
and efficient. In this introductory class, you will learn some of
the great features of QuickBooks 2019. Get started on this
easy-to-use, time-saving accounting software pro. Prerequisite:
Familiarity with Windows. Class fee: $89.
w Oct 15 - Oct 29 | 6:30 - 9 pm | 3 Sessions
T | Staff Dev Ctr | AL077-1F61-F1 | Holcomb
FALL 2019 | 763-506-5766 | www.discovercommunityed.com