Thankfully we have 17 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.
This class isn't on the schedule at the moment, but
save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.
You will need a reliable Internet connection as well as a computer or device with which you can access your virtual class. We recommend you arrive to class 5-10 minutes early to ensure you're able to set up your device and connection.
This class will be held via Zoom unless otherwise specified
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.
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.
In this course, you will gain an understanding of the more advanced functionality in Excel 2016.
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
Lesson 5: Using PivotTables and PivotCharts
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.
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.
This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
Booking for more than 6+?
See more dates and classes for private groups
Get quick answers from CourseHorse and past students.
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 Online educator.
Learn the basics of working with spreadsheets using Microsoft Excel. Topics include entering data and formulas, moving and copying data, formatting & print previewing worksheets. Please note: Must register with a valid email address. You will receive an email 2 hours prior to the start of the class with the link to join the virtual...
Saturday Dec 3rd, 10:30am - 12:30pm Eastern Time
In this three-hour session for Windows users only, you will import external data and create queries using Power Query to bring in data from external sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting...
Friday Dec 2nd, 9am - 12pm Pacific Time
In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have...
Saturday Dec 3rd, 9am - 12pm Pacific Time
In this three-hour session for Windows and Mac users, you will learn how to write complex formulas using Excel's advanced built-in functions. You will expand your library of functions to include lookup and reference functions, conditional logic, database summarization functions, and dynamic array functions. You will also become expert at using mixed...
Saturday Dec 3rd, 1pm - 4pm Pacific Time
Explore more advanced features of Microsoft Excel. Topics include using formulas and functions, absolute cell references, data sorting and filtering, and conditional formatting. To participate hands-on in this class, it is advised that you have one of the following versions of Excel: PC - 2010, 2013 , 2016 , 2019 Mac - 2016 , 2019 You will...
Monday Dec 5th, 5pm - 6:30pm Eastern Time
Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...
Tuesday Dec 13th, 9am - 4pm Central Time
This class covers how to use conditional logic in formulas and functions, allowing you to create formulas that act differently in different circumstances. Topics covered include: IF statements, nested IF statements, AND and OR functions. To participate hands-on in this class, it is advised that you use one of the following versions of Excel: PC...
Monday Dec 5th, 7pm - 8:30pm Eastern Time
Excel Intermediate Class teaches PivotTables, Advanced Functions, and Charts An Excel Intermediate Class takes your skills to the next level by utilizing some of the advanced tools Excel has to offer. In Microsoft Excel for Beginners, you became more comfortable with Excel and how it can help you be more productive. Throughout this excel training...
Tuesday Dec 6th, 9am - 12:30pm Mountain Time(2 sessions)
Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...
Wednesday Dec 14th, 9am - 4pm Central Time
This three-hour session for Windows and Mac users introduces you to Excel’s interface and fundamental capabilities. By the end of the session, you will be easily getting around in Excel’s Ribbon-based interface, able to enter and edit labels, values and dates, extend series of dates and months, cut and paste entries, insert and delete cells and...
Tuesday Dec 6th, 1pm - 4pm Pacific Time
Automate your workflow and analyze your data with Excel Training Advanced Excel training will lessen the amount of time you spend doing repetitive tasks. There are more productive ways to work and this Microsoft Excel Advanced class (Level 3) will show you how the right way to get started. In this Excel training, you will learn how to automate...
Tuesday Dec 13th, 9am - 12:30pm Mountain Time(2 sessions)
In this three-hour session for Windows and Mac users, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart...
Tuesday Dec 13th, 1pm - 4pm Pacific Time
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. Students must have MS Office Excel software installed on their computer to participate in class. Target Student: This...
Tuesday Dec 13th, 6pm - 9pm Mountain Time(2 sessions)
This three-hour session for Windows and Mac users teaches you how to write formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, write arithmetic formulas by hand, parse text strings with the LEFT, MID, RIGHT and SEARCH functions, and perform calculations on dates. You will use HLOOKUP and VLOOKUP to retrieve data based...
Friday Dec 16th, 1pm - 4pm Pacific Time
Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...
Thursday Dec 15th, 9am - 4pm Central Time
Learn Excel to edit and manipulate your spreadsheets This Advanced Excel Class focuses solely on solving complex problems with your data. We will walk you all the way through the basics of formula creation to advanced logical and look-up functions. Learn Excel with our hands-on training in this Advanced Excel class – Formulas & Functions. You...
Tuesday Dec 27th, 9am - 12:30pm Mountain Time(2 sessions)
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. By applying the robust functionality that's built into Excel to your organization's raw data, you will be able to gain...
Thursday Jan 26th, 9am - 4pm Mountain Time
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.