https://youtu.be/dnP1CpjKEBQ This video shows you how to create a progress bar for actual vs target percentage calculations in Excel. Excel's conditional formatting options include something called data bars. Data bars are normally used to compare values in a single column, so, for example, the smallest value has the smallest bar and the largest value the…
Read More
You may find it useful to embed or link to pdf documents within your Excel spreadsheet. For example, you have a list of products, personnel or properties, each record relating to an external document, in this case, a pdf document. The ability to display and link to the pdf document in a database is very…
Read More
This video shows you how to write a formula that calculates running or cumulative totals for sales or income. The formula uses the SUM function to calculate the running totals. As the formula is copied down the 'Running Total' column the range of cells that the SUM function performs a calculation on needs to increase…
Read More