In this video, I demonstrate how to create a scrollable table in Excel. This might be useful in the context of a dashboard where you do not have the space to display the whole table and only want to display, say, ten rows at a time. Download the featured file here. Here are the steps… Read More »Create a Scrolling Table in Excel
Download the featured file here. In this video I demonstrate how to convert European formatted numbers to UK format. For example in the data displayed below the thousand separator is a full-stop and the decimal separator is a comma. For a UK format we would want these the other way around – comma for decimal… Read More »How to Convert Comma to Decimal Point & Dot to Comma in Excel
In this video I demonstrate how increase or decrease a value by a specified percentage. These types of calculations are useful when adding VAT or markup or applying a discount. You can download the featured file here.