Microsoft Excel for Statistics - What you can and cannot do
This course gives practical experience in the use of Microsoft® Excel® for data summary, presentation and for other basic statistical work. It concentrates on areas where Excel really can excel, such as array functions. We look at data entry and management, pivot tables, and graphics.
We also review Excel's facilities for statistical analysis, advising on their use and limitations, and we show how add-ins can be used to enhance Excel's capabilities.
Who Should Attend?
Participants are assumed to have some experience in Excel. This course is intended for anyone who currently uses or is thinking of using Excel for handling data and for their statistical work. It is also for statisticians, if they need to advise and support others on the efficient use of Excel.
How You Will Benefit
This course is designed to turn your general Excel capabilities into skills in the use of Excel for data processing and basic statistical applications. The course will make use of our Excel add-in called SSC-Stat, which provides some statistical features that are not available in standard Excel. A copy of this add-in will be given to all participants.
What Do We Cover?
- Data entry and validation
- Efficient data management, named ranges and VLOOKUP
- Pivot tables for cross tabulations
- Good statistical graphics
- Conditional operations and array functions
- Data summary and analysis; pros and cons of the Analysis Toolpak
- The use of SSC-Stat, an Excel add-in for efficient statistical work.
This course has practical exercises written for: Excel
Related Courses: Microsoft Excel for Statistics; Advanced Excel for Students' Records Administrators; Taking Microsoft Excel Further - Macros for Data Management and Statistics; Microsoft Access for Data Management: A Hands-on Approach.