Taking Microsoft® Excel® 2010 Further: Macros for Data Management and Statistics

Course outline

Who should attend

How you will benefit

Course content

 

Course outline

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.

Who should attend?

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.

How you will benefit

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.

Course content

  • The role for simple macros to eliminate repetition in Excel
  • Moving on from macros to programming in VBA
  • Programming tips
  • Creating a simple Add-In with your macros.

Dates: 18 September 2014 at Reading; dates for other venues tbc
Duration: 1 day
Price: £320 at The University of Reading; £355 at other venues
Discounts: An Academic discount is available for this course.
Consecutive Courses: Prices for attending more than one of the following courses in the same week is outlined in the table below:
Statistics for University Administrators
Statistical Analysis of Examination and Other Numerical Data
Advanced Excel for Students' Records Administrators
Taking Microsoft Excel 2010 Further: Macros for Data Management and Statistics

Duration at University of Reading at other venues
Any 2 days
£595
£655
Any 3 days
£870
£965
All 4 days
£1100
£1210

Apply for course

Last updated: 22 October, 2013

Examples..

Timetable*

Example Lecture

Apply for course

* Subject to revision. Will be confirmed 3 weeks before the course starts