Taking Microsoft® Excel® 2010 Further: Macros for Data Management and Statistics
The ease with which Microsoft® Excel® can be extended is a welcome and useful surprise for those who wish or need to use Excel for statistical work.
This one-day course introduces participants to ways of extending Excel using macros and other features of Visual Basic for Applications (VBA). Examples include simple programs to reorganise data and to perform statistical calculations. Practical sessions enable participants to develop and run simple macros.
Differences between Excel 2007 and Excel 2010 will be highlighted.
Those who need to extend their use of Excel beyond the standard facilities. The examples are mainly for those who will use Excel for statistical applications, but the concepts are equally relevant for any area of application. Participants will be assumed to have some experience in Excel. Programming experience in any language would be useful, but is not assumed.
You will be able to use Excel more efficiently, even for non-standard problems. Where applications need to be written that require more professional programming skills, you will be able to understand the issues involved, so that you can discuss the requirements and time-scales more effectively.
- The role for simple macros to eliminate repetition in Excel
- Moving on from macros to programming in VBA
- Programming tips
- Differences between Excel 2007 & Excel 2010.
Dates: 20 June 2013 at The University of Manchester and 19 September
2013 at The University of Reading
Duration: 1 day
Price: £355 at The University of Manchester and £320 at The University of Reading
Discounts: An Academic discount is available for this course.
Consecutive Courses: This course plus Advanced Excel for Students' Records Administrators: £655 in total at The University of Manchester; £595 at The University of Reading.
This course plus Statistics for University Administrators and Advanced Excel for Students' Records Administrators: £965 in total at The University of Manchester; £870 at The University of Reading.
Last updated: 26 October, 2012