MODULE 2.1

Microsoft Excel 2016

Module 2: Formatting Workbook Text and Data

Module Objectives

  • Change fonts, font style, and font color
  • Add fill colors and a background image
  • Create formulas to calculate sales data

Formatting Cell Text

  1. WATCH AND DO THIS VIDEO OVER PAGES EX65 to EX72–Show me before moving on to the next video

Working with Fill Colors and Backgrounds

  1. WATCH AND DO THIS VIDEO OVER PAGES EX72 to EX75–Show me before moving on to the next video

Using Functions and Formulas to Calculate Sales Data

  1. WATCH AND DO THIS VIDEO OVER PAGES EX75 to EX79–Show me before moving on to the next video