Navigation

We often come across Excel documents that have multiple reports found in several worksheets. If you want to find the report you want, click on the tab with the name of the corresponding worksheet. However, this is not always the optimal solution. In order to facilitate positioning on the desired report, we introduce links that we have attached to certain forms. That is, we introduce a navigation panel to navigate within the document.

Birthday cake

“Birthday Cake” is a way of combining Stacked Column Chart, shapes and images to, with a little extra formatting, get a graphic report reminiscent of a birthday cake with candles. It can be used e.g. to show the growth of income or profit of the company over a period of several years. This kind of chart is very easy to make, so if you want to attract the attention of bosses and colleagues, pay attention and follow the steps shown.

SmartArt

Flowchart diagrams can be made manually, by embedding and connecting different shapes. Also, we can make them based on some of the templates that come with Excel, and it belongs to the SmartArt schema group. SmartArt schemes are nothing more than diagram templates, created by creating and grouping objects. If you are well acquainted with them, they can greatly facilitate your work and shorten the time when making a diagram.

Formatting objects

Since version 2007, Excel has been enriched with a wealth of options for “beautifying” reports, and from version to version it offers more of these functionalities that can be applied to the formatting of all graphic objects, whether these are charts or their elements, images, shapes, schemes … The following text will show how the appearance of the graphic object can change: its body, frames, the use of special formatting styles …

Adding shapes

Excel has a large number of shapes (rectangles, ellipses, arrows, triangles, etc.) held into groups that we can use to illustrate a flowchart, process, hierarchy, organizational scheme … Excel can significantly replace Visio, whose purpose is to draw various diagrams, and allow us to display them in the report, and the text that follows will describe the ways they are added and edited.