Had a good interaction in class yesterday showing a PivotTable activity with Excel. What are your top functions/formulas to integrate into class? Anything beyond Excel you include?
11 Views
Had a good interaction in class yesterday showing a PivotTable activity with Excel. What are your top functions/formulas to integrate into class? Anything beyond Excel you include?
I was storing the data in Access data base (where i could run a serie of querry to do data integrity check and populate data hierarchies) then I was using excel pivots to do analysis and reports