Excel CaseLesson 71Free preview
Case: Poke Mart, Styling
This lesson is part of Excel · All levels
Summary
The further part of the Poke Mart case study focused on the display: giving the header color, edge lines, format of money numbers, and the correct width of columns. The visual layout makes the report more readable without changing a single value. The settlement of this case closed the first part material with a presentable end result.
Key points
- Header format with bold, background color, and border
- Apply Currency format to price columns and total
- Adjust the width of the column and text wrap so that the text is not cut
- A neat view makes it easier for the reader to understand the report
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.