Utilizing and teaching data tools in Excel for exploratory analysis

Susan W. Palocsay, Ina S. Markham and Steven E. Markham

Journal of Business Research, 2010, vol. 63, issue 2, 191-206

Abstract: In this article we offer Excel as an introductory tool to high end business intelligence (BI) and decision support system (DSS) applications. Because it is ubiquitous, Excel can be used by all managers and business students for exploratory data analysis. We provide three key points in this utilization of Microsoft® Excel 2003: (1) manipulating records using Excel as a database, (2) creating PivotTables® and PivotCharts® using Excel for analysis, and (3) importing data using Excel as an automation container. The basic skill set defined by the above three items allows users to begin to use Excel to its full potential in finding information in business data, and it offers a key tool for future research in improving the utilization of information across organizations.

Keywords: Excel; data; tools; Pivot; tables; Data; analysis; Quantitative; business; education; Exploratory; data; analysis; Pivot; charts (search for similar items in EconPapers)
Date: 2010
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (3)

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0148-2963(09)00064-2
Full text for ScienceDirect subscribers only

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:eee:jbrese:v:63:y:2010:i:2:p:191-206

Access Statistics for this article

Journal of Business Research is currently edited by A. G. Woodside

More articles in Journal of Business Research from Elsevier
Bibliographic data for series maintained by Catherine Liu ().