Fri, Mar 19, 9:00am - 4:00pm Mountain Time
Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. In Level 2 learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Students must have MS Office Excel software installed on their computer to participate in class.
Overview: Learn how to create advanced formulas and organize your data into tables. Discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons.
Course Objectives: In this course, you will gain an understanding of the more advanced functionality in Excel 2016. You will:
Target Student: This course is designed for individuals who already have foundational knowledge and skills in Excel 2016 and are ready to advance their data analysis skills and abilities through the application of advanced Excel 2016 functionality, such as advanced formula creation, tables, charts, PivotTables and PivotCharts.
Prerequisite: Excel Level 1 or equivalent knowledge
Lesson 1: Working with Functions
Lesson 2: Working with Lists
Lesson 3: Analyzing Data
Lesson 4: Visualizing Data with Charts
This course will be offered via Zoom. Register now and then the day before class the instructor will send you the link to attend. Look for an email with "CFU Zoom class" in the subject line. A good internet connection and a computer or device with a camera and mic are needed.
You should download Zoom in advance of class. Look for an email from your instructor with the subject line CFU Zoom class for the link. Be ready to log on and join the meeting 5-10 minutes prior to the class start time so you will be ready when class begins. If you have trouble using the link, just go to Zoom.us, click "Join a Meeting" and enter the meeting ID provided in the instructor's email.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
Still have questions? Ask the community.
Colorado Free University is a life long learning center offering a wide array of skill-based and enrichment courses. More of a learning network than a traditional school, CFU draws its teachers from the community and all teachers are independent contractors. Classes are designed for busy adults who...
This school has been carefully vetted by CourseHorse and is a verified DEN educator.
Know someone who would like this class but not sure of their schedule? (We recommend this!)
Know their schedule better than your own? Book a date and time directly.
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.