Microsoft Excel 2016

Module 2: Formatting Workbook Text and Data

Module Objectives

  • Format numbers as currency and percentages
  • Format dates and times
  • Align, indent, and rotate cell contents
  • Merge a group of cells

Formatting Numbers

  1. WATCH AND DO THIS VIDEO OVER PAGES EX79 to EX83–Show me before moving on to the next video
  2. WATCH AND DO THIS VIDEO OVER PAGE EX83–Formatting Dates & Times–Show me before moving on to the next video

Formatting Worksheet Cells

  1. WATCH AND DO THIS VIDEO OVER PAGES EX84 to EX87–Show me before moving on to the next video
  2. WATCH AND DO THIS VIDEO OVER PAGES EX87 to EX89–Show me before moving on to the next video

Exploring the Format Cells Dialog Box

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