SummerCEWDschedule

20 / 68

Summer 2016 • • 301.846.2400 18
Introduction to Microsoft Outlook 2013
Want to learn Microsoft Outlook 2013 quickly? In this course, you’ll get
up and running with the most important aspects of the program, starting
with mastering the Windows 8 style look and feel. From there, you’ll
quickly learn how to manage your email, calendar, and contacts, and
how to streamline and automate your work with keyboard shortcuts,
rules, Search Folders, and Quick Steps. The goal of this course is to teach
you what you really need to know to be productive with Outlook 2013.
Instead, you’ll focus on the important things like sending, receiving, and
managing your mail, and using tools such as the calendar, tasks, and
to-dos so you can manage your schedule and get your work done. You’ll
also learn about the redesigned Contacts section of Outlook (now called
People). and how Outlook can connect to your social networks. The
course also shares tips about how to get the most from Outlook. Whether
you’re new to Outlook or you’ve been using it for years, you’re sure to
learn something useful in every lesson.
ONL164 | 6 weeks | $109 fee
INSTRUCTOR: CE Instructor
7961 Online 4/8-6/10
5283 Online 7/1–8/12
Introduction to Microsoft Excel 2010
Do you work with numbers? Then you need to master Microsoft Excel
2010 - and this is the place to do it. Even ‘’non-techie’’ beginners will
find it easy to learn Excel in this fun, step-by-step online course. These
lessons will teach you dozens of shortcuts and tricks for setting up fully
formatted worksheets quickly and efficiently. You’ll also learn the secrets
behind writing powerful mathematical formulas and discover how to
use the function wizard to quickly and automatically calculate statistics,
loan payments, future value, and more. In addition, you’ll get tips on
sorting and analyzing data, designing custom charts and graphs, creating
three-dimensional workbooks, building links between files, endowing
your worksheets with decision-making capabilities, and automating
frequently-repeated tasks with macros and buttons. This is not a tutorial,
but an in-depth class where you’ll get training, help, and personal
support from an experienced instructor as you’re learning Excel basics
step-by-step. By the time you’re done, you’ll be using this vital Office 2010
tool like a pro.
ONL172 | 6 weeks | $109 fee
INSTRUCTOR: CE Instructor
7959 Online 4/8-6/10
5284 Online 7/1–8/12
Intermediate Microsoft Excel 2010
Take your Excel skills to the next level! Master charting, PivotTables,
Slicers, Sparklines, and other advanced features of Microsoft Excel
2010, and discover how this powerful MS Office program can boost
your productivity. In these hands-on lessons, you’ll learn how to create
informative, eye-catching charts and harness the power of Excel’s data
analysis and filtering tools. In addition, you’ll find out how easy it is to
create macros that let you manipulate data with the push of a button.
You’ll also discover how to use Goal Seek and Solver and apply them to
real-world problems. And you’ll set yourself apart from the casual Excel
user by adding VLOOKUP, INDEX & MATCH, and Excel’s other time-saving
functions to your repertoire. So get ready for six fun, action-packed weeks
that will make you an Excel expert!
ONL173 | 6 weeks | $109 fee
INSTRUCTOR: CE Instructor
7958 Online 4/8-6/10
5285 Online 7/1–8/12
Advanced Microsoft Excel 2010
Any proficient Microsoft Excel user will agree that this program is a very
powerful analytical tool. Wouldn’t it be great to learn how to effectively
use all the advanced Excel features? In this practical and information-
packed course, you’ll see how to maximize this program’s functions and
capabilities. Most organizations rely heavily on Excel to consolidate,
analyze, and report financial information. Your company is probably no
exception. By learning these advanced techniques, you can become
more valuable to your organization. You’ll see how to work with the
additional analytical tools provided by Excel add-ins and become skilled
in using validation to protect the integrity of your worksheets from
less experienced users. Impress your coworkers by learning how to add
functional and eye-catching custom controls to any worksheet and how
to use scenarios and data tables to quickly perform what-if data analyses.
You’ll discover advanced techniques for PivotTables, such as creating
calculated fields and calculated items. Become adept at consolidating
and importing external data, and master the art of conditional formatting
to highlight duplicate entries and other common worksheet problems.
Learn how Excel 2010 table tools take the complexity out of table
creation and management. As you become proficient at nesting functions
within other functions, you’ll be able to accomplish just about anything
Microsoft Excel has to offer!
ONL174 | 6 weeks | $109 fee
INSTRUCTOR: CE Instructor
7981 Online 4/8-6/10
5286 Online 7/1–8/12
COMPUTER &TECHNOLOGY
Note: ONL classes start the Wednesday of the second full week of each
month. During the registration process you will select the month to begin the
class. Students will have six (6) weeks from the class start date to complete
the class.