Community Education - current class catalogs Adult activities and classes - Spring/summer 2015 | Page 5

technology Excel 101 Excel 104 Establish essential skills in 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. 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. w  pr 20 & Apr 27 | 6:30-8:30 pm | 2 Sessions A M | Staff Dev Ctr | AL077-1F06-S1 | Bakken w  ay 12 & May 19 | 6:30-8:30 pm | 2 Sessions M T | Champlin Park HS | AL077-1F06-S2 | Bakken w  1 & Jun 8 | 6:30-8:30 pm | 2 Sessions Jun M | Staff Dev Ctr | AL077-1F09-SU1 | Bakken Get Smart with Your Android Smartphone 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 vs. 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. w  ay 4 & May 11 | 6:30-8:30 pm | 2 Sessions M M | Staff Dev Ctr | AL077-1F07-S1 | Bakken 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. Not meeting May 20 and May 25. Class fee: $75; call for a $10 discount when registering for three or more Excel Classes. w  ay 18 & May 27 | 6:30-8:30 pm | 2 Sessions M M/W | Staff Dev Ctr | AL077-1F08-S1 | Bakken 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. But are you truly making the most of this technology? This handson class will show you functions you 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  ay 5 | 6:30-8:30 pm | 1 Session M T | Staff Dev Ctr | AL077-1F77-S1 | Holcomb Get Started In Game Development Whether you want to start your own indie game project or work for a large game development studio, this course will prepare you to start developing your own games. Learn the fundamentals of game development and get an overview of game genres, platforms and audiences. Gain hands-on experience in many of the game development processes and the confidence to start developing your own game. Class fee: $99. •  nline course. O • New classes start monthly. •  omplete class entirely from your home or office – any time C of the day or night. •  essons are delivered online every Wednesday and Friday L during a six-week period, with a two-week grace period at the end. w  or more information or to register visit our Online Instruction F Center: www.ed2go.com/anokahenn. www.discovercommunityed.com | 763-506-5766 | 2015 SPRING/SUMMER 5