Lead Training Services

MS Excel Intermediate

INTERMEDIATE LEVEL
Starting: 17th May 2018

In-depth practical official courseware will be used and provided to delegates; Hands-On exercises; extra practice exercises handed to delegates.

Date: 17th May 2018
Time: 9am – 4.30pm
Price includes: Course Tuition by Microsoft Certified Trainer, Official Microsoft Notes and Self Study Exercises on CD, Networking coffee breaks and light lunch and Certificate of Attendance
Venue: Holistic Institute, Fgura (Click here to view location)
Certification: A Certificate of Achievement will be awarded to delegates.

Programme description

  • Manipulate formulas – Use cell references in formulas, Use cell ranges in formulas, Summarize data with functions, Use formulas to create subtotals, Control the appearance of formulas
  • Advanced formulas – SUMIF, COUNTIF, VLOOKUP, IF, AND, OR, IFERROR, UPPER, LOWER, SUBSTITUTE
  • Summarize data – Use formulas to look up data in a workbook, Conditional formatting, Add conditional logic functions to formulas, Use formulas to format text, Use formulas to modify text, Secure your workbook before sharing it with others, Distribute a workbook by e-mail, Track changes to a workbook, Add comments to a workbook
  • Building charts – Formatting a chart with a Quick Style, Formatting the parts of a chart manually, Modifying the chart, PivotTables Basics
  • Manipulating Images – Insert pictures, Add shapes, Copy or move a graphic, Format graphics, Add graphic enhancements using picture tools

Testimonials

  • Many thanks once again for an extremely well run course.I and the rest of the group were hugely impressed with the trainer’s ability to couple complete professionalism with the creation of a fun learning atmosphere.The course was run at a perfect pace. It allowed everyone to reach a similar level quite quickly, and then drove us to soak-up as much information as possible for the duration.As an ex trainer myself, I found the level of prior preparation for the course exemplary. All of the data/tables created prior to the course for our use showed the level of thought and commitment that has gone into wireframing the course, and importantly, allowed us to get the most benefit possible from the time available.I will absolutely be recommending this course to all of my customers and colleagues.I’m excited for the rest of my guys who will be attending next week!Shane Cotter
    Head of Product Management, Malta
    NetEnt | Better Gaming™

Frequently Asked Questions

Who We Are

We are a team of specialists passionate about our work and with a common ambition to share learning experiences with people in the business community and civil society.

Under the brand name LEAD Training Services, our team has attracted an impressive pool of professional trainers from different areas of business and different geographical locations.

This makes us the only professional training organisation in Malta that can offer cutting edge training programmes across a broad spectrum of topics. We do not believe in one-size-fits-all training programmes and in line with our belief we customise our programmes to our individual customer’s needs.

Let's Keep In Touch

Stay adjourned with our latest courses, news and events by subscribing to our newsletter. We will send you an email newsletter from time to time, and we promise to never sell your details to any third parties!

Our LatestNews

Posted on: Thursday, February 15th, 2018

On the 9th February 2018, LEAD Training Services held its annual Award Ceremony at the Xara Lodge in Rabat. Present for this event were over 300 students who attended LEAD’s accredited professional short courses during 2017 and successfully achieved their CPD Award Qualifications.

Special guests for this ceremony included the Mr. Martin Borg, and Educational Management and Quality Control expert Mr. Paul Gauci Executive Head of BOV Training Centre and trainer with LEAD Training Services. All of these, together with Mr James Grech Managing Director of LEAD Training Services delivered short speeches during this event. …read more »