Microsoft Excel Basics: Excel Basics: Spreadsheet construction, basic formulas and functions, sort, filter, formatting, and printing This IN-PERSON class is taught in 2 sessions over 2 days (See Below) Wed. July 10 & Thur. July 11 from 9:30am to noon Chicago time - Excel Basics: Spreadsheet construction, basic formulas and functions, sort, filter, formatting, and...

Learn the basics of this popular free web-based alternative to MS Word. (Must have a Google account!) Quickly learn how to create and edit. This in-person, complimentary class is taught in one session at 1:00pm Chicago time. This NEW CLASS: Learn the basics of this popular free web-based alternative to MS Word. (Must have a...

Google Sheets is a powerful tool to use for mathematical functions. (Must have a Google account!) This in-person, complimentary class is taught in one session at 1:00pm Chicago time. This NEW CLASS: Google Sheets is a widely used spreadsheet program. Google Sheets is a powerful tool to use for mathematical functions. Get started with Sheets...

Setup, structure and syntax, common problems with functions, and troubleshooting tips Not as confident about Excel functions as you'd like to be? This virtual webinar is designed for people who who have used Excel but don't feel they know enough about functions. We'll talk about function syntax, how to recognize problems with functions, how the...

MS Word Beyond the Basics - Efficient document design with Styles, Style sets, and built-in Quick Parts In this virtual webinar: Discover the power of Styles - the efficient way to format and design Word documents. If you're a regular user of Word creating reports, proposals, manuscripts, etc. learning to use Styles is a game...

This 90-minute webinar shows you why VLOOKUP is a must-have Excel function that's used to manipulate data. VLOOKUP is a must-have Excel function that's used to manipulate data. In this 90-minute webinar we'll explore VLOOKUP and the additional options that make it such a useful tool - and then delve deeper into the Lookup and...

Graphically visualize and communicate data using Excel's robust chart tools In this 90-minute session you'll learn to make your data more understandable and accessible using Excel's robust chart feature. Learn how to choose the right chart type (column, line, pie, etc.), and explore formatting and layout options. We'll also explore some of Excel's lesser known...

Excel Advanced Concepts - Pivot Tables: Summarize and manipulate data with pivot tables and pivot charts In this 90-minute webinar we'll talk about what a pivot table does and how to create pivot tables and pivot charts. We'll also look at some of the additional PivotTable options like Slicers, Timelines, calculated fields and custom grouping....

Learn how to use IF and other logical functions to add conditions to Excel tasks 1:00PM Chicago time Add power and complexity to your Excel spreadsheets! In this 90-minute webinar we'll talk about about one of the most powerful functions in Excel - the IF function. We'll also talk about other logical functions like AND/OR...

Excel Focus on Functions- Work with Text and Dates: CONCATENATE, TODAY, Flash Fill and Delimited Text Text strings and dates can cause big problems in a spreadsheet if you're not aware of how to identify and manipulate them! In this 90-minute webinar we'll talk about basic text functions like CONCATENATE and date functions like TODAY....