Because of its flexibility and integration, Confluence is the go-to tool for developers and business users. However, with such a great tool, managing spreadsheets comes with its own drawback. Excellentable makes it easy to create and maintain spreadsheets inside confluence.
Let’s face it, a good spreadsheet isn’t created just once. If your spreadsheet is good, you will be asked to create it again, and you will need to draw comparisons from last time around as well.
Figure 1 Multi-sheet spreadsheets in confluence
Everyone has at least one horror story of completing the work, but data was not saved. While Excellentable stores data in drafts, it is also important to use save at multiple points in your work. This allows you to go back to a previous version at any time.
Some of the best points to save a spreadsheet (and create a version) are:
Figure 2 Version History in Confluence Spreadsheets
With great spreadsheets come great responsibilities. However, everyone has a different approach to responsibility. A great tool to use is data validation and conditional formatting. Data validation will help users guide the correct data, highlight/disallow incorrect data, and give clear messages to the user. Similarly, conditional formatting is great at highlighting some of the key elements of users.
Some key features that you need in data validation include:
Figure 3 Conditional Formatting in Confluence Spreadsheets
Most spreadsheets are better when they present clear and concise data and calculations. For example, do not create unnecessary line breaks, adjust Row/column sizes too much, hide calculations that will make the spreadsheet simpler. A simpler spreadsheet that presents data in a clear way is much better than a complex one that will generate a lot of questions.
After publishing a great spreadsheet, you will inevitably get a lot of emails to showcase some view to your colleagues. Excellentable allows you to create your own views (Search or sort) in the view mode, and share them with users in your team at the click of a button.
Figure 4 Share a Spreadsheet in Confluence