Microsoft IT Academy

Week 3

August 29-September 2

 

Info. Tech Apps II - Excel

Academy - Access

MONDAY-

  • Bell Ringer: Open 04 Budget Expenses - Review Lesson 4
  • Complete Lesson 4 Projects
  • Intro Lesson 5 Formulas
  • Exploring Functions 117
    Displaying Dates and Times with Functions 119
    Exploring Dates 119
    Using TODAY 120
    Using NOW 120

WEDNESDAY-

  • Bell Ringer: Check Lesson 4 Projects
  • Con't Lesson 5 Notes
    • Using the SUM Function 122
      Using the COUNT Function 123
      Using the COUNTA Function 123
      Using the AVERAGE Function 124
      Using the MIN Function 125
      Using the MAX Function 125
      • COMPLETE LESSON 5 STEP-BY-STEPS 117-126

FRIDAY

  • Con't Lesson 5 "Functions"
    • Using a Financial Function 126
      Using Formulas to Create Subtotals 127
      Selecting and Creating Ranges for Subtotaling 127
      Building Formulas for Subtotaling 128
      Modifying Ranges for Subtotaling 129
      Uncovering Formula Errors 130
      Reviewing Error Messages 131
      Tracing and Removing Trace Arrows 132
      Displaying and Printing Formulas 133
      • COMPLETE LESSON 5 STEP-BY-STEPS 127-134

 

 

MONDAY-

  • Bell Ringer: Con't Lesson 6 Step-by-Steps
  • Lesson 6 Projects All

WEDNESDAY-

  • Bell Ringer: Lesson 7 Intro
  • Lesson 7 Step-by-Steps
  • Lesson 7 Projects All

 

FRIDAY

  • Bell Ringer: Con't work Lesson 7 Projects