Community Education - current class catalogs Adult classes and activities - Spring/Summer 2017

technology

NEW | Bulletproof Your Computer

Learn how to make your computer run faster , detect and remove viruses , and how to secure your computer from being invaded by new threats . There will be a review of parental control services as well . Clean out your computer and make it safe . Class fee : $ 35 .

Computers Made Easy

Are you new to computers ? This course is for you ! We will go over the basics : Overview of the computer , the mouse , the cursor , the keyboard , desktop and icons , recycle bin , personalizing the desktop , desktop shortcuts , the task bar and more . You will leave this class with the confidence and skills to be a computer pro ! Class fee : $ 29 .

Email and Internet Basics

Explore what the internet is and how to get the most out of your online technology . You will explore the basics of web browsers and the address bar , search engines , using hyperlinks , and saving favorites . Learn to send , receive , reply , store and manage your emails and attachments . Discuss cc , bcc and how / when to use it . Plus , store and manage contacts so you can access them from any online computer . Class fee : $ 29 .

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 : $ 29 .

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 Made Easy or strong equivalent to topics covered . Class fee : $ 75 ; call for a $ 10 discount when registering for three or more Excel classes .

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 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 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 .

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 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 .

4 SPRING / SUMMER 2017 | 763-506-5766 | www . discovercommunityed . com

Community Education - current class catalogs Adult classes and activities - Spring/Summer 2017 | Page 4

technology