Question about Microsoft Business & Productivity Software

1 Answer

Procedure how to establish aging of account receivable in excel

Sir,

I want to formulate a system of aging of account receivable in excel 2007 for our office,because it is hard to provide aging of account receivable manually..

Thank you in advance for a positive response of my concern..

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

Once your data has been input into Excel - I assume you can do this via importing an outstanding debtors deport.

The easiest way I can see is by Pivot Table.

Your data should include open invoices and their respective due dates, it will be easier if you could covert these due dates into months - Create a pivot entering customer, outstanding values as your data and due months as your range.

Posted on May 10, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Excel 2003 worksheet slow in 2007


Hi Lee, I have recently experienced the same thing. When Excel 2007 or later opens an Excel 97-2003 .xls file, there are major issues of speed. The file is opened in compatibility mode. The best thing to do would be to open the file, then save as (keep the same name if you like) an Excel 2007 .xlsx document (or .xlsm document if there are macros). Close the file, then reopen it, and the compatibility mode issue will be gone. You can now use the newly saved file as a normal Excel 2007 file. Hope this helped.

Mar 25, 2014 | Microsoft Office Professional 2007 Full...

1 Answer

What is the application of Microsoft excel 2007?


Excel is mainly used for Accounting.
In offices it is also used to draw up tables, graphs etc.
I think you can find plenty of sites to learn MS Excel in the Internet.

Sep 14, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

Sir when I double click on my excel file message coming '' there was a problem sending the command to the program '' I have windows 7


From the Windows Start menu, choose Run and enter
Excel.exe /regserver
This will cause Excel to start up, re-register all of its
registry keys, then quit. Now, try opening your Excel files.

May 06, 2010 | Microsoft Office Excel 2007 Full Version...

1 Answer

I want my clients' age to automatically calculate using Date of Birth. In previous versions of Works Database it was a simple formula, but I can't seem to replicate it in Office Excel 2007.


Its the same only the interface is different. Use the same technique of the Mathematical algorithm keeping in mind the way the date, time are displayed in their format. Also switch to 24 Hr mode....sodeep

Mar 20, 2009 | Microsoft Office Excel 2007

1 Answer

Excel


I want become Expert in Excel so plz help provide me some excel formule

Sep 18, 2008 | Microsoft Excel for PC

1 Answer

EXCEL TRAINING


This should help you a lot.
Just click on the link and it'll take you to excel online training.
http://office.microsoft.com/en-us/training/CR061831141033.aspx

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

3 Answers

Microsoft excel dose not open autometically


go to start then all programs then microsoft office look for excel click on it from there ok see if it works if not reinstall program and update it ok

Jan 23, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

How to formulate log function with excel


Here try this link

http://support.microsoft.com/kb/214116

Nov 12, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

241 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...