HomeHome SearchSearch MenuMenu Our productsOur products

This one piece of Excel accounting information will turn you into a pro

by , 21 August 2014
If you feel like your Excel accounting takes you longer than the old book and pen method, it's just because you still need to get familiar with all the formulas and functions.

Once you are, you won't have any problems with your Excel accounting. In fact, you'll start to wonder how you ever managed with that old paper and pen.

But first, you have to get to grips with Excel and all its wonderful tools. That's why we're revealing one piece of information that'll help turn you into an accounting pro...

 

One piece of information that'll turn you into an Excel accounting pro

 
This one piece of information is about how to filter your accounting data. You may think: 'What's the big deal about filtering data?'
 
Well this one bit of information can save you hours that you'd have spent trying to find the right information to transfer into different books.
 
This means you can create your journals, ledges and budgets in record time.
 
Here's how to use data filtering in your Microsoft Excel spreadsheet.
 
*********** Best seller  *************
 
 
*********************************
 

Here's how to use data filtering in your Excel accounting

 
When you filter a data selection, you'll see a little arrow in the top right hand side of the selection. You can select any cell in the table and use one of the three following options to filter the data:
 
1. Press Ctrl + Shift + L;
2. Click 'Data' and then click 'Filter'; or
3. Click 'Home', the click 'Editing', and lastly click 'Sort & Filter'.
 
It's that easy to filter your accounting data. This will enable to you view exactly the information you need instead of having to look for it.
 
Now you're one step closer to being an Excel accounting pro.
 


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 >>>