You're browsing Excel Classes in Online

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...

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...

This class will cover how to use different string functions, how to perform goal-seeking and data scrubbing with Excel.   You will receive an email 2 hours prior to the start of the class with the link to join the virtual class.  *Please note that some people using older or less common email addresses have experienced issues with receiving...

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...

This class will cover the most popular lookup method in Excel, VLOOKUP, which is used to search for and retrieve information in data sets, and work with the results. To participate hands-on in this class, it is advised that you use one of the following versions of Excel: PC - 2007 , 2010 , 2013 , 2016 , 2019 Mac - 2016 , 2019 Must...

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...

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...

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...

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...

This class will cover creating multiple Pivot Tables, Pivot Charts, and Slicers, and combining them into one interactive worksheet that we call a Dashboard. Skills required: Know how to navigate menu options in Excel Understand Pivot Tables and Pivot Charts Know how to customize charts Excel Genius is a new set of classes aimed at students who have...

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...

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...

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...

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...

There is a growing need for office professionals to become proficient using the Microsoft Office Suite applications for meetings, presentations, reporting and data analysis. This course will give you a comprehensive look at the most frequently used features in Word, Excel, PowerPoint, Outlook and Access. Upon successful completion, you will receive...