Advanced Formatting in Excel - Report Making

In this segment, you will give a finishing touch to the report using borders, formatting borders, wrap text and a few other formatting options. 

Borders

In a report containing hospital charges data from multiple states / regions, good readability  means that the reader can easily identify the various states and the sub-regions within them. You'll learn to do that using borders. Borders will help demarcate different sections of the report.

Next, you'll see that it is also possible to create borders manually. This becomes helpful when you want to draw borders only on certain cells which are staggered or do not fall in a pattern where the conventional borders can be used.

Next, you'll learn another frequently used technique - wrap text, which is a way to use the available text space efficiently.

In the next short video, you'll learn some advanced formatting options to make the data much more presentable .

With this, you've reached the end of Report Making. You should now be able to create a well-formatted report for pretty much any sort of data.  Remember that a good report improves readability of important information and reduces the amount of time spent on reading and understanding the data.

In the next segment, you will learn a task which is frequently done wrong - printing an Excel report.