Excel Level 1 Workshop - Oct. 24, 2022

 

Excel Level 1 Workshop

REVIEW SPREADSHEETS

• Terminology
• Organization
  
• Formulas 
• Opening and saving files
  

 

WORKING WITH LARGE SPREADSHEETS - Employee Database

• Freezing panes 
• Sorting & filtering
• Inserting comments 
• Conditional formatting
• Drop down lists / Data Validation
  
• Cover sheet
  

 

WORKING WITH YOUR SPREADSHEET

To your budget spreadsheet: 

• ADD actual and variance columns
• Fill in FORMULAS to calculate
• Create conditional formatting to show if expenses were over/under budget
• ADD comments when numbers were over budget
  
• Create a drop down list of who orders which items
• Add a cover sheet for totals

ADDITIONAL PRACTICE

Employee benefits 

Weekly payroll

RESOURCES

• LinkedIn Learning (through Teton County Library)
  
• YouTube