Smart learning solutions – with immediate results


Do you find it difficult to take an entire day out of work to do a course? Take a day’s conventional training course and compress it into a dynamic, short session filled with useful tools and techniques! IACT’s SMART Learning sessions are a quick and cost-effective way to get up to speed with key skill areas. Designed around hints, tips/tricks and key topics, they provide a high-impact overview to core business topics. We have produced over 10 session titles, which can accommodate large numbers of people making them ideal for maximising training input in minimum time.  
Lunchtime Learning Seminars

About our seminars

Choose from a variety of sessions, which can be delivered ‘off the shelf’ or customised for your organisation. We deliver anytime and anywhere, with up to two sessions a day. Each session is 90 minutes in duration with an interactive 30 minute Question and Answer at the end – and remember you can have as many delegates as the room will fit. Large numbers of participants can attend these Smart Learning Sessions, which makes for highly economical training approach both in terms of cost per head and in terms of time. We have taken the 5 most useful and most frequently requested Excel topics and we go through all of them in this seminar. Learn from our Expert Excel Trainers who will show you how your business can work smarter and faster, saving you time and money using Excel. Whether its the power of V/H lookups or learning to use Power Pivots you will be amazed at how learning about Excel’s top tips and secrets can cut your daily workload in half.
So signup and join us for lunch, lighten your workload in 2016 and meet up with Ireland’s leading Excel experts.

 

Choose your own seminar programme

Book your company’s own customer seminar. Select your modules from the options below:
  • Excel Seminar 1: Tips and Tricks, Pivot Tables, Pivot Charts and Slicers, Table Feature, Dynamic V/H Lookups, IFERROR.
  • Excel Seminar 2: Advanced Conditional Formatting, Data Validation, Filtering with Subtotal function, Countif, Sumif, Countifs and Sumifs, Sparkles.
  • Excel Seminar 3: Alternatives to the Lookup, Lookup with the Match function, 2 Way Lookup, IF Statement, Looking up a second or third occurrence of a value.
  • Excel Seminar 4: Macros, Developer Tab, Running an existing macro, Record a macro, Saving a workbook with a macro, Absolute and relative macros, Step into an existing macro, Copying a Macro, Deleting a macro, Assigning a macro to a button or the ribbon, Creating a custom tab and ribbon
  • Office Survival Seminar 5: Time saving tricks and techniques, Tips and Tricks for, Excel, Word, PowerPoint, Outlook.
  • Creative PowerPoint Seminar 6: Beginning your presentation, Do’s and Don’ts, Group Slides into Sections, Enriching your presentation, Using SmartArt, Picture Effects, Animation and the animation painter, Perfect Videos, Beautiful Transitions, Delivering your presentation.
  • Customised Excel Seminar 7: Tips and Tricks in Excel, DATA ANALYSIS, Pivot Tables, Pivot Charts and Slicers, Advanced Conditional, Formatting, Filtering with Subtotal Formula, Data Validation, Sparklines, FORMULAS, Countif, Sumif, Countifs and Sumifs, IF and Nested If Statements, Dynamic V/H Lookups with Table Function, IFERROR, Index and Match Functions (Alternative to the Lookup), Lookup with Match function, 2 way Lookup, Choose function, Looking up a 2nd or 3rd occurrence of a value, Basic Macros

Feedback from our last seminar

 
“This format is an excellent way to get a taste of what’s possible.  My curiosity has been piqued about what else I didn’t know that I don’t know.”
Stephen Shortt – Managing Director – Alpha College

“We first used IACT’s seminar sessions in late 2014 and began with the “Excel Hints Tips and Tricks” and the positive feedback that resulted from staff of all different levels has resulted in us going back for more and even integrating these super sessions into our Learning and Development calendar for 2015. Super quick and super informative!”
Barry Brennan – Training Manager – ESB Ireland
 
“Practical and useful information presented in an accessible way.” 
Karen Sheehan – MRBI
 
“Really liked the duration of the Seminar, it is very difficult to take 2 full days out of a work week.”
Pauline Egan – MRBI
 

Who should attend?

  • Accountants and Financial Controllers
  • Sales and Marketing Managers
  • Administrators and HR professionals
  • CEOs and CFOs
  • IT Managers and Software Developers
  • Anyone using Excel every day

We can also run seminars as private in-house programmes throughout Ireland. Enquire here


 

Business Seminar Enquiry Form