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...
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...
Are you an immigrant or refugee with university education and professional experience from outside the U.S.? Get strategies to adapt your professional job search to American job search practices. We will discuss résumé do's and don'ts, networking, interviewing, credential evaluation, and more. Learn how to: Prepare for Your Job Search Reach Out to Your Network...
Excel Advanced Concepts: Additional Data Analysis tools - Data validation, Subtotal and What-Ifs This 90-minute webinar focuses on some additional data 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), and the What-If tools. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS...
REMOTE OFFICE HOURS at American Job Center in Wheeling 1400 S Wolf Rd Wheeling, IL 60090 Monday 8/26 2-4 pm. Staff from State Rep Tracy Katz Muhl, along with the office of Treasurer Michael Frerichs (find your unclaimed property with iCash) and State Representative Mary Beth Canty. On Monday, our teams will be hosting remote...
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 - 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...
Excel Focus on Functions- Work with Text and Dates: CONCATENATE, TODAY, Flash Fill and Delimited Text 9:30 am Chicago time 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...
Canva Basics - Create content for print, presentations and social media with this free online graphic design app Aug 29 at 1pm Chicago time 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...
This IN-PERSON class is taught in 1 session from 1:00pm to 2:30pm. Creating Your Target Resumes - More critical than you think! Join us on Thursday, August 29, 2024 at 1:00pm (Chicago time), for an in-person event that will transform your job search game! Located at Harper Learning & Career Center 1375 South Wolf Road,...
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. PRE-REGISTRATION IS REQUIRED FOR...
Basic editing and formatting: fonts, bulleted lists, indentation, and line spacing This 90-minute webinar is designed to introduce key concepts crucial to building a working knowledge of MS Word. In this webinar we'll talk about the Word environment, and explore the essential editing/formatting tools necessary to create basic documents. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS...
