Community Education - current class catalogs Adult activities and classes - Fall 2015 | Page 5

technology
NEW | Take Google for a Drive

Excel 103

Get started with Google Drive for free and have all your files
within reach from any smartphone, tablet, or computer. By storing
all of your files in Google Drive, videos, photos, and documents
are backed up safely so you can’t lose them. Then you can easily
invite others to view, edit, or leave comments to work efficiently
and collaboratively using Google Docs, Sheets and Presentations.
Prerequisite: You must have a gmail account and basic computer
experience to be successful in this class. Class fee: $29.

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 Excel’s pre-designed templates. They’ll help you
jump-start 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 N
 ov 12 | 6:30-8:30 pm | 1 Session
Th | Staff Dev Ctr | AL077-1F46-F1 | Favilla

w Nov 9 & Nov 23 | 6:30-8:30 pm | 2 Sessions
M | Staff Dev Ctr | AL077-1F08-F1 | Bakken

Creating WordPress Websites

Excel 104

Build an attractive, sophisticated blog or website—without having
to learn any special coding! WordPress is one of the world’s most
popular web design tools because it’s free, easy to use, and
produces professional results. Gain hands-on experience with this
powerful tool as you create your own WordPress site and blog. For
more information or to register visit our Online Instruction Center:
www.ed2go.com/anokahenn. Class fee: $99.

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

w Nov 30 & Dec 7 | 6:30-8:30 pm | 2 Sessions
M | Staff Dev Ctr | AL077-1F09-F1 | Bakken

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 Essentials 101 or strong
equivalent to topics covered. Class fee: $75; call for a $10 discount
when registering for three or more Excel classes.
w O
 ct 12 & Oct 19 | 6:30-8:30 pm | 2 Sessions
M | Staff Dev Ctr | AL077-1F06-F1 | Bakken

Excel 102
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 Microsoft Office Essentials
Part 1. Class fee: $75; call for a $10 discount when registering for
three or more Excel classes.

Microsoft Office Essentials Part 1-Word & Excel
Begin your Microsoft Office training with Word and Excel. In Word,
learn to enter, edit and manage text using font, paragraph and
line spacing settings. Get organized by using bullet and number
lists plus table features. Proof your documents with spell/grammar
check, as well as insert pictures and art features to enhance your
documents and text. In Excel, learn how to manage the Excel
environment by creating projects such as budgets, reports, a
checkbook register and address lists. Learn to edit and manage
columns/rows, change text and number formats to make your
projects look and function well. Create your own formulas, as well
as use Sum, Average, Count, Min and Max functions to create an
auto-calc environment with your projects. Prerequisite: Computer
Essentials 101 or strong equivalent. Not meeting November 3.
Class fee: $149.
w =