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

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

Excel Advanced Concepts - Get Started with Excel Tables 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. P re-registration is required to attend. Registration...

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

Learn how to use IF and other logical functions to add conditions to Excel tasks 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 as well as...

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 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. P re-registration is required to...

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. March 6 & Thurs. March 7 FROM 9:30am to noon - Excel Basics: Spreadsheet construction, basic formulas and functions, sort, filter, formatting, and printing This...

WORD Basics: Document creation, font, paragraph and page formatting including bulleted lists, alignment, indentation, and line spacing This in-person class is taught in 1 sessions (See Below) FROM 1:00pm to 3:30pm Microsoft WORD Basics: Document creation, font, paragraph and page formatting including bulleted lists, alignment, indentation, and line spacing. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS...

PowerPoint Basics: Create, edit and format slides, use themes, transitions and animation This in-person class is taught in 1 sessions (See Below)FROM 1:00pm to 3:30pm- PowerPoint Basics: Create, edit and format slides, use themes, transitions and animation. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Class session is in 1 SESSION: Mar. 7th from1:00PM to 3:30PM...