Day 15 (Adv Apps)

Microsoft Excel 2016

Module 2: Formatting Workbook Text and Data

Module Objectives

  • Find and replace text and formatting
  • Change workbook themes
  • Highlight cells with conditional formats
  • Format a worksheet for printing
  • Set the print area, insert page breaks, add print titles, create headers and footers, and set margins

Finding and Replacing Text and Formats

  1. WATCH & DO THIS VIDEO OVER PAGE EX103 TO EX105–SHOW ME BEFORE CONTINUING

Working with Themes

  1. WATCH & DO THIS VIDEO OVER PAGE EX105 TO EX106–SHOW ME BEFORE CONTINUING

Highlighting Cells with Conditional Formats

  1. WATCH & DO THIS VIDEO OVER PAGE EX107 TO EX113–SHOW ME BEFORE CONTINUING

Formatting a Worksheet for Printing

  1. WATCH & DO THIS VIDEO OVER PAGE EX113 TO EX118–SHOW ME BEFORE CONTINUING
  2. WATCH & DO THIS VIDEO OVER PAGE EX119 TO EX122–PRINT–2-SIDED, FLIP ON THE LONG EDGE