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....
S & C Electric Hiring Event - This event is IN PERSON. Walk-ins Welcome Wednesday July 24th at 10am – 12pm American Job Center in Wheeling 1400 S. Wolf Road, Building 200, Wheeling, IL 60090 1/2 block south of Palatine-Willow Road, on the west side of Wolf Road. Ample free parking. Meet with S &...
Learn how to use IF and other logical functions to add conditions to Excel tasks 1:00PM 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 also talk about other logical functions like AND/OR...
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 - 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...
The Illinois State Police is Hiring! On-Site Recruitment will be held at The AMERICAN JOB CENTER IN WHEELING, 1400 South Wolf Rd. Building 200, Wheeling IL. Date: 07/30/2024 Time: 8:30am - 10:30am 2024.07.30 Illinois State Police Hiring Flyer (003) cor.
How do I effectively craft my resume to get interviewed and hired? 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 Tuesday, July 30, 2024 at 1:00 Chicago time, for an in-person event that will transform your job search...
Discover your next opportunity at the Chicago Residents and New Arrivals Job Fair Event on July 31st. This event offers valuable opportunities for both local residents and newcomers with valid work authorization. Date: Wednesday, July 31 Time: 10:00am - 2:00pm Arturo Velasquez Institute Conference Center, Room 1203 2800 S. Western Avenue Chicago, IL 60608 Career...
This 90-minute webinar shows you how to manipulate /transform data quickly easily. 9:30am Chicago time This NEW CLASS: Get started with Excel's amazing data management tool that allows you to manipulate and transform data quickly and easily. Learn how to create, edit, load and refresh basic queries that will allow you to more easily solve...
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 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...
Maybe a little friendly interview coaching will help? This IN-PERSON class is taught in 1 session from 1:00pm to 2:30pm. Are you tired of acing interviews only to be left empty-handed? If you've been struggling to land a job after making it past the interview stage, don't give up just yet. Learn sneaky secrets to...
