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...
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, and explore different ways...
Create a slide presentation using themes, graphics, and transitions: In this 90-minute webinar you'll learn how to create PowerPoint slides and explore how to take advantage of PowerPoint's many built-in template and style features to help streamline your PowerPoint process! PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Once you register, you will receive the link...
Function overview & troubleshooting, Comments, and printing in 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 functions, look at how functions behave in the Excel environment, add Comments, and discuss printing...
Learn how to use IF and other logical functions to add conditions to Excel tasks This virtual class meets on December 5th at 1:00am Chicago time. 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...
Take the LinkedIn Basics workshop to enhance your profile. Participants must have a LinkedIn profile, access to username, password & email. LinkedIn Beginners-FREE- In Person PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Come join us on Tuesday, December 10, 2024 at the American Job Center in Wheeling for a hands-on workshop on how to enhance...
Excel Function Overview (In Person Class) Excel Functions Overview: Setup, structure and syntax, common problems with functions, and troubleshooting tips Not as confident about Excel functions as you'd like to be? This in person class is designed for people who who have used Excel but don't feel they know enough about functions. We'll talk about...
Excel Charts (In Person Class) Excel Charts - Graphically visualize and communicate data using Excel's robust chart tools During this in person class we 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...
EXCEL Shortcuts (In Person class) Excel Charts - Graphically visualize and communicate data using Excel's robust chart tools 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...
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...
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 IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Once you register,...
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...
Learn the basics of Pivot Table construction in Excel. We'll discuss data organization, define what a pivot table does, and create several examples of this need-to-know Excel feature. Familiarity with the Sorting and Filtering tools in Excel is recommended. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Once you...
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....
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! Registration closes 24 hours prior to class. Once you register, you will receive the link to enter class shortly before class. Please...
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...
I-Cash Location: American Job Center in Wheeling 1400 S Wolf Road, Building 200, Suite 200, Wheeling, IL 60090 One block south of Palatine-Willow Road & Wolf Road. West side of Wolf Road. Ample free parking This American Job Center is committed to providing all customers with quality, professional services as well as a safe and...
