Displaying 1 through 12 of 12. Subscribe:

I need to provide some sales data but am unsure how to manipulate the data in a pivot table to get the specific details requested. I'm sure this is simple but my pivot table skills are, admittedly, terrible. Details inside. [more inside]

How to reformat pivot table data so that it works like any other spreadsheet? Simple instructions needed. [more inside]

How can I reformat some rows into columns in Excel? [more inside]

Microsoft Access 2007 - how on earth do I cut / copy / export / do *anything* with my Pivot Chart, besides print it? [more inside]

Why is the functionality of an Excel Pivot table different depending on whether you use a list or a multiple consolidation range? [more inside]

I'm trying to teach myself to be an Excel guru, and I'm having trouble with pivot tables. I'm using data from exercises in a textbook (which is about how information systems are used in business but randomly has a bunch of Excel exercises in the back). I can come up with a solution, but I don't know if I'm doing it the most efficient (or most elegant) way. [more inside]

Excel - Pivoting With Dates [more inside]

How can I have Excel generate a new column with the data I need using certain conditions and pulling data from a pivot table? [more inside]

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column? [more inside]

How to do a VBA version of the following array formula in Excel?
The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA:
{="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)}
[more inside]

Excel Filter: Concatenating fields through VLOOKUP. Is it possible? What I'm trying to accomplish inside... [more inside]

Help me with creating two bar charts from two columns in one pivot table, please? [more inside]

Page:
1