To find the D/E Ratio in Excel, put total liabilities and equity in two cells. Then divide liabilities by equity. Excel can also do this automatically with its finance templates, making it easy and accurate.