Get started Bring yourself up to speed with our introductory content.

Do you know the basics of using Excel for accounting?

Performing accounting in Excel can be a breeze if you know key commands and shortcuts. Take our quiz to see if you know the basics.

From the days of the abacus to the introduction of the calculator, technology has turned numbers into information more quickly. In this effort, Microsoft Excel has long been a favorite.

With the advent of financial accounting software, however, using Excel for accounting and finance may be falling out of vogue. Yet that doesn't mean the tried and true electronic spreadsheet is obsolete. From graph features to ease of use, there are still a lot of features that make using Excel for accounting the best option for some organizations.

Do you know some of the basic features to use Excel for accounting purposes? Take our brief quiz to find out!

Next Steps

Why you may want to use Alt + Enter instead of Wrap Text

How the IF statement in Excel could save you money

Discover how to find the largest number in a spreadsheet using the LARGE function

This was last published in August 2016

PRO+

Content

Find more PRO+ content and other member only offers, here.

Essential Guide

A guide to using Excel as financial accounting software

Join the conversation

3 comments

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

What pros and cons have you found to using Excel for accounting purposes?
Cancel

QUESTION 4

This doesn't make sense....

Which of the following commands allows users to close the selected Excel workbook window?

  • Ctrl + C
  • Ctrl + F2
  • Ctrl + K
  • Ctrl + Shift + %

YOUR ANSWER - undefined
CORRECT ANSWER - Ctrl + Shift + % 

Answer: D. Ctrl + C copies selected cells. Ctrl + F2 opens print options. Ctrl + K allows users to insert a hyperlink. Ctrl + Shift + % applies the Percentage format with no decimal places.

Cancel
Thank you jason00zero for calling this to our attention!
Cancel

-ADS BY GOOGLE

SearchOracle

SearchCRM

SearchSAP

SearchBusinessAnalytics

SearchSQLServer

SearchContentManagement

SearchHRSoftware

Close