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 pallavi mane on

  • Anonymous Aug 20, 2008

    I cant open ex because version 1.0 in my PC

×

Ad

1 Answer

Anonymous

  • 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

Ad

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

Tip

Buy extra warranty on digital camera's with theft insurance/fallen insurance


When you by a digital camera ask if they shop offers a extra warranty plan that also includes theft, fallen damage, scratches etc. like dixons does.

the price to be paid is ussually low , a few dollars a month but the costs of repair are high:

here in holland a hour technician fee is 90 euro *approx 45 dollar"
investigation repairs (or price offers) are usually 60 - 150 euro depending of the product.

a screen repair cost approx 150,00 euro exclusive of transportation fees and administration fees.

so you see a few dollars a month can save valuable money later!

on May 25, 2008 | Nikon COOLPIX S200 Digital Camera

5 Answers

Motor insurance


Laws vary from country to country, state to state, and province to province. Your best course is to contact your current insurance carrier and ask.

Feb 05, 2013 | Cars & Trucks

2 Answers

Excel sheet help


You're covering a lot of ground there, but you should be able to use sorting and group selection, then cut and paste from your other programs, as well as keyboard shortcuts to save some time. There may even be some addins that will help you to organize the reports...but nothing can save you from data entry. There's definitely a steep learning curve involved...
It may be helpful for you to organize the logic and Hierarchy of the spreadsheet by hand on paper before you attempt to set it up on your system.
Google Excel tips and you'll find a plethora of info online to help you set it up right...(here's one) (or two)

I hope this information allows you to resolve this issue. If you need further assistance, please post back with a comment to this thread.
If I've managed to answer your question or solve a problem, please take just a moment to rate this post....thanks!

Jul 22, 2009 | Microsoft Excel 2007 Home and Student...

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

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

Just leased an 08 SS


I just leased my 2007 TBSS w/ 3SS, Safe and Sound, no sunroof, BOSE, no nav.
MSRP was $36k
Had a 2006 TBSS and did a 6 month pull ahead (turned it in and didn't have to pay the last 6 months of that lease).
GMAC had a $1k incentive on leases so that acted like a cap reduction payment.
No security since I was turning in a 2006.
Paid 1st and last month for a total of $885.
Monthly payment including state tax of $40 is $440.
Hope that helps.

May 14, 2008 | 2004 Chevrolet TrailBlazer

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?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

104 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Lee Hodgson
Lee Hodgson

Level 3 Expert

4810 Answers

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

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

Answer questions

Manuals & User Guides

Loading...