Excel can import data in a variety of formats. Users of Minitab or other statistics packages may find themselves frequently switching between the two programs in their Six Sigma work.
Furthermore, Excel allows for removing duplicate entries, validation of data, detailed data filtering and data sorting. Basic summary data are easily obtained and the charting options are extensive. Graph and chart types include scatterplots, line graphs, bar charts, and area charts, as well as some specialty charts.
Excel also provides a vast array of formulas that can be entered to automate basic and advanced calculations. Options include data and time conversions, financial formulas and database references and lookups. The pivot table is especially beneficial for anyone who needs to view a large data set in a variety of ways, as it removes the need to create separate tables or spreadsheets for each view.
The Data Analysis Tool Pak adds functionality such as analysis of variance (ANOVA), correlation analysis, descriptive statistics, regression and sampling. While some of these tasks are better accomplished using Minitab, they are feasible in Excel for those who do not have Minitab.
The program includes a review feature which lets multiple users add comments and track changes, as is commonly done in Word.