Monthly Archives: April 2019

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 […]

Annual Expense Report – Gradients applied to chart data – Excel

Gradients applied to the chart 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 in each of […]

Annual Expense Report – Conditional Text & Pie Chart – Excel

Annual expense report with conditional text and pie chart 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 […]