Advertisements

excel

  • Technology s a very important element in today’s society and no branch of society escapes the grasp of technology. Accounting is no exception and if you want to do your books you are going to need a program like Excel or else you’re just not going to be very efficient nowadays.  However, not a lot of people know how Excel can help them improve their accounting situation. Some people don’t have their own accountant and have to handle the accounting by themselves even though it’s not their primary attribute or concern within their context of work. Still, it doesn’t hurt to know these simple tricks that you can pull off with Excel in order to make accounting easier. Number formatting shortcuts Formatting can be a tricky business and often times it’s a very tedious process. That is, of course, if you don’t know how to use Excel’s formatting shortcuts to your advantage. If you don’t know about the formatting shortcuts, prepare to be amazed as you can use these to save precious time. Ctrl+Shift+1 – introduces two decimal places into your number formatting Ctrl+Shift+2 – Allows you to format your selection as time Ctrl+Shift+3 – Allows you to format your selection as a date Ctrl+Shift+4 – Allows you to format your selection as a currency Ctrl+Shift+5 – Allows you to format your selection as a percentage Ctrl+Shift+6 – Allows you to format your selection in exponential form Navigating through results Navigating through formulas and your cell data can be a very tedious task also and it can slowly eat away at your peace of mind. However, there is a simple solution for this. You can use a combination of two keys, specifically the Ctrl and tilde “~” combination in order to switch seamlessly between the two types of information. This...