Question about Computers & Internet

1 Answer

Excel How to use Pinot table in excel

Posted by on

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
  • 104 Answers

Hi, Pivot tables are quite complex but basically you have a table of data which you sort based on different fields from your table.

Send me your email address and I will email you further instructions with an attached example file ok.

Regards
SeaJade

Posted on Mar 07, 2008

  • Jade Rallings
    Jade Rallings Mar 07, 2008

    Email is, itsme77@bigpond.com

×

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

Properties in importing excel table to an access table


This article explains how to import a Microsoft Excel file into Microsoft Access version 2.0 or 7.0. Microsoft Access can import files from Microsoft Excel version 2.0 through version 7.0. However, Microsoft Access cannot import Microsoft Excel 4.0 workbooks (.xlw). This article assumes that the Microsoft Excel file is using standard database formatting. That is:

To import a Microsoft Excel file in Microsoft Access 2.0 loadTOCNode(2, 'moreinformation');
  1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.
  2. Start Microsoft Access 2.0 and open the database you want to import the Microsoft Excel information into.
  3. On the File menu, click Import. From the Import dialog box, choose the appropriate version of Microsoft Excel that you are importing and click the OK button. Microsoft Excel 7.0 files are not on this list. If you are importing a version 7.0 file, choose the Microsoft Excel 5.0 option.
At this point options such as whether to append to an existing table or create a new table may be selected.
To import a Microsoft Excel file in Microsoft Access 7.0 loadTOCNode(2, 'moreinformation');
  1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.
  2. Start Microsoft Access 7.0 and open the database you want to import the Microsoft Excel information into.
  3. On the File menu, click Get External Data and then click Import.
  4. From the import dialog box, choose Microsoft Excel (*.xls) for the Files Of Type option.

    This will display only the Microsoft Excel files.
  5. Find the desired file and click the Import button.
The Import Spreadsheet Wizard appears and allows you to choose options specific to the file.

or you just use the link for any problem where you can get details of the importing
http://www.techrepublic.com/article/techniques-for-successfully-importing-excel-data-into-access/5276622

May 05, 2011 | Computers & Internet

Tip

Copy PDF tables to excel?


"I have a national statistics book in PDF, it has a number of tables I want to work with in excel. So I paste all the colums and copy in Excel. However, the format is wrong, all colums in a single excel colum. How can i deal with it, any suggestion?"<br /><br />Are you also be troubled with the problem? Here share you an easy solution to solve it.<br /><br />The PDF to Excel Converter can convert PDF to Excel, convert PDF eBooks to Excel on Mac with more accurate-looking and highly-editable XLS files. There will be no need to reformat the converted Spreadsheets. PDF to Excel Converter for Mac makes it a clinch to re-use tables and spreadsheets from PDF files in Microsoft Excel.<br /><br />Get a <a href="http://www.doremisoft.com/pdf/pdf-to-excel-xls-converter-mac.html"><span style="font-weight: bold;">PDF to Excel Converter for Mac </span></a>users or <a href="http://www.doremisoft.com/pdf/pdf-to-excel-converter.html"><span style="font-weight: bold;">PDF to Excel Converter</span></a> on Windows OS<br /><br />Free download it and get a free try!<br />

on Nov 23, 2010 | Computers & Internet

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    How to export table in ms access to excel


    yes you can export your access data into excel, follow steps on how to export.

    1. open your access database
    2. open the table data you to export
    3. under table data view click tools menu
    4. select analyze
    5. select ms excel
    6. this will open your seleted access table in excel

    hope this will help you..

    Dec 13, 2008 | Microsoft Access 2002 for PC

    2 Answers

    Steps in saving file in excel to database


    severals solution :
    - save file as text separated by comma and use sqloader from oracle
    - use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
    - use ODBC from MicroSoft

    Dec 11, 2008 | Microsoft Computers & Internet

    2 Answers

    Microsoft office 2007 excel problem when i save excel files then i coulnd not save a file , because there some tmp error


    Hi,
    Just re-install the excel only using your ms office 2007. Once you put the installer on the drive it will give an option on what office you want to install, just select excel.
    Thanks

    Nov 25, 2008 | Microsoft Office Professional 2007 Full...

    5 Answers

    Microsoft office excel encountered error


    This problem may occur if a noncontiguous selection is included in any one of the following: • Sheet selection • AutoFilter • Publishing Excel data to a Web page • Conditional formatting • Pivot Table reference • Pivot Table area • Pivot Table location • Unknown XML

    it that does not work then goto control panel and reinstall office

    Jun 23, 2008 | Computers & Internet

    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

    4 Answers

    Running SQL queries on Excel


    Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
    hth

    Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

    Not finding what you are looking for?
    Computers & Internet Logo

    Related Topics:

    181 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Computers & Internet Experts

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

    kakima

    Level 3 Expert

    102366 Answers

    David Payne
    David Payne

    Level 3 Expert

    14161 Answers

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

    Answer questions

    Manuals & User Guides

    Loading...