Does any one know of any great forums for....

[photo_angel2004]

Hello,
Strange question I know. But there are a lot of people here that use other forums.

I am wondering if anyone knows of any really good forums for Miscrosoft Office programs like Excel?

I am finding that with the new job there are new chalenges and even though I have used Excel for years now I am finding that the program does even more then I thought it did and I am a bit lost of some of the advanced setting, formulas and tools and formating with excel.

I have been searching for a couple of hours with no real help as of yet.

If any one knows if this kind of forum please let me know.

(not even the text books that I have seem to have the answeres I am looking for,)

Thank you,

[soup]

I have never used them but have you looked these over.

http://www.excelforum.com/

http://www.msfn.org/board/index.php?showforum=120

[Chewy]

http://www.microsoft.com/communities/newsgroups/default.mspx

the best way is set outlook express up and subscribe to the newsgroup

it don't get any better than msmvp's, they email the guys writting the programs

[photo_angel2004]

Thanks for the links guys,
I am on my way to understanding it all know LOL

I just couldnt belive that after passing the Microsoft certification tests that there is still much more that isnt in the text books. I think I need to find an advanced level book or somthing. This one forum seems to be good I am registered now.

Thank you for the help.

Carla

[blutach]

When you figure out Pivot tables, please explain them to me!

Regards

[jamoskeag3]

PA, maybe this is too basic for you, but i have always found the QUE books quite helpful, at least for my purposes.

[photo_angel2004]

I have 7 college text books on the Microsoft Office programs on my desk.

The stuff I am looking for aint in these. LOL

The books I have are from beginner to advanced.
Enough to get the MS Office certification.

But there are much more advanced features to the prog's now I am in need of the Expert level text books and the help of that Excel forum is great.

Thank Jamo though.

@Blu
When I get it all mastered I will tell ya how. LOL

[jm1647]

There is this site for just excel tips and they have a section just for pivot tables.

http://www.exceltip.com/exceltips.php?view=category&ID=32

[a2j3]

Here is how my husband explained it 2 me. Not that I totally understand it all, but he simply clicked copied and pasted this info for me. He uses this program everyday. Hope maybe this will help at least a little??

1. A PivotTable report is an interactive table that quickly combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the details for areas of interest.

2. In a PivotTable report, each column or field in your source data becomes a PivotTable field that summarizes multiple rows of information. In the example above, the Sport column becomes the Sport field, and each record for Golf is summarized in a single Golf item.
A data field, such as Sum of Sales, provides the values to be summarized. Cell F3 in the report above contains the sum of the Sales value from every row in the source data for which the Sport column contains Golf and the Quarter column contains Qtr3.

3. To create a PivotTable report, you run the PivotTable and PivotChart Wizard. In the wizard, you select the source data you want from your worksheet list or external database. The wizard then provides you with a worksheet area for the report and a list of the available fields. As you drag the fields from the list window to the outlined areas, Microsoft Excel summarizes and calculates the report for you automatically.
If you're using an Office Data Connection to retrieve external data for your report, you can return the data directly to a PivotTable report, without running the PivotTable and PivotChart Wizard. Office Data Connections are the recommended method of retrieving external data for your reports when you don't need to combine data from more than one table in the external database or filter the data to select specific records before creating the report, and for retrieving data from OLAP databases.

After you create a PivotTable report, you can customize it to focus on the information you want: change the layout, change the format, or drill down to display more detailed data.