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

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

PowerPoint Beyond the Basics: Intermediate level overview including animation, Slide Masters, sound, and looped presentations This VIRTUAL WEBINAR is designed to introduce key concepts crucial to building a working knowledge of Microsoft PowerPoint. In this class we'll talk about intermediate level concepts including animation, Slide Masters, sound, and looped presentations. Pre-registration is required to attend....

Excel Advanced Concepts - Dashboards: Use PivotTables, Sparklines, Charts, VLOOKUP to create Excel Dashboards Dashboards are at-a-glance summaries that use graphics to illustrate progress towards a goal. Excel has a number of features like PivotTables, PivotCharts, Sparklines, and Functions that can be combined to create surprisingly robust dashboards. We highly recommend you have some familiarity...