Question about Microsoft Excel for PC

1 Answer

EXCEL MIS EXCEL want to prepare MIS for Insurance Sector which will include Region, State, Month, Cumulative, Quarter, YTD etc

Posted by on

  • Anonymous Aug 20, 2008

    I cant open ex because version 1.0 in my PC

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 132 Answers

When you say prepare . .
What data is going in - and what needs to come out ?

At the moment - it looks like you just need standard coloumn control...
From the standard input columns do you need to break the data down into specifics (Ie time frames etc...which will incorporate cumulatives..)
I would personally suggest using MS Access - you will have greater control and GUI to minimize accidental deletion etc..

Posted on Aug 18, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Hi I have an excel question. Here is what I need to do. I need to do a sales analysis YTD with several different project types that I need to split up over which month the sale was taken in.


it will take too long to explain and then the explanation may not cover your question
go out and buy a "excel for dummies" book and all the processes that excel can do is explained
or go google and type in--- user manual for excel -- and see if there is a pdf version for down load
if there is it could be several hundred pages long but you could select the pages relevant and print them only

Oct 26, 2016 | The Business & Productivity Software

3 Answers

How do i recover my corrupted MS Excel File ....???


Using proper locations to keep your office documents and making regular backups are great preventive measures against data loss. If you've lost a document or the whole bunch of them, do not despair. Modern data recovery tools can reliably detect, locate and restore documents even if they are stored on a badly damaged, corrupted, formatted or repartitioned hard drive or other storage media.

Use Hetman Office Recovery for recovering your corrupted MS Excel file: https://hetmanrecovery.com/recover_deleted_document/office-software.htm

Oct 17, 2016 | Business & Productivity Software

5 Answers

How to repair damage excel file


Use Excel Repair Toolbox designed to restore data from corrupted .XLS files. MS Office .XLS file repair software can fix many error.
For more: https://www.xlsrepairtoolbox.com/

Jul 14, 2015 | Microsoft Excel for PC

1 Answer

I want to install microsoft word excel in my computer free


You will not be able to legally obtain Microsoft Excel without cost, however you can download and install OpenOffice for free and that includes a component that functions just like Excel and can open Excel documents, as well as Word etc.
http://www.openoffice.org/

Oct 30, 2010 | Microsoft Excel 2003 (065-03992) for PC

1 Answer

Windows Installer pops up everytime I open Access, Excel ..etc.


your applications didn't full instalations..try to reinstal n upgrade your software..

Apr 06, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

I want the excel attendence sheet how to prepare with help of


here are some templates to get you started

http://office.microsoft.com/en-us/templates/CT101172771033.aspx

Feb 21, 2009 | Microsoft Excel for PC

4 Answers

I want the excel compound interest formula


=10000*(1+0.96)^12
=10000*(1+0.10)^18
=10000*(1+0.10)^24

Dec 02, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Excel report


Depending on what you are doing, you either are presenting data or a chart, pivot table. Those have to be prepared within Excel to produce the report.

Jul 21, 2008 | Microsoft Business & Productivity Software

1 Answer

Horizontal


Not sure if I get your problem. Do you mean the SUM() formula with the row does not work?
That is the simplest solution if you are entering the monthly numbers per month.

If you have all these values and need to sum them up based on the current month, you need to use the MONTH() with the NOW() formulas to get a month offset and use a relative reference for the SUM() formula.

Jun 23, 2008 | Microsoft Excel for PC

1 Answer

Excel


Prepare table having coloumns Client, Premium Amount , Month.

 

Now take Pivot table of the above table. Take Field 'Month' in Page field and Client in 'Row' field and sum of amount in 'Data field'.

 

If you refresh the data and select the required month you will get the desired information.

 

 

 

Sep 11, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

92 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

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

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

Answer questions

Manuals & User Guides

Loading...