Selwyn Community Education

  • Home
  • Our Courses
  • About Us
  • News and Blog
  • Selwyn College
  • Contact Us
  •  
  •  

Microsoft Excel Advanced: Macros

    Home Microsoft Excel Advanced: Macros

    Learn how to use Visual Basic macros to automate routine activities. Save time and effort. Improve your consistency and accuracy with repetitive procedures.

    • Sat 26 Aug
      4 hours, Sat 9:00 AM - Sat 1:00 PM At Selwyn College, Auckland. Jose Entrican
      • $70.00 incl. GST
      Register
    Share

    Let me know about future course dates

    Description

    Learn how to use Visual Basic macros to automate routine activities. Save time and effort. Improve your consistency and accuracy with repetitive procedures.

    Key content

    • Recording and editing VB code
    • Options to run macros including buttons
    • Add simple input and alert boxes to make the macros interactive
    • Add basic programming structures such as conditional statements and looping
    • Create a simple function macro to perform a custom calculation

    Objectives

    • Learn the fundamentals of visual basic macros within Excel
    • Learn to modify these macros where necessary

    Who should attend?

     You should be a strong Excel user. Classes will be held in a school computer suite running Windows and using Microsoft Excel 2016 (part of Office Professional Plus). Please bring a USB stick with you to class to save your work.

     

    Powered by Arlo training & Event Software
    Share

    new-logo-circle-web

    (09) 521 9623
    info@selwyncomed.school.nz
    203-245 Kohimarama Road, Kohimarama

     

    COVID-19 Information

    Open Hours
    Term Time: Monday - Wednesday 9:00am - 9:00pm
    Thursday - Friday 9:00am - 3:00pm

    School Holidays: When courses are running the office is open 9:00am - 4:00pm




    Powered by Graphic Detail Ltd
    • Home
    • Our Courses
    • About Us
    • News and Blog
    • Selwyn College
    • Contact Us
    •  
    •  

    Selwyn Community Education