Question about Microsoft Computers & Internet

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

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

2 Answers

Forgot excel file password would you suggest how to break or recover the file


hai sir i want X12-30263 this ms office 2007 cd key pls send sir

Jun 23, 2009 | Microsoft Computers & Internet

1 Answer

Speed of excel is v slow


you are using microsoft office 2007 version. it need 1.5 GB ram. how much ram in your system?

Jan 26, 2009 | Compaq Presario 5000 PC Desktop

1 Answer

Windows email


IS YOUR EXCEL 2003 OR 2007. I WILL TRY MS OFFICE 2007
BECAUSE VISTA SOMETIMES HAVE PROBLEM READING SOME PROGRAM IN MS OFFICE IN 2003. EVEN WORD 2003 SOMETIMES HAVE PROBLEM IN VISTA. DEPAND ON THE COPY YOU INSTALL. I HAD PROBLEM WITH IT SO MANY TIMES

GOOD LUCK

Jul 13, 2008 | Toshiba Satellite A105 Notebook

2 Answers

Excel 2007 (Exporting info from MRI)


I suggest that you should you Office 2003 much better. office 2007 has a very hard time to use, even if its user friendly. but i dont waste time just to configure such DELICATE Problems like office 2007. if theres any problem just contact me sir/mam. thanks!

Mar 27, 2008 | Computers & Internet

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?
Computers & Internet Logo

Related Topics:

241 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18344 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...