ADVANCED IT SKILLS

Aimed at experienced users of Microsoft Office, this course will look to transform and develop your skills to enhance the way they work so they can confidently and proactively develop documents, spreadsheets, and presentations that will give their company the digital edge. All content is geared around the aim of improving your business presence and helping you display content in a professional, dynamic way.

Units Include:

• Word Advanced for Report Writing – Learn how to produce reports with all the linking of data, bookmarks, table of contents,
• images with cross references. You will learn how to work with others and track and compare changes in documents.
• Excel Formulas (Formulas and Functions) – Learn how to use the intermediate and advanced functions in Excel to build
• spreadsheets with confidence.
• Excel Advanced for Data Analysis and Reporting – (Dashboards and Analysis) – Learn how to analysis and clean data is an
• essential skill for any business. This course will give you insights on how you can effectively trend your data and analyse your
• Word Advanced for Digital Design – We will look at all the advanced skills with designing documents that will be displayed to
• existing and potential customers on Digital format. Your data will be enhanced with the use of graphics, accessibility for the web,
• enhanced tables and forms, document form fields, mail merge.
• PowerPoint – This module will be taking your PowerPoint skills to the next level. You will be linking data from Excel
• Dashboards, Creating Advanced Animation and Transitions, Designing and working with multiple Templates and Designs,
• Embedding Video and Sound into Presentations and learning how to present like a pro with the advanced Presentation Tips for
• Effective Presentations.

Delivered by Square One

This is part funded by the European Social Fund