Learn how to manipulate /transform data quickly easily. This IN-PERSON, complimentary class is taught in one session at 1:00pm Chicago time. This NEW CLASS: Get started with Excel's amazing data management tool that allows you to manipulate and transform data quickly and easily. Learn how to create, edit, load and refresh basic queries that will...

This 90-minute webinar shows you why VLOOKUP is a must-have Excel function that's used to manipulate data. 9:30am Chicago time 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...

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 Advanced Concepts - Pivot Tables: Summarize and manipulate data with pivot tables and pivot charts 9:30am Chicago time 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...

Excel Focus on Functions- Work with Text and Dates: CONCATENATE, TODAY, Flash Fill and Delimited Text 1:00 pm Chicago time 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...

Excel Advanced Concepts - Get Started with Excel Tables 9:30am Chicago time You've heard of Excel tables but never had a chance to use them? Learn how to structure Excel tables, understand the differences between normal ranges and tables, and the advantages of using tables to create more complex pivot tables. Pre-registration is required to...

Excel Advanced Concepts - Additional tools: Data validation, Subtotal, and Conditional Formatting 1:00PM CHICAGO TIME This 90-minute webinar focuses on some of the additional tools available in Excel that are very useful but often overlooked. We'll talk about data validation, the Subtotal feature (an alternative to pivot tables), Outline and the What-If tools. Improving your...

This 90-minute webinar shows you how to manipulate /transform data quickly easily. 9:30am Chicago time This NEW CLASS: Get started with Excel's amazing data management tool that allows you to manipulate and transform data quickly and easily. Learn how to create, edit, load and refresh basic queries that will allow you to more easily solve...

MS Word Beyond the Basics - Efficient document design with Styles, Style sets, and built-in Quick Parts 1:00PM CHICAGO TIME 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...