Excel 2019: Merge, Wrap & Style Data

Course description

This course improves worksheet readability and organization in Microsoft Excel 2019 by teaching how to merge cells, wrap text, and apply professional formatting styles. Learners begin by exploring how and when to merge cells to create cleaner layouts, such as combining multiple cells for titles or labels without altering entire rows or columns. The lessons demonstrate different merge options including Merge and Center, Merge Across, and Unmerge Cells, explaining how each affects data placement and alignment. Learners also discover the limitations of merged cells and best practices for maintaining consistent worksheet structure. The course continues with wrapping text, showing how to make lengthy labels or descriptions visible within a single cell without resizing columns. Learners observe how wrapping behaves differently with text and numeric data, and how adjusting row height maintains visual balance. From there, the course introduces text orientation options, allowing learners to rotate or tilt data at specific angles for compact or stylistic presentation. Finally, the course examines the use of borders, shading, and fill colors to distinguish headers, totals, and categories. Learners practice adding outside and inside borders, customizing line styles and colors, and applying cell fills that complement font colors for clear visibility. By combining these features, participants learn to create worksheets that are visually structured, readable, and presentation-ready and usable.

Course outline