Colorado Free University

5 Register now! Call 303-399-0093 or online: www.freeu.com Microsoft Excel Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. The Level 1 class provides all the basics for creating and editing spreadsheets and workbooks and performing simple calculations. In Level 2 learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. The Level 3 class includes topics in advanced data entry functions and capabilities as well as task automation, data analysis and worksheet collaboration. Offered in Excel 2016, Excel 2019 or multi-version-appropriate training. Level 1 Previous knowledge or experience : Understanding of the basics of Windows $174 Non-Member $159 Member Includes training materials Excel 2016 CFU LOWRY : Near 1st & Quebec 3480LE: One Sat., 9AM–4PM 3/27 (2016) 3480LF: One Thu., 9AM–4PM 4/8 (2016) 3480LI: One Tue., 9AM–4PM 5/4 (2016) 3480LM: One Sat., 9AM–4PM 6/19 (2016) 3480LO: One Thu., 9AM–4PM 7/8 (2016) ONLINE : Via Zoom 3480LHZ: One Wed. & One Thu., 6–9PM Begins 4/21 (2016) 3480LLZ: One Wed., 9AM–4PM 6/9 (2016) Excel 2019 CFU LOWRY : Near 1st & Quebec 3480LK: One Wed., 9AM–4PM 5/19 (2019) 3480LN: One Thu., 9AM–4PM 6/24 (2019) ONLINE : Via Zoom 3480LGZ: One Wed., 9AM–4PM 4/14 (2019) 3480LPZ: One Wed., 9AM–4PM 7/21 (2019) Excel 2013, 2016, 2019 or Office 365 ONLINE : Via GoToMeeting 3480LJZ: One Thu., 9AM–4PM 5/13 Level 2 Prerequisite : Excel Level 1 or equivalent knowledge $174 Non-Member $159 Member Includes training materials Excel 2016 CFU LOWRY : Near 1st & Quebec 3481WR: One Fri., 9AM–4PM 4/23 (2016) 3481WV: One Thu., 9AM–4PM 7/22 (2016) ONLINE : Via Zoom 3481WOZ: One Fri., 9AM–4PM 3/19 (2016) 3481WQZ: One Sat., 9AM–4PM 4/17 (2016) 3481WUZ: One Mon., 9AM–4PM 7/12 (2016) Excel 2019 CFU LOWRY : Near 1st & Quebec 3481WP: One Tue., 9AM–4PM 3/30 (2019) 3481WW: One Thu., 9AM–4PM 7/29 (2019) ONLINE : Via Zoom 3481WSZ: One Wed., 9AM–4PM 4/28 (2019) Excel 2013, 2016, 2019 or Office 365 ONLINE : Via GoToMeeting 3481WTZ: One Tue., 9AM–4PM 6/15 Level 3 Prerequisite : Excel Level 2 or equivalent knowledge $184 Non-Member $169 Member Includes training materials CFU LOWRY : Near 1st & Quebec 3482IU: One Thu., 9AM–4PM 4/29 (2016) 3482IV: One Fri., 9AM–4PM 7/30 (2016) Microsoft Excel PivotTable In this class students will create and analyze PivotTable data. Upon successful completion of this course, students will be able to build a PivotTable; analyze data using PivotTables; and present PivotTable data visually. Class appropriate for Excel 2007–2019 users. Mitzi Katz Prerequisite : Excel Level 2 or equivalent knowledge $174 Non-Member $159 Member Includes training materials ONLINE : Via GoToMeeting 3484CKZ: One Wed., 9AM–4PM 3/24 3484CLZ: One Wed., 9AM–4PM 6/23 Excel Dashboards for Interactive Reporting A dashboard is a single screen that displays charts, tables, and other visual data components on a related subject. Learn how to create Dashboards that will transform business data into actionable information. In this class you will: create an interactive, dynamic information source within Excel, set up a structure to allow data to flow to the dashboard, design a dashboard that is visually effective and easily modified. Class is offered in Office 2016 but will be appropriate for Office 2007-2019 users. Mitzi Katz Prerequisite : Excel Level 2 or equivalent knowledge $174 Non-Member $159 Member Includes training materials ONLINE : Via GoToMeeting 3483EXZ: One Tue., 9AM–4PM 4/20 3483EYZ: One Tue., 9AM–4PM 7/20 Microsoft Office 365 & OneNote Discover Office 365 free apps and OneDrive, Microsoft’s online cloud storage. With Microsoft’s free online apps (Word, Excel, PowerPoint, OneNote, Sway, and Flow) you can create new files, view recent files, share files, and assign privileges for viewing or editing the shared files. You will also learn about the differences between the online apps and the full desktop version programs. One half class day will be devoted to the full desktop version of OneNote. OneNote is a note-taking program within your Microsoft Office Suite, but it does so much more. OneNote uses a notebook format with pages and section tabs for collecting text, graphics, audio, and video clips. Class will also cover Windows features, versions 7 and 10. Students are welcome to use their own account if they have one or create one in class. Miti Katz Previous knowledge or experience : Understanding of the basics of Windows and the internet $174 Non-Member $159 Member Includes training materials ONLINE : Via GoToMeeting 3446XZ: One Thu., 9AM–4PM 4/1 3446YZ: One Mon., 9AM–4PM 5/17 3446AAZ: One Tue., 9AM–4PM 6/29 Microsoft Access 2016 Learn how to create a variety of data tables and forms, analyze the data, and write reports. In Level 1 examine basic database concepts, create and modify databases, and be introduced to basic concepts of performing queries and building reports. In Level 2 customize reports, join tables, modify table design and field properties, share data across applications. Level 1 Previous knowledge or experience : Understanding of the basics of Windows $174 Non-Member $159 Member Includes training materials CFU LOWRY : Near 1st & Quebec 3462XM: One Tue., 9AM–4PM 4/13 ONLINE : Via Zoom 3462XNZ: One Wed., 9AM–4PM 6/16 Level 2 Prerequisite : Microsoft Access Level 1 or equivalent knowledges $174 Non-Member $159 Member Includes training materials CFU LOWRY : Near 1st & Quebec 3463SC: One Fri., 9AM–4PM 7/23 ONLINE : Via Zoom 3463SBZ: One Mon., 9AM–4PM 4/26 Spreadsheets, Microsoft Office | CompuSkills Reminder for In-Person Classes: • Wear a mask • Bring hand-sanitizer • Keep social distance If you are ill, call in advance of class to withdraw.