March 10, 2023

 

 

Inspiration from Cheyann 

 

REVIEW

  • Excel database
  • Word professional letter
  • Customer service/professional communication 

 

EXCEL - FINANCIALS & REPORTING 

  • Organization 
  • Formatting & shortcuts
  • Formulas

Workplace Scenario

Step 1: You work in a Create an office supplies budget for 2023.
 
 Step 2: Create a spending report to reflect actual spending and variance from budget.
  • ADD actual and variance columns
  • FREEZE panes
  • Fill in FORMULAS to calculate
  • Create conditional formatting to show if expenses were over/under budget
  • Add a cover sheet for totals

 

LUNCH!

 


Inspiration from Brenda

 

SCHEDULING 

1. Create a Doodle poll to schedule a bowling night for the group. 

2. Write an email with a link in the poll.

3. Create a calendar invite. 

 

GRAMMARLY!


WORD TEMPLATES - Workplace scenario

Postcard - 

You work in a pediatrician's office and your boss wants to send out a postcard to their clients about summer camp vaccinations and physicals. The clinic is offering a discount for all vaccinations and physicals from now through June 1.


Flyer - 

Your medical office is hosting a spring wellness fair. Your boss asks you to create a flyer for the fair to hang around town.

 

EMAIL - Workplace scenario

You receive an email about an overcharge on an invoice. Respond to the email.


REFLECTION -

1. What are your biggest "take aways" from the week?

2. What would you like to spend more time practicing? 

3.  How do you feel you used your learning skills this week? 

4. How are you feeling at the end of the week?

Comments

Post a Comment