Formulas in Microsoft Excel
OnlineIntro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
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.
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
Career Connector consists of a series of in-person programs and events throughout suburban Cook County that connect residents to quality career-path opportunities and employers to a skilled, diverse talent pool. This program is brought to you by Cook County and The Chicago Cook Workforce Partnership.
“Building Wealth Today for Tomorrow Financial Empowerment Summit” (BWTT) is the largest financial education program of its kind in Chicago. Experts and leaders from businesses, community organizations, city, state and federal agencies lead workshops and discussions that provide the resources and knowledge you need to build long-term wealth and a more secure future. Learn more at: …