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

Ad

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

Ad

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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

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?

Open Questions:

0 Answers

What is Microsoft office applications? Microsoft office is a set of interrelated desktop applications, servers, and services, collectively referred to as an office suite, for Microsoft Word: a word processor included in Microsoft Office and some editions of the now-discontinued Microsoft Works Microsoft Windows and macOS operating systems. Microsoft Excel: a spreadsheet. Microsoft released the first version of Excel for the Mac OS in 1985, and the first Windows version (numbered 2.05 to line up with the Mac) in November 1987. Microsoft PowerPoint: a presentation program used to create slideshows composed of text, graphics, and other objects, which can be displayed on-screen and shown by the presenter or printed out on slides. Microsoft Access: a database management system for Windows that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. Microsoft Access stores data in its own format based on the Access Jet Database Engine. Microsoft Outlook: a personal information manager that replaces Windows starting in Office 97, it includes an e-mail client, calendar, task manager and address book. Microsoft OneNote: a notetaking program that gathers handwritten or typed notes, drawings, and audio commentaries. Notes can be shared with other OneNote users over the Internet or a network. Microsoft Publisher: a desktop publishing app for Windows mostly used for designing brochures, labels, calendars, greeting cards, business cards, newsletters, website, and postcards. Microsoft Project: a project management app for Windows to keep track of events and to create network charts and Gantt charts, not bundled in any Office suite. Microsoft Visio: a diagram and flowcharting app for Windows not bundled in any Office suite

Dec 28, 2017 | Microsoft Computers & Internet

Computers & Internet Logo

Related Topics:

243 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2905 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18411 Answers

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

Answer questions

Manuals & User Guides

Loading...