Do you have more than one discount level depending on volume or quantity? The Simple Excel Volume Discount Tool can help you automatically calculate up to three different volume discount levels. The Simple Excel Volume… Read More »Volume Discounts – Nested IF Statements
Moving into the second half of this Spreadsheets vs Database contest we look at how to restrict user access by using logins and setting access levels. That is, allowing certain people to see certain things, but not others.
This is about keeping our more sensitive information secure and private, such as payroll or customer information. In addition, restricting access based on a user’s logon priviledges can also be helpful in keeping software simple to use as the user is not presented with too many options at once.
Round 6: Restricting Access by User Logon Priviledges
Within Microsoft Excel it is possible to set a password for the entire workbook (or file). Using that in combination with the individual cell properties it is possible to make certain cells read-only, therefore blocking the user from making any alterations to that cell.
You can also hide columns, rows and worksheets with a workbook. This means that you can hide certain aspects of the spreadsheet. However, with the single password you can undo all these preventative measures and make hidden elements visible again.Read More »Spreadsheets vs Databases – Round 6: Restricting Access by Logon
In version 2.0 of the Working Data VAT Calculator, we have made it even easier to remove VAT from, or add VAT to, several numbers at the one time. The quick and easy-to-follow instructions below… Read More »How to Remove VAT or Add VAT with the VAT Calculator v2.0
The Working Data VAT Calculator can add and subtract VAT at 17.5% or 20%, for as many items/lines as you want. Continue reading for a quick overview on how to use the VAT Calculator or… Read More »VAT Calculator – Adding VAT and Removing VAT – Free Download
Want to know which of your suppliers products you are selling the most of? If you’ve got a long list of sales in your spreadsheet, it might seem obvious how to pull out that information.… Read More »How to find number of sales, sales value and average sale by supplier