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

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 | Business & Productivity Software

1 Answer

Having troube with my FOREIGN KEYs on two tables.


I suggest you visit this website you will get the solution, I tried and it worked.

http://bit.ly/1bUVmuW

Nov 25, 2013 | Business & Productivity Software

1 Answer

I have been trying to get Microshaft word 2008 for Mac to start page numbers only on page 3. I have a title page, a table of contents, and then the body of my document. I have created a section at the...


1. Place cursor in each section in which you want hide the page number on the first page.
2. On the Insert menu, click Page Numbers.
3. Clear the "Show number on first page" check box.

You may have to create a separate section for your Table of Contents to suppress the page number on it.

Nov 17, 2009 | Microsoft Office 2008 for Mac: Mac

2 Answers

Table of Contents TOC 4 appears with heading numbers in bold which I don't want. TOC 1, TOC 2, TOC 3 & TOC 5 are all okay


You can easily modify the formatting for a TOC. You will need to replace the current TOC - I'm assuming you are using the built-in reference to create your TOC.


Select Insert / Reference / Index and Tables. Click on the "Table of Contents" tab.

Click on <Modify>. Click on "TOC 3". Click on <Modify>. Click on the Bold icon to unselect the Bold attribute. Click on <OK> three times.

Sep 08, 2009 | Microsoft Word 2003 for PC

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 Business & Productivity Software

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

126 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

18298 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...