Virtual Overview Workshop

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. You can’t “afford” to miss this

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

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 FormulasLearn how to use cell references to create a simple formula in Excel How to create a complex formula in Excel

The parts of a functionCreating a function To create a function using the AutoSum command

Understanding chartsHow to insert a chart Chart and layout style Switching rows and columns data How to change the chart type

How to create a PivotTableHow to insert Slicers Timeline PivotChart

Getting StartedCreating your Resume How to format your Resume according to the ATS Email and upload your resume

Getting StartedHow to create a new presentation Transition & Animations Adding Images Music and Videos

Getting Started with Google FormsCreating Simple Forms Adjusting Your Settings Sending Forms Organizing and Analyzing Responses

Getting StartedBuilding Your Spreadsheet Sort & Filter Data Formulas & Basic Functions Charts Pivotable

Getting StartedHow to create a new presentation Transition & Animations Adding Images Music and Videos

How to insert and delete cellsModifying Columns and Rows Formatting Cells Data Filtering and Validation

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 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

How to create a PivotTableFilters, slicers, and PivotCharts.

How to combine multiple worksheets in oneGet data from a PDF File

How to create a new documentTables and Bulleted lists Adding Pictures and Shapes

How to combine excel and word to create labels, letters and envelopes

Applying Themes and TransitionsAnimations Inserting Pictures, Audio and Videos

How to use the Morph transition, and combine shapes and images

Emails componentsProper etiquette while sending your job application email How to organize your email Uploading and downloading your resume

Benefits of Using DriveCreate and Upload Folders Organize Files and Folders Share Folders

How to create a new DocumentText Basics Tables and Bulleted lists Formatting Pictures

Creating and Opening PresentationsApplying Themes Applying Transitions Animations Inserting Pictures Inserting Audio and Videos

Getting StartedBuilding your Spreadsheet Sort, Filter & Data Validation Formulas & Functions Chart and Pivotable

How to insert and delete cellsModifying Columns and Rows Formatting Cells Data Filtering and Validation

Intro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel