Excel Pivot Tables tutorial and FAQ
The tutorial points out the major pros and cons of using Excel crosstabs and includes a step by step guide on how to create a Microsoft Excel crosstab based on a real business data. There is also a guide on how to create OLAP cube in microsoft excel and a FAQ...
http://etl-tools.info/en/bi/excel_pivot_tables.htm
The tutorial points out the major pros and cons of using Excel crosstabs and includes a step by step guide on how to create a Microsoft Excel crosstab based on a real business data. There is also a guide on how to create OLAP cube in microsoft excel and a FAQ...http://etl-tools.info/en/bi/excel_pivot_tables.htm
Excel Pivot Tables
A high quality and detailed source of information on designing, maintaining and using Microsoft Excel Pivot Tables (Crosstabs, OLAP Cubes). It shows how to connect to a data source, use the data fields in a crosstab, perform custom calculations, subtotals,...
http://www.contextures.com/xlPivot01.html
A high quality and detailed source of information on designing, maintaining and using Microsoft Excel Pivot Tables (Crosstabs, OLAP Cubes). It shows how to connect to a data source, use the data fields in a crosstab, perform custom calculations, subtotals,...http://www.contextures.com/xlPivot01.html
Microsoft Excel tutorials
A very good and complete set of excel tutorials which describes in much detail the basics of MS Excel and contains broad information on advanced Excel features like Pivot Tables. Microsoft Excel Pivot Tables topics contain an overview of the concept of a...
http://www.homeandlearn.co.uk/ME/mes9p4.html
A very good and complete set of excel tutorials which describes in much detail the basics of MS Excel and contains broad information on advanced Excel features like Pivot Tables. Microsoft Excel Pivot Tables topics contain an overview of the concept of a...http://www.homeandlearn.co.uk/ME/mes9p4.html
Excel Business Examples
Excel examples lessons show how to make use of Excel in the business and finance. Among other interesting topics, it guides users through the implementation of the following concepts in Excel: Return of Investment (ROI) and Return on Equity (ROE) Forecasting...
http://lacher.com/toc.htm
Excel examples lessons show how to make use of Excel in the business and finance. Among other interesting topics, it guides users through the implementation of the following concepts in Excel: Return of Investment (ROI) and Return on Equity (ROE) Forecasting...http://lacher.com/toc.htm