Question about Microsoft Excel for PC

1 Answer

I can not use Pivot Table are it difficult?

I want to creat table which contents Four subjects examinations and 100 student appears for it in five languages in seven cities. I want report and totals of each category like How many students appear in which subject examination, which language in one city.

npbhoge@rediffmail.com

Posted by on

  • Anonymous Aug 10, 2008

    i want to know to how to prepare the pivot table...

  • Anonymous Mar 20, 2014

    I need a template for Officemax Table of Contents OM96172 so I can print

×

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 397 Answers

You may be able to find what you want here:
http://www.usd.edu/trio/tut/excel/

Posted on Aug 10, 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

How can I create a bulleted two column list within a resume document?


This requires you to create a table. Look for a Table menu or menu item in the Format menu. You'll need to tell it you want two columns and five rows in the table. After you've inserted the items you can then highlight everything in the table and right click to choose bullets from bullets and numbering from the format option.

Oct 04, 2015 | Computers & Internet

1 Answer

Need help to recover with my accounting and math subject as I am very week in these subject.


hi, go to your library and see if they have any books there which may help you. "hsc essentials business studies" by clive a lincoln & michael lembach oxford university press, melbourne, 1994 pp48-57 could be helpful.
if you are able to find past past examination questions you should try to answer these using information in your text books and other reference books.
i was once in a similar situation, having missed very many classes and having done no reading at all in a particular subject for the dip a.i.i. i got hold of the past five years examination questions for the course. the weekend before the final examination i assumed that i was the person preparing the examination paper for the current year's examination. then looking at the course syllabus and the questions asked in the previous five years i prepared questions for the current year. i then studied and tried to answer these questions that i had prepared during the entire weekend. luckily the questions i had created and learned to answer covered the areas that were questioned in that final examination. i gained a high distinction in that paper.

Jan 21, 2015 | Computers & Internet

1 Answer

I am trying to create a pivot table. How can I define to sum of the each field that I grouped ...


Hi

Here are a couple of solutions

Solution A
-click a cell on your active pivot,
-right click, check "grand total for columns" / "rand total for rows"


Solution B
-click on tools customize
-check box "pivot table"
-click on the Pivot Table Tab, down arrow,
-click on Subtotals


regards,
=)

Jan 03, 2011 | ComponentOne VSVIEW Reporting Edition 8.0...

1 Answer

DAO in vb


Nice try. Find an upper-class student to give you one-on-one tutoring with your homework.

Apr 16, 2009 | Computers & Internet

1 Answer

Application and example of relationship in access


Relationships

After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

Having met the criteria above, follow these steps for creating relationships between tables.
  1. In the database window view, at the top, click on Tools ---> Relationships
  2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
  3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
    relationshipdrag.jpg
  4. Select Enforce Referential Integrity
    refintegrity.jpg
    • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
    • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
  5. Click Create and Save the Relationship

Apr 09, 2009 | Microsoft Computers & Internet

1 Answer

After installing DB2 query is not executing


could you check whether you are connected to the database, where you are trying to create table,

check the database list, then connect to the database you want then execute the table creation ddl,
if no db found then create a database then proceed.

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

Data for excel chart


You need to create subtotals so that it looks like something like this:

Prod/units Amt. Level Total

xxxx 10.00 1
yyyy 20.00 1
30.00

dddd 40.00 2
ffff 30.00 2
70.00

etc.

To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.

If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.

Some reading:
http://www.ehow.com/how_13020_pivot-table-wizard.html
http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

Also Google "Excel pivot table wizard" to get more.

Good luck!

Feb 23, 2008 | Microsoft Office Standard for PC

1 Answer

Excel Pivot view


Highlight the entire pivot table and name it as a range. Then in the formula, replace the reference to the table addresses with the range name. Then wherever you move the table (move, not cut and paste) it will automatically gather the right data. Thanks for rating FixYa!

Oct 19, 2007 | Microsoft Office Standard for PC

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

128 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

18385 Answers

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

Answer questions

Manuals & User Guides

Loading...