How to Use Microsoft Excel for Accounting. Microsoft Office Excel was designed to support accounting functions such as budgeting, preparing financial statements and creating balance sheets.