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....
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 - 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...
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....
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...
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...
Excel Basics (Part 1): How spreadsheets work, basic formulas, functions, and formatting This webinar is part 1 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this webinar we'll talk about the Excel environment, explore basic formulas and functions, and discuss spreadsheet formatting options....
MS Word Basics: Basic editing and formatting: fonts, bulleted lists, indentation, line spacing, tabs, and printing Registration ends by 5pm the day prior to the Webinar. Once you register on Eventbrite, you will receive an email from the instructor through GoToWebinar with the link to join this class. This 90-minute webinar is designed to introduce...
Excel Basics (Part 2): Sort and filter data, work with columns, rows, sheets, and copy/paste This webinar is part 2 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this 90-minute webinar we'll learn to sort and filter, work with columns, rows and sheets,...
In this 90-minute webinar learn how to take advantage of PowerPoint's many built-in template and style features. In this 90-minute webinar you'll learn how to take advantage of PowerPoint's many built-in template and style features that will help streamline your PowerPoint process! Pre-registration is required to attend. Registration ends by 5pm the day prior to...
This webinar is part 3 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. This webinar is part 3 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this 90-minute webinar we'll explore additional...
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...
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:• Ways for you to be...
MS Excel Beyond the Basics: Intermediate level overview including VLOOKUP, IF, PivotTables, protection, Tables, Charts, and data validation This in-person complimentary class is taught in 2 sessions over 2 days (See Below) and is designed to introduce key concepts crucial to building a working knowledge of MS Microsoft Excel. In this class we'll discuss intermediate...
We all need attractive, easy-to-read, "targeted" resumes -that are also easily customized. This IN-PERSON class is taught in 1 session from 1:00pm to 3:30pm. Learn how to streamline your resume, set tabs correctly, create custom bullets, insert stored text, and track changes. Understand the difference between a text resume to upload into Applicant Tracking Systems,...
Overview including animation, Slide Masters, Sound, and Looped Presentations. This IN-PERSON class is designed to introduce key concepts crucial to building a working knowledge of Microsoft PowerPoint. In this class we'll cover concepts including animation, Slide Masters, sound, and looped presentations. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes promptly at 5pm the day...
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....
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...
Jump Start Your Career -Manufacturing Careers Internship Program Are you ready to learn about career paths? Get a paid internship? Are you 18-24 years old?* Do you live in Evanston?* Are you looking for a career opportunity? Do you want to take charge of your career? *this program is limited to Evanston residents ages 18-24...
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...
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 FOR ATTENDING...
Jump Start Your Career -Manufacturing Careers Internship Program Are you ready to learn about career paths? Get a paid internship? Are you 18-24 years old?* Do you live in Evanston?* Are you looking for a career opportunity? Do you want to take charge of your career? *this program is limited to Evanston residents ages 18-24...
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 - 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...
