Microsoft IT Academy

Week 5

September 12-16

 

Info. Tech Apps II - Excel

Academy - Access

MONDAY-

  • Bell Ringer: Open 04 Budget Expenses - Review Lesson 4
  • LESSON 6 NOTES
  • Inserting Cells into a Worksheet 145
  • Manually Formatting Cell Contents 147
    • Changing Text Orientation 149
      Choosing Fonts and Font Sizes 150
      Changing Font Color 151
      Applying Special Character Attributes 152
      Filling Cells with Color 153
      Applying Number Formats 154
      Wrapping Text in a Cell 157
      Merging Cells and Splitting Merged Cells 158
      Placing Borders around Cells 159
      Copying Cell Formatting with the Format Painter 161
    • Understanding Paste Special Options 161

WEDNESDAY-

  • Bell Ringer: Check Lesson 4 Projects
  • Con't Lesson 6 Notes
    • Customizing Cell Styles 164 Working with Hyperlinked Data 165
      Inserting a Hyperlink into a Worksheet 165
      Using a Hyperlink 166
      Removing a Hyperlink from a Worksheet 166
    • Applying Conditional Formatting to Cells 168
      Applying a Specific Conditional Format 168
      Applying Conditional Formatting for Multiple Criteria 169
      Using the Rules Manager to Apply Conditional Formats 169
      Clearing a Cell’s Formatting 171
    • Lesson 6 Projects 6-1 to 6-6

FRIDAY

  • Con't Lesson 7 "Functions"
    • Lesson 7 Notes
      • Working with Rows and Columns 179
      • Using Themes 185
      • Modifying a Worksheet’s Onscreen and Printed Appearance 190
      • Inserting Headers and Footers 193
      • Watermarks/Backgrounds 195
      • Preparing a Document for Printing 198

 

 

MONDAY-

  • Bell Ringer: Lesson 8 Project Check
  • Lesson 9 Step-by Steps

WEDNESDAY-

  • Bell Ringer: Lesson 7 Intro
  • Con't Lesson 9 Step-by-Steps
  • Lesson 9 Projects All

 

FRIDAY

  • Bell Ringer: Con't work Lesson 9 Projects