This course covers elements within Microsoft Word (formal letter layout) for the purposes of mail merge.  In Microsoft Excel, the creation of a budget demonstrates the use of basic formulae (autosum/min/max/average/sort & filter/conditional formatting) and more complex formulae using the IF function, Nested IF statements and VLOOKUP to analyse data.  Within Microsoft Access, the creation of a table and use of queries and reports are touched upon to demonstrate the range of Microsoft Office software available.

Residential 

Date and Times

26th April 2021 - 28th April 2021

9AM - 12PM 

Apply


28th June 2021 - 30th June 2021

9AM - 12PM 

Apply

Level Level 1/2
Learning Outcomes

You will cover the following 

  • Microsoft Word (formal letter layout) for the purposes of mail merge
  • Microsoft Excel, the creation of a budget demonstrates the use of basic formulae (autosum/min/max/average/sort & filter/conditional formatting)more complex formulae using the IF function, Nested IF statements and VLOOKUP to analyse data
  • Microsoft Access, the creation of a table and use of queries and reports are touched upon to demonstrate the range of Microsoft Office software available.

Entry Requirements

You must have completed IT the Basics or have a beginners level of ICT knowledge

Progression

You might also be interested in Setting up a Website, Introduction to Cloud Computing and Introduction to Creative Media.