Excel Pivot Tables Level II In this 90-minute webinar we'll dive deeper into Pivot Tables exploring Pivot Charts, Slicers, Timelines, Calculated Fields and Custom Grouping. Familiarity with basic pivot tables recommended. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Once you register, you will receive the link to enter class shortly before class. Please watch for an...
Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. We'll talk about function syntax, how to recognize problems with functions, how the function library is organized, and some general troubleshooting for Excel spreadsheets. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted on a space available basis....
This In Person, complimentary workshop, we'll explore Google Drive, Google Docs and Google Sheets. Free Google account required. Learn how to store files online, access them from anywhere, and share these files with others. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted on a space available basis. Workshop Location: American Job Center in Wheeling...
Streamline your Excel process with popular Windows keyboard and mouse shortcuts. Learn how to use Excel shortcut keys to quickly navigate worksheets and improve your productivity. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted on a space available basis. Workshop Location: American Job Center in Wheeling 1400 S Wolf Road, Building 200, Suite 200,...
Unleash your inner creativity - that you didn't even know you have! Learn how to easily create content for print, presentations and social media with this free app. Canva is a free-to-use online graphic design tool that you can use to create social media posts, presentations, posters, videos, logos and more. Free Canva account required. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins...
Hiring for hundreds of jobs at all levels – from entry level to senior management! (FOR COMPLETE FLYER) North Suburban Cook County Career Connector Hiring & Career Resources Event Questions? email contact@bcsillinois.org Funding for the North Suburban Cook County American Job Center is made possible through a grant provided by the Chicago Cook Workforce Partnership....
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 and use the Power Query Feature. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24...
Get going with Google Docs: Use Docs to easily create, edit and store text-based files online In this 90-minute webinar we'll explore Google Docs - Google's web-based alternative to MS Word. Learn how to use this online text editor to create, download, and share letters, reports, resumes and other text-based documents. PRE-REGISTRATION IS REQUIRED FOR...
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 Focus on Functions - Lookup and Reference: explore VLOOKUP, HLOOKUP and alternatives like INDEX and MATCH 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. We'll also look at some alternatives to VLOOKUP like INDEX/MATCH. PRE-REGISTRATION...
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...
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 and use the Power Query Feature. PRE-REGISTRATION...
