Masterclass in Excel – Tips and Tricks

Masterclass in Excel – Tips and Tricks https://www.eventbrite.ie/e/120370530497

Trainer: Systems and Software Training

Cost: €45 per person

Date: 7th and 8th October 2020

Time: 9.30am -12.30pm

Venue: Online via Zoom

Contact: Jacqueline 059 9132152 / admin@carlowkilkennyskillnet.ie

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

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

Advanced Filter
Macros
Consolidation
Import / Export

Pivot Tables –
Pivot Charts
Reports
Conditional Formatting

 

Latest News

30/09/20

Digital Marketing

Trainer: Connect Me Marketing Cost: €295 per person Date:  8th 15th 22nd 29th  January and  5th 12th  February 2021 Time: 9.30am -12.45pm

See more

10/09/20

Outlook Advanced

Outlook Advanced https://www.eventbrite.ie/e/120372149339 Trainer: Systems and Software Training Cost: €45 per p

See more

Masterclass in Excel – Tips and Tricks

Masterclass in Excel - Tips and Tricks https://www.eventbrite.ie/e/120370530497 Trainer: Systems and Software Training

See more