HomeHome SearchSearch MenuMenu Our productsOur products

Use these three tricks to simplify your accounting process in Excel

by , 04 November 2014
If you've just switched your accounting system over to Excel, you might be feeling a little frustrated at this point. After all, getting used to a new system can take time. But don't despair.

We're here to help you become an Excel accounting expert in no time.

That's why today we're here to give your three Excel tricks that will simplify your accounting process and help you get it done easily and quickly...

 

Get your Excel accounting processes done quickly with these three Excel tricks

 
1. Use Auto-format to generate a standard format for your accounting records. AutoFormat allows you to choose a predefined format for the data in a table. The predefined format refers to:
The font;
The height and width of the cell;
The cell colour;
Text alignment; and
Borders.
 
This will help you save time if you don't feel like fussing around with creating a basic format. 
 
*********** Advertisement ************
 
Simple Excel solutions to do your complex calculations in minutes!
 
Want to fix Excel problems in the shortest amount of time? Don't have time to devote to Excel? Click here for more
 
Discover the Excel functions and formulas you need right now to reduce stressful and tiring work within minutes of data processing. The Practical Guide to Excel gives you everything you need to work quickly, efficiently and without stress.
 
 
***********************************
 
2. Create a personal formatting style for tables when you want a specific format for your accounting records. This will help you save the time you would have spent changing the format manually.
 
To create this, select the table you want to format. Then click 'Home' => 'Format as table' => 'New Table Style'. A dialogue box will open for the 'New Table Quick Style'
 
In this box you can choose specifics for:
Text formatting;
Borders; and
Cell colour.
 
3. Use conditional formatting for specific areas in your accounting records. You can, for example, format your data in different colours so you can look at the data and make immediate sense of it. For example, you could use conditional formatting to put all expenses above R5 000 in red. 
 
Use these three Excel tricks to simplify your accounting process so you don't waste time creating different formats.
 
Check out the Practical Guide to Excel for more useful Excel accounting tips and tricks.
 


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