How do I open 2 Excel files in separate windows so I can view them side by side?
Category Archives: Excel
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 […]
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 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 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 […]
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 […]
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 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 […]
Annual expense report with conditional text and pie chart File format: Excel Download: Annual Expense Report How to update charts Enter values in each of the cells. Right-click on the chart. Refresh the data.
09
Dec
Dec
If you use Excel to coordinate software testing tasks, you’ll probably want to add Pass/Fail columns to track their status. In our Acceptance Criteria Log templates, we have a Pass/Fail column that lets you see at a glance the testing progress. If you are not used to Excel, if can be a bit confusing to […]
05
Nov
Nov
To create a new status indicator in Excel, follow these steps. This Excel tutorial explains how to use conditional formatting to add icons, such as progress bars, traffic lights, and ratings to a cell in Excel (with screenshots and step-by-step instructions). Click here for Excel business, software and testing templates. Video: Add Indicators, Shapes, and Ratings Automatically to Excel […]
