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

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

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

2 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

1 Answer

OBII NOT READY SANTA FE


What state are you? can you go to the referee.? The monitor on a Hyundai dont set easy to begine with Give me your state

Feb 28, 2012 | 2001 Hyundai Santa Fe

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?
Microsoft Excel for PC Logo

Related Topics:

94 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18386 Answers

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

Answer questions

Manuals & User Guides

Loading...