Intro to Excel Workshop - Oct. 24, 2022

 

Intro to Excel Workshop

EXCEL FOUNDATIONS

  • Purposes for spreadsheets
  • Parts of a spreadsheet 
    • rows & columns
    • cells
    • sheets

 

DATABASES

  • Info needed/included
  • Organization of columns & rows
  • Formatting & Shortcuts - cell size, alignment, dollars, dates, etc
  • Data entry & consistency
  • File saving & printing
  • Sorting

 

Workplace Scenario 

Create a spreadsheet to track your customers' information.  For your business, consider what type of data you will want to track now and for use in the future. Also, consider how you will want to use this data and potentially sort it.

 

FINANCIALS & REPORTING 

  • Organization 
  • Formatting & shortcuts
  • Formulas

  

Workplace Scenario

Create an office supplies budget for 2023.
 
 
 

 

 

 


 

Comments

Post a Comment