Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: Introduction to Formatting

via LinkedIn Learning

Overview

Syllabus

Introduction
  • Formatting tips to build compelling spreadsheets
1. Control Fonts, Borders, Cell Colors, and Alignment Options
  • Adjust fonts and cell colors
  • Apply border styles, gridlines, and underlining
  • Adjust horizontal and vertical cell alignment
2. Adjust Numeric Format
  • Work with numeric formatting options
  • Essential numeric formatting keystroke shortcuts
  • Set special formats for dates, times, and more
3. Accentuate Data with Conditional Formatting
  • Create value-based formatting using logical operators
  • Create value-based formatting using data bars, color scales, and icons
4. Row and Column Adjustments
  • Adjust one or more row heights and column widths without commands
  • Work with the hide/unhide options
5. Other Worksheet Formatting Tools
  • Work with tables
  • Use the Format Cells dialog box and the pop-up mini-toolbar
  • Copy formats with dragging techniques and Format Painter
Conclusion
  • Next steps

Taught by

Dennis Taylor

Reviews

4.7 rating at LinkedIn Learning based on 644 ratings

Start your review of Excel: Introduction to Formatting

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.