In light of continuing Government advice regarding the spread of coronavirus (Covid-19) and social distancing, the majority of our face to face courses remain cancelled. Alternatively, we are pleased to offer an increasing range of online and virtual courses. Please see individual courses for details.

View Details

Excel 2010 Introduction to Macros Level 4 1day

Venue
East Sussex Training & Development Centre (St Mary's House), St Mary's House, St Leonard's Road
venue
Admin Contact
Corporate Training Mail Box (corporate.training@eastsussex.gov.uk)
Target Audience
target audience
Course Types
Course
Course categories
ICT Skills
Subject
Course description

This course is for you if you are familiar with entering formulas and analysing data in Excel and want to write code to automate Excel tasks, such as formatting a report and performing operations which can not be done using conventional Excel commands.


 


 

Training objectives

The course assumes that delegates are familiar with:



  • carrying out basic operations such as data entry and copy and paste

  • entering formulas in Excel and using functions including VLOOKUP and IF

  • performing data analysis such as sorting and filtering


Please note - Writing macros involves inputting lines of sometimes complex program code, so the course involves considerably more typing than other Excel training.

Learning outcomes

By the end of the course you will:



  • be familiar with the VBA Editor and will be able to record a macro or create a macro in the code window

  • know how to use variables

  • know how to display messages and ask for simple user input

  • know how to use IF to decide which lines of code to run


"An extremely useful course which has enabled me to automate many repetitive tasks, both for myself and other team members."


(evaluation comment from a recent delegate)


 

Additional Information

A handout covering the main course topics will be provided.

Enquiries
Start Date
Tuesday 21 January 2020
End Date
Tuesday 21 January 2020
Closing Date
Monday 20 January 2020
Times
09:30 - 16:30
Maximum Places
10 
Cost
Login to view cost
Number of Sessions
1