Conditional Functions in Microsoft Excel
OnlineSUMIF. SUMIFS, AVERAGEIF, AVERAGEIFS
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.
SUMIF. SUMIFS, AVERAGEIF, AVERAGEIFS
This 45-minute virtual informational will highlight the available job training and employment programs specifically for Chicago Housing Authority residents and Housing Choice Voucher recipients. Before moving forward, you can join …
Creating Your Personal Marketing Tools:Identify your goals, skills, and interest. Select your job targets and research employers near you
(Branding, Networking and Opportunities)
Registration information: https://us06web.zoom.us/j/87631863344 Meeting ID: 876 3186 3344 Dial in: +1 312 626 6799
(Web-based Applications)
Create Your Personal Marketing Tools
Find and Apply for JobsPrepare for the Interview Accept, Negotiate, or Decline Offer
Accessing, creating workbooks, filtering data, formulas, functions, data validation, charts, and Pivotable
(Application Tracking System)
This 45-minute virtual informational will highlight the available job training and employment programs specifically for Chicago Housing Authority residents and Housing Choice Voucher recipients. Before moving forward, you can join …
(Domain, Attachments and Format)
Registration information: https://us06web.zoom.us/j/86265692473 Meeting ID: 862 6569 2473 Dial in: +1 312 626 6799
Registration information: https://us06web.zoom.us/j/86265692473 Meeting ID: 862 6569 2473 Dial in: +1 312 626 6799
Registration information: https://us06web.zoom.us/j/89556407751 Meeting ID: 895 5640 7751 +1 312 626 6799
Learn how to get started with Google Forms and create simple forms
(Branding, Networking and Opportunities)
(Web-based Applications)
(Application Tracking System)
This 45-minute virtual informational will highlight the available job training and employment programs specifically for Chicago Housing Authority residents and Housing Choice Voucher recipients. Before moving forward, you can join …
(Domain, Attachments and Format)
(Branding, Networking and Opportunities)
(Web-based Applications)
Benefits of Using DriveCreate & Upload Folders Organize Files in Folders Share Folders
(Application Tracking System)
Getting StartedCreating your Resume How to format your Resume according to the ATS Email and upload your resume
(Domain, Attachments and Format)
Getting StartedHow to create a new presentation Transition and Animations Adding Images, Music, and Videos
(Branding, Networking and Opportunities)
Getting Started Building Your Spreadsheet Sort & Filter Data Formulas & Basic Functions Charts Pivotable
(Web-based Applications)
Creating a new WorkbookHow to insert and delete cells Modifying Columns and Rows Formatting Cells Learn all about formatting numbers in Excel Data Filtering & Validation
Intro to Formulas Learn how to use cell references to create a simple formula in Excel How to create a complex formula in Excel
Choose Chicago, The Magnificent Mile Association, Illinois Restaurant Association, Illinois Hotel and Lodging Association, Chicago Loop Alliance, Near South Planning Board, Cook County and the American Hotel Lodging Association Foundation …
Creating Your Personal Marketing Tools: Identify your goals, skills, and interest. Select your job targets. Research employers near you.
The parts of a function Creating a function Learn to create a function using the AutoSum command
Understanding charts How to insert a chart Chart and layout style Switching rows and columns data How to change the chart type
Create Your Personal Marketing Tools
Find and Apply for Jobs Prepare for the Interview Accept, Negotiate, or Decline Offer
How to create a PivotTableHow to insert Slicers Timeline PivotChart
(Application Tracking System)
(Domain, Attachments and Format)
Getting Started with Google FormsCreating Simple Forms Adjusting Your Settings Sending Forms Organizing and Analyzing Responses
(Branding, Networking and Opportunities)
(Web-based Applications)
(Application Tracking System)
(Domain, Attachments and Format)
(Branding, Networking and Opportunities)
(Web-based Applications)
Creating a new WorkbookHow to insert and delete cells Modifying Columns and Rows Formatting Cells Learn all about formatting numbers in Excel Data Filtering & Validation
(Application Tracking System)
Intro to FormulasLearn how to use cell references to create a simple formula in Excel How to create a complex formula in Excel
(Domain, Attachments and Format)
The parts of a functionCreating a function To create a function using the AutoSum command
(Branding, Networking and Opportunities)
Understanding chartsHow to insert a chart Chart and layout style Switching rows and columns data How to change the chart type
(Web-based Applications)
How to create a PivotTableHow to insert Slicers Timeline PivotChart
Getting StartedBuilding Your Spreadsheet Sort and Filter Data
Creating Your Personal Marketing Tools:Identify your goals, skills, and interest. Select your job targets and research employers near you
Formulas and Basic FunctionsCharts Pivotable
Create Your Personal Marketing Tools
Find and Apply for JobsPrepare for the Interview Accept, Negotiate, or Decline Offer
Sending EmailResponding to Email Managing Email
(Application Tracking System)
(Domain, Attachments and Format)
Getting Started with Google FormsCreating Simple Forms Adjusting Your Settings Sending Forms Organizing and Analyzing Responses
(Branding, Networking and Opportunities)
(Web-based Applications)
How to insert and delete cells Modifying Columns and Rows Formatting Cells Data Filtering and Validation
(Application Tracking System)
Intro to Formulas Learn how to use cell references to create a simple formula in Excel Complex formula in Excel
(Domain, Attachments and Format)
Virtual Overview Workshop
The parts of a function Creating a function To create a function using the AutoSum command
(Branding, Networking and Opportunities)
How to create a PivotTable How to insert Slicers Timeline PivotChart
(Web-based Applications)
Understanding charts How to insert a chart Chart and layout style Switching rows and columns data How to change the chart type
(Application Tracking System)
How to create a PivotTable How to insert Slicers Timeline PivotChart
(Domain, Attachments and Format)
Back to Work 50+ Virtual Cohort Session #1 Prepare for Your Job Campaign Identify Your Goals, Skills, and Interest Select Your Job Targets and Research Employers Near You
Getting Started Building Your Spreadsheet Sort and Filter Data Formulas
(Branding, Networking and Opportunities)
Basic Functions Charts Pivotable
(Web-based Applications)
Back to Work 50+ Virtual Cohort Session #2 Create Your Personal Marketing Tools
Back to Work 50+ Virtual Cohort Session #3 Find and Apply for Jobs Prepare for the Interview Accept, Negotiate, or Decline Offer
How to create a new Document Tables and Bulleted lists Formatting Pictures Shapes Page Borders
(Branding, Networking and Opportunities)
The meeting will be held virtually and in person. To join virtually, please use the following link: https://us06web.zoom.us/j/87992475997?pwd=M05OcDJnek5ZT0dUenpBTnpzbi9tdz09 For in person, the meeting will be at 69 W Washington, Chicago, …
Background Friendly! Expungement clinic, Free training programs, and Raffles on-site!
Hiring for the following: CDL Class A or B Drivers Diesel Mechanics Aviation Maintenance Technicians Automotive Mechanic Supply Chain Manager Forklift Operator Shipping and Receiving Clerks and more...
How to create a new Document Text Basics Tables and Bulleted lists Formatting Pictures
(Web-based Applications)
About The Job Fair The Job Fair is a collaboration of State Senator Robert Peters, State Representative Curtis J. Tarver, State Representative Kam Buckner, Cook County Commissioner Bill Lowry, Alderman …
The meeting will be held virtually and in person. To join virtually, please use the following link: https://us06web.zoom.us/j/81633193064?pwd=d3NsWlVEZTNJMHdQWTlQYUpTYW9CUT09 For in person, the meeting will be at 69 W Washington, Chicago, …
Creating and Opening Presentations Applying Themes Applying Transitions Animations Inserting Pictures Inserting Audio and Videos
(Application Tracking System)
Creating and Opening Presentations Applying Themes Applying Transitions Animations Inserting Pictures Inserting Audio and Videos
(Domain, Attachments and Format)
Meeting will be held virtually and in person. To join virtually, please use the following link: https://us06web.zoom.us/j/84687436548?pwd=Z3pNNHJDeGJJTG5zV01rT2FsMjkxdz09 For in person, the meeting will be at 69 W Washington, Chicago, 22nd …
The meeting will be held virtually and in person. To join virtually, please use the following link: https://us06web.zoom.us/j/84687436548?pwd=Z3pNNHJDeGJJTG5zV01rT2FsMjkxdz09 For in person, the meeting will be at 69 W Washington, Chicago, …
Meeting will be held virtually and in person. To join virtually, please use the following link: https://us06web.zoom.us/j/88235583443?pwd=V3J0ajNON2pGUHAxQ3VJTjhnSlA2dz09 For in person, the meeting will be at 69 W Washington, Chicago, 22nd …
This Youth Opportunity Fair is hosted at the Ebenezer G.C.R. Gymnasium located at 1246 South Harvey Ave., Berwyn, IL 60402. The Cook County Career Connector program promotes a more inclusive …
Virtual Overview Workshop
The Illinois Tollway invites individuals interested in starting a career in the heavy-highway and related construction industry to get involved with ConstructionWorks. Supported by a network of training partners throughout …
The Illinois Tollway invites individuals interested in starting a career in the heavy-highway and related construction industry to get involved with ConstructionWorks. Supported by a network of training partners throughout …
Building Your Path to Success! ConstructionWorks is a FREE program designed to link job seekers with opportunities for rewarding careers in Illinois’ high-demand transportation-related construction industry. Master skills today, excel …
The Chicago Cook Workforce Partnership - AARPF 50+ and Working Credit NFP, a national non-profit, are teaming up to provide a workshop on establishing and maintaining a good credit score. …
Back to Work 50+ Virtual Cohort Session #2Create Your Personal Marketing Tools
Back to Work 50+ Virtual Cohort Session #3Find and Apply for Jobs Prepare for the Interview Accept, Negotiate, or Decline Offer
To register, contact 855-850-2525. AARPF Back to Work 50+ Virtual Overview Workshop | 7 Smart Strategies
Prepare for Your Job Campaign. Identify Your Goals, Skills, and Interest. Select Your Job Targets and Research Employers Near You! To register, contact 855-850-2525.
Create Your Personal Marketing Tools, 30 Second Elevator Speech, Cover Letter and Resume, Thank You Notes; and Online Presence to Marketing yourself to Employers. To register, contact 855-850-2525.