HomeHome SearchSearch MenuMenu Our productsOur products

Is bookkeeping driving you batty? These three smart Excel tips will help

by , 19 June 2014
When it comes to doing your books, the old pen and paper method is too time consuming. But, Excel on the other hand, can be really complicated. It's enough to drive you mad.

But there are lots of benefits of using Excel that you won't get with pen and paper. Benefits such as, easy record storage, the ability to move the information around from one record to another, and you and your managers can all have access to the records without fighting over a single book.

It ensures you get the most out of your Excel bookkeeping, here are three Excel tips to make the process easier...

*********** Top rated product  ***************
Attention accountants and bookkeepers! 
 
Stop wasting hours trying to figure out a solution to your Excel problem 
 
If you turned to Google for help, you would have had to search through over 144 000 000 Excel related pages to find an answer to your specific Excel problem... That's hours wasted trying to find a solution to one Excel question!
 
*****************************************

Excel can turn you into a master at bookkeeping

The beauty of Excel is just how flexible it is to use. If you do your books with good old pen and paper, you can't instantly sort, back space or transfer the data.
 
Excel gives you the ability to do all of these things. But to make the most of Excel, you need to know all the tips and tricks. By tips and tricks, I mean function or formulas. Excel functions can be tricky but also incredibly useful. 
 
To help you master some of the most important functions use these three Excel function tips…
 

Make bookkeeping with Excel easier with these three tips

Tip 1: You can use the Microsoft Excel IF Function to sort lots of data all at once. Microsoft.com gives this example of the formula for the IF function: 'IF(logical_test, [value_if_true], [value_if_false])'. 
 
This means is if a value is one thing (true), Excel will sort it to one place. If it's another thing (false), it'll sort it to a different place.
 
Tip 2: You can use the Excel Left function to select the first few numbers of letters in a cell. This means you can make your sorting very specific. 
 
Tip 3: You can use the Excel Lookup function to quickly move data from your general ledger to your income statement.
 
If you use these functions in your Excel bookkeeping, you'll be able to keep perfect accounting records every time. 


Related articles




Related articles



Related Products



Comments
0 comments


Recommended for You 

  Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance



Here are all the most interesting, thought-provoking and common tax questions
asked by our subscribers over the last tax year – everything from A to Z!

To download Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance click here now >>>
  Employees always sick? How to stop it today



Make sure you develop a leave policy to regulate sick leave in your company.

BONUS! You'll find an example of the leave policy and procedure in this report.

To download Employees always sick? How to stop it today click here now >>>
  Absenteeism: Little known ways to reduce absenteeism



This FREE e-report will tell you how you can reduce absenteeism in your workplace while avoiding the CCMA and without infringing your employees' labour rights.

To download Absenteeism: Little known ways to reduce absenteeism click here now >>>
  7 Health & safety strategies to save you thousands



Don't let a health and safety incident cost you one more cent. Implement these seven
strategies in your company today.

To download 7 Health & safety strategies to save you thousands click here now >>>