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 - 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...
Are you ready to learn about career paths? Get a paid internship? MCIP: Manufacturing Careers Internship Program Attend this virtual program - CHOOSE YOUR DATE! (click on register to view upcoming dates) Jump Start Your Career. Are you 18-24 years old?* Do you live in suburban Cook County?* Are you looking for a career opportunity?...
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. Pre-registration is required to attend....
Are you ready to learn about career paths? Get a paid internship? MCIP: Manufacturing Careers Internship Program Attend this virtual program - CHOOSE YOUR DATE! Jump Start Your Career. Are you 18-24 years old?* Do you live in suburban Cook County?* Are you looking for a career opportunity? Do you want to take charge of...
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 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....
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...
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, Pivot Charts, Sparklines, and Functions that can be combined to create surprisingly robust dashboards. We highly recommend you have some...
Canva Basics - Create content for print, presentations and social media with this free online graphic design app In this virtual webinar: You don't need to be a graphic designer to produce professional looking designs! By utilizing Canva's built-in templates, photo and font options anyone can create exciting content to be shared online, posted on...
Are you ready to learn about career paths? Get a paid internship? MCIP: Manufacturing Careers Internship Program Attend this virtual program - CHOOSE YOUR DATE! Jump Start Your Career. Are you 18-24 years old?* Do you live in suburban Cook County?* Are you looking for a career opportunity? Do you want to take charge of...
