HomeHome SearchSearch MenuMenu Our productsOur products

Three tips and tricks to make Excel accounting more efficient

by , 21 August 2014
If you're new to doing your accounting in Microsoft Excel, it can seem a bit daunting at first. After all, there are so many functions you can use to get the job done.

The good news is, once you master all those functions, you'll be an accounting pro. You'll be able to do your accounting faster and make it more accurate.

To help get you there, we're revealing three Excel tips and tricks to get you closer to mastering your company's accounting. All you have to do is read on and discover what they are...

 

Here are the three Excel tips and tricks to help turn you into an accounting pro

 
Tip 1: Here's how to work in selected cells without cancelling your selection:
 
To scroll down in the same column, press Enter;
To scroll up in the same column, press Shift + Enter;
To scroll horizontally in the same row (left to right), press Tab;
To scroll horizontally in the same row (right to left), press Tab +Shift keys simultaneously;
To increase the selection press Ctrl + (direction arrow key). 
To scroll through all the cells of a selection from top right in a clockwise direction, click Tab;
To scroll through all the cells of a selection from bottom right in an anti-clockwise direction, click Shift + Tab.
 
*********** Hot off the press  ************
 
 
*************************************
 

Tip 2: Use these shortcuts to change the size of selected cells: 

 
To insert adjacent cells to the right, hold Shift (or F8) and press the right arrow;
To insert adjacent cells to the left, hold Shift (or F8) and press the left arrow;
To insert cells above the existing selection, hold down Shift (or F8) and press the up arrow;
To insert cells below the existing selection, hold down Shift (or F8) and press the down arrow.
 
Tip 3: Here's how to introduce validate text
 
Select the cell you want to validate. 
 
On the 'Data' tab, in the 'Data Tools' group, click 'Data Validation'; 
In the 'Data Validation' dialog box, click the 'Settings' tab;
Click on the 'Custom' box, then select 'List' from the drop-down menu; and
In the 'Formula' field, type in = ISTEXT and type the (first cell in the selection). Then click 'Okay'.
 
There you have it. Three simple tips that can help you use your Excel accounting faster and more effectively.
 


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