Description

Build organized and presentable models with these essential formatting tools.

Learning Objectives


  1. Identify the steps to change the font style and size in Excel using the ribbon and accelerator shortcuts.
  2. Apply the methods to adjust cell borders and fill colors to enhance the visual presentation of data in Excel.
  3. Determine the appropriate alignment settings for different types of data to ensure consistency and readability in Excel worksheets.
  4. Use Excel's formatting options to correctly display numbers, including percentages, currency, and dates.
  5. Analyze the use of standard formatting styles in financial models to distinguish between hardcoded figures, assumptions, calculations, and linked cells. "