Functions and Conditional Formatting in Microsoft Excel
OnlineSum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
View monthly American Job Center Newsletters in the news section for more resources and upcoming events.
Get news delivered to your email — subscribe to our newsletter.
Sum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
How to insert a chartChart and layout style Switching rows and columns How to change the chart type
Removing Duplicates How to combine multiple worksheets in one Get data from a PDF File Import data from a text file
How to create a PivotTable from a Range or Table Filters, slicers, and Pivot Charts
How to create and format your Resume according the ATSHow to track all the details of your job hunt and be organized Job Search Techniques Emails components Proper etiquette while sending your job application email How to organize your email Uploading and downloading your Resume
Getting Started with Google DriveCreating Google Docs Formatting Text Working with Tables & Images
Getting Started with Your PresentationSlide Basics Adding Transitions & Animations Presenting your Slide Show
Creating Simple FormsAdjusting the Settings Sending Forms Organizing and Analyzing Responses
Getting Started with Google SheetsFormatting Cells Working with Formulas & Functions Creating Charts
Creating DocumentsFormatting Text Headers & Footers Formatting Pictures &Tables
How to combine excel and word to create labels, letters & envelopes
The St. Paul Community Development Ministries 10th Annual Construction Conference & Expo is back! Get ready for a day filled with exciting opportunities and valuable insights. Join us for this in-person event on Thursday, August 15, 2024, at 4550 S. Wabash Avenue, Chicago, IL 60653. Registration is NOT required. Whether you're a seasoned professional or …
Slide BasicsApplying Themes, Transitions & Animations Presenting your Slide Show
Inserting Music & VideosWorking with Tables & Charts
Sum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
Intro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
Sum, average, count, maximum value, and minimum valueThe IF, VLOOKUP & SUBTOTAL functions
How to insert a chartChart and layout style Switching rows and columns How to change the chart type
How to create a PivotTable from a Range or TableFilters, slicers, and Pivot Charts
Introduction to Power Query EditorImporting Data Transforming Data Data Cleansing
How to enable Power Pivot in ExcelBenefits of Power Pivot
How to create and format your Resume according the ATSHow to track all the details of your job hunt and be organized Job Search Techniques Emails components Proper etiquette while sending your job application email How to organize your email Uploading and downloading your Resume
Career seeker registration link to be announced! Employers can register at https://50thward.org/jobfair
This meeting will be held in person at 69 W Washington St, Chicago, IL, 60602 – 22nd floor, Conference Room D. You may attend this meeting virtually through Zoom. https://chicookworks-org.zoom.us/j/85073336537?pwd=iN1ubbXsmyNhHfQhbbxYlaoFmiBu2S.1
This meeting will be held in person at 69 W Washington St, Chicago, IL, 60602 – 22nd floor, Conference Room D. You may attend this meeting virtually through Zoom. https://chicookworks-org.zoom.us/j/87302003342?pwd=6KBWTptPxrYkP2iEVJ0VbfP8ds3EGU.1
This meeting will be held in person at 69 W Washington St, Chicago, IL, 60602 – 22nd floor, Conference Room D. You may attend this meeting virtually through Zoom. https://chicookworks-org.zoom.us/j/86304694237?pwd=m5YFOksdyAPvNF6oHte8aMDbdwSy5L.1
This meeting will be held in person at 69 W Washington St, Chicago, IL, 60602 – 22nd floor, Conference Room H. You may attend this meeting virtually through Zoom. https://chicookworks-org.zoom.us/j/82548560486?pwd=KeZGpjERuSDQMz0WmxgrnY6uYbEA3P.1