Category Archives: Excel Templates

Annual Expense Report with conditional text settings on Excel spreadsheet

Combination of different conditional text settings Download: Annual Expense Report File format: Excel How to change conditional formatting Select the cells you want to change. On the Home tab, click Conditional Formatting. (It’s in the Styles section) Click Manage Rule from the drop-down menu. How to use the Excel template Enter values in each of […]

Annual Expense Report with Traffic Lights on Excel spreadsheet

Traffic lights on excel spreadsheet Download: Annual Expense Report File format: Excel How to change conditional formatting Select the cells you want to change. On the Home tab, click Conditional Formatting. (It’s in the Styles section) Click Manage Rule from the drop-down menu. How to use the Excel template Enter values in each of the […]

Annual Report spreadsheet with directional settings applied to data

Annual report spreadsheet with directional settings applied to data Download: Annual Expense Report File format: Excel How to change conditional formatting Select the cells you want to change. On the Home tab, click Conditional Formatting. (It’s in the Styles section) Click Manage Rule from the drop-down menu. How to use the Excel template Enter values […]

Annual Expense Report with Data Bars – Excel

Annual report with data bars Download: Annual Expense Report File format: Excel How to change conditional formatting Select the cells you want to change. On the Home tab, click Conditional Formatting. (It’s in the Styles section) Click Manage Rule from the drop-down menu. How to use the Excel template Enter values in each of the […]

Annual Expense Report – Blended gradients chart data – Excel

Blended gradients applied to the charts Download: Annual Expense Report File format: Excel How to change conditional formatting Select the cells you want to change. On the Home tab, click Conditional Formatting. (It’s in the Styles section) Click Manage Rule from the drop-down menu. How to use the Excel template Enter values in each of […]