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 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. Improving your EXCEL skills can...
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. May 1 & Thurs. May 2 FROM 9:30am to noon (Chicago time) - Excel Basics: Spreadsheet construction, basic formulas and functions, sort, filter, formatting, and...
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 Chicago time Microsoft WORD Basics: Document creation, font, paragraph and page formatting including bulleted lists, alignment, indentation, and line spacing. PRE-REGISTRATION IS REQUIRED FOR...
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: May 2 from1:00PM to 3:30PM...
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...
Google Drive, Docs and Sheets Basics: Get started with Google's popular text and spreadsheet applications In this 90-minute webinar we'll explore Google's online alternatives to MS Word and Excel. Google Docs can be used to create letters, reports, resumes and other text-based documents. Google Sheets allows you to create spreadsheets using many of the same...
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...
In this 90-minute webinar we'll explore Sheets - Google's web-based alternative to Excel. Learn to use this powerful spreadsheet program to In this 90-minute webinar we'll explore Sheets - Google's web-based alternative to Excel. Learn to use this powerful spreadsheet program to create spreadsheets, work with functions, add formatting, and sort/filter data. Preregistration is required...
9:30am Chicago time. Take the LinkedIn Basics workshop to make your LinkedIn profile easy to find, learn ways to find others and much more! Instructor Dee Reinhardt leads this highly interactive session. Participants must have an active LinkedIn profile (and know your password) in order to register for this workshop. Topics covered will include: •...
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. Pre-registration is required to attend. Registration ends...
