Getting Started with 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
Intro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
#NAME?
How to create a PivotTable from a Range or TableFilters, slicers, and Pivot Charts
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
Introduction to Power Query EditorImporting Data Transforming Data Data Cleansing
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/82548560486?pwd=KeZGpjERuSDQMz0WmxgrnY6uYbEA3P.1
How to enable Power Pivot in ExcelBenefits of Power Pivot