36 Community Education www.ClovisCommunityEd.com | 559.327.2876 COMMUNITY EDUCATION PRE-EXCEL This class will give you a preview of the Excel program. Learn the screen elements, navigation, and selection techniques to create and edit your spreadsheet. Also learn basic formulas, formatting cells, and printing options to create a professional spreadsheet. T/Th 6:00-9:00pm 5/23-5/25 2 Classes CAE D5 Lynn $79 T/Th 6:00-9:00pm 6/6-6/8 2 Classes CAE D5 Lynn $79 EXCEL - LEVEL I Discover this powerful program and all of the tools you can use to make your work and life better! This class will cover the basics of creating, navigating, and changing the layout of your spreadsheets. You will learn to create basic formulas, use advanced function formulas, and much more! In this class, you will gain the knowledge to use Excel in your professional and/or personal life T/Th 6:00-9:00pm 6/13-6/22 4 Classes CAE D5 Lynn $139 EXCEL - LEVEL II Do you know how to work in Excel but would like to be able to do more complicated tasks? This class will cover more advanced skills like how to create linking formulas, copying worksheet structure, creating name ranges, templates, protecting worksheets, and locking/unlocking cells for editing. Learn how to convert your spreadsheet to a table, use filter techniques, subtotaling, and PivotTables. You will use integration techniques to link your spreadsheet into a PowerPoint presentation and Word document. T/Th 6:00-9:00pm 7/11-7/20 4 Classes CAE D5 Lynn $139 EXCEL - LEVEL III Learn how to use financial functions like PMT, FV. Use data analysis tools like Goal Seek, and Scenario Manager. Audit your spreadsheets using lookup functions, tracing functions, and conditional formatting. Use collaboration tools to track and share data made by multiple users. Share excel data with other software like Access and PowerPoint. T/Th 6:00-9:00pm 8/1-8/10 4 Classes CAE D5 Lynn $139 POWERPOINT Does your job require you to frequently make presentations? Wow your bosses with your next presentation by using PowerPoint 2016. There are tons of ways to give professional and dynamic presentations using pre-designed layouts, clipart, and themes. You will learn to create movement using slide transitions, and adding animation and sound to your slides. You will even use music, narration, and timings to create a revolving presentation. Learn how to connect and broadcast your presentation online. Take your presentations to the next level with PowerPoint! T/Th 6:00-9:00pm 5/9-5/11 2 Classes CAE D5 Lynn $79 T/Th 6:00-9:00pm 6/27-6/29 2 Classes CAE D5 Lynn $79 PHOTOSHOP This class is for the beginning Photoshop user. You will learn how to use the different tools from the toolbox. Learn how to layer composite photographs, repair imperfections, and colorize photos. Learn how to remove the red-eye from your pictures, adjust the contrast and soften your photographs. Bring a USB flash drive to save your work. M/W 6:00-9:00pm 7/31-8/9 4 Classes CAE D5 Lynn $139 The instructor was really patient with all the students. Every aspect was informational and enjoyable. - student from Ann Lynn’s Excel class.