Statistical Services Centre Ltd
  • Home
  • Training
    • Course Registration
    • Terms and Conditions
    • Bespoke Training
    • Mailing List Request
  • Consultancy
    • Expertise
  • Team
    • James Gallagher
    • Sandro Leidi
    • Cathy Garlick
  • SSC-Stat
  • Get Started
  • Contact us
  • Products
  • Blog

Taking Microsoft Excel Further - Macros for Data Management and Statistics

Overview
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
By the end of the course 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.

What Do We Cover?
  • 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

Software
Practical work will be done in: Excel
Note:
For practical work, participants must bring their own laptop with a fully licensed version of the software.

Extra Information
Related courses: This course is part of a series of courses for HE professionals working in administrative, planning and support roles:
  • Statistics for University Administrators
  • Statistical Analysis of Examination and Other Numerical Data
  • Advanced Excel for Students' Records Administrators
  • Taking Microsoft Excel Further - Macros for Data Management and Statistics

Course Dates
Next run to be announced

Duration: 1 day
Price: £TBC

Apply Now
(terms and conditions apply)

Return to full course listing
Vertical Divider
  • Home
  • Training
    • Course Registration
    • Terms and Conditions
    • Bespoke Training
    • Mailing List Request
  • Consultancy
    • Expertise
  • Team
    • James Gallagher
    • Sandro Leidi
    • Cathy Garlick
  • SSC-Stat
  • Get Started
  • Contact us
  • Products
  • Blog