Training Programmes

IT

Microsoft Excel

Date: 20th 21st january 2021

Tutor: Systems and Software

Venue: Online

Cost: €45

Book Here: https://www.eventbrite.ie/e/128760414867

Most Excel users, once they have learnt the core Excel skills, are largely self taught. You can pick a lot of how to’s along the way. But you’ve never been shown how to use Excel the best way, by a professional. The aim of this course is to achieve two goals. To show delegates how to do most every-day tasks much more productively, PROBABLY saving you hours of boring routine work. Along with this we will cover new topics which will broaden your knowledge of use of Excel.

Session 1 – 20th January
Overview – Tips & Tricks
Customise Excel
Formula – Best Approach
Functions
• Stats
• Date
• Text
Freeze Panes
Formatting
Audit Options
Charting
Sub-Totals
Data Functions
Sub-Totals
IF Statements
VLOOKUP’s
Drop-Down Lists

Session 2 – 21st January
Advanced Filter
Macros
Consolidation
Import / Export
Pivot Tables –
Pivot Charts
Reports
Conditional Formatting

 

Latest News

26/03/21

Talent Management Cycle

Date: 27th April 2021

Time: 10am - 12pm

Cost: €15

Book Here: https://bit.ly/3fhOW

See more

19/03/21

Security Awareness Training

Date: 27th April 2021

Time: 10am - 12pm

Cost: €25

Book Here: https://bit.ly/3eJ11

See more

05/03/21

Technical Writing Skills

Date: 19th 26th May 2021 Time: 9.30am - 12.30pm Online: via Zoom Price: €99 Book Here: See more