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

technology
Excel 102

Get Smart with Your Android Smartphone

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.

Phones are no longer just phones. In fact, making a phone call is
now only the sixth most common use for a mobile phone. Mobile
devices have become our schedule keepers, navigation devices,
cameras, entertainment centers, alarm clocks and money managers.
Are you truly making the most of this technology? This hands-on
class will show you functions to use on a daily basis and offer you
the tools to learn more advanced tricks at your own pace. Bring
your Android smartphone. Class fee: $25 one; $39 two.

w Apr 12 & Apr 19 | 6:30-8:30 pm | 2 Sessions
T | Staff Dev Ctr | AL077-1F07-S1 | Bakken

w Mar 8 | 6:30-8:30 pm | 1 Session
T | Staff Dev Ctr | AL077-1F68-W1 | Holcomb

Excel 103

iPad/iPhone 101-How Does This Thing REALLY Work?

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.

An iPad or iPhone is an amazingly fun and helpful device, once
you know what you’re doing! Discover how to change the standard
settings to personalize your device. Learn typing text, editing,
selecting and cut/copy/paste. Take pictures and video, practice
downloading free apps and books from the Internet, and arrange
your app icons in a way that works for you. Set reminders, write
notes, insert contacts and use the calendar to stay organized. Bring
your charged iPad or iPhone, Apple ID and password and find out
how your iPad or iPhone can really work for you! No prerequisite.
Class fee: $75.

w Apr 26 & Apr 28 | 6:30-8:30 pm | 2 Sessions
T/Th | Staff Dev Ctr | AL077-1F08-S1 | Bakken

w Jan 25 & Feb 1 | 6:30-8:30 pm | 2 Sessions
M | Staff Dev Ctr | AL077-1F21-W1 | Bakken

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 ca