 |
This collection of online tutorials and workbooks introduces Excel, statistics on Excel and Excel Solver.
Contact the Maths Learning Service if you would like other topics to be added or know an interesting website.
|
Use the menubar at the end of the page to return or to contact the Maths Learning Service. |
Excel 2003 - the University's online course for Excel 2003 is useful for beginners. It assumes no knowledge and covers:
Excel's Help menu is useful when you are uncertain how to continue.
Sites with the icon 
are not University of Adelaide pages and downloading will use up some of your download quota for the semester. For more details about quotas see http://www.adelaide.edu.au/ITS/snap/ .
Internet4Classrooms - a useful and comprehensive introduction to Excel. It covers the differences in terminology and appearance between the Windows and Mac versions.
OfficeOnline - the official Microsoft website provides free online training in all non-technical aspects of Excel.
Boxplots in Excel - boxplots, or box-and-whisker diagrams, are especially useful when comparing two or more data sets. There is currently no boxplot facility in Microsoft Excel and this link shows how to work around this.
Excel Commands wth Diagrams - step-by-step description of how to perform statistical routines ...check out regression analysis.
Excel for Business Statistics - an introduction to the use of Excel as a tool for data summary, presentation and common statistical analyses.
SMART - describes some of the basic statistical operations when exploring and drawing conclusions from data.
StatsTeacher - shows how to construct charts and graphs, and how to perform many statistical routines. It also shows how to construct box-and-whisker plots, even though Excel doesn’t do this directly.
ExcelStats.XLS - This useful downloadable Excel workbook explains and gives examples of how to construct charts and graphs, and how to perform statistical routines. Contents: Introduction; Sorting; Frequencies & Graphs; Histogram; ScatterPlot; Descriptive Statistics; Rank & Percentile; Covariance; Correlation; Sampling; Confidence Intervals; One-Sample t-test; Two-Sample t-test; Regression...
The interactive workbooks below can be used to explore statistical topics. You can change values in data sets or drag the points on most charts and see how this affects charts, graphs and statistical estimates. They were created by Richard Castles and are reproduced with permission. Click to download.
EZANALYZE - a free Excel add-in that enhances Excel's usability by adding "point and click" functionality for analyzing data and creating graphs. It works on both Macs and PCs.
• EZAnalyze does all of the basic descriptive statistics for you, such as mean, median, standard deviation, and range. It also "disaggregates" data, which allows you to break down your data by categories. For example, if you wanted to see if boys and girls performed differently on your state's standardized test, you could disaggregate the test scores by gender.
• EZAnalyze contains advanced features - correlation; one-sample, independent samples, and paired samples t-tests; chi square; and single factor ANOVA. However, appropriate use of these tests requires more knowledge of how to use them than is included in the documentation.
• An EZAnalyze results report is generated for each analysis. These reports contain all the information you need to interpret your results. If you are not familiar with the statistics, you can consult the extensive documentation available in the help files, or in the manual.
Windows:
Macintosh:
Learning Tool - Excel Solver is used in linear programming. Learning Tool is an excellent introduction to the concepts of linear programming. It requires knowledge of the equation of a straight line.
Installing Solver - how to install Solver.
Solver Tutorial - this tutorial, from the makers of Excel Solver, begins by asking “What are Solvers good for?” and then progressively explains how solvers are used in optimisation problems where resources are constrained. The tutorial introduces and gives examples of objective functions, design variables and constraints. It also takes you step-by-step through setting up a Solver model, then solving it using Excel Solver dialogue boxes.
Linear Programming with Excel Solver - how to use Excel Solver to solve a linear programming problem.
OfficeOnline - how to use Solver to set quantity and pricing.
Informit Network - how to use Solver for financial planning.
dslimited - how to use Solver to solve a system of simultaneous equations.
Excel Nexus - how to use Solver can find the maximum/minimum of a function in an interval, and can solve a system of non-linear equations.
ICTCM/v13 - how Solver can be used to solve several types of standard and non standard regression problems.
[previous page] [mathsmate] [homepage] [more help] [feedback]