Lead Training Services

MS Excel Expert Training Programme

ADVANCED LEVEL
Starting Date To Be Announced

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

Duration: 6 contact hours
Time: 9am – 4pm
Price includes: Official Microsoft CD Courseware, Networking coffee breaks and light lunch and Certificate of Attendance
Venue: Holistic Institute, Fgura (Click here to view location)

Microsoft Office Specialist - Lead Training ServicesOptional Certification: Delegates who complete this course may opt to undertake an exam and obtain the official Microsoft Office Specialist (MOS) MS Excel CORE Certification accredited by Microsoft. Certification Fee: €50.

Course Outline

Sharing and Maintaining Workbooks – Setting Workbook Properties , Exchanging Data with XML, Apply Protection and Sharing Properties to Workbooks and Worksheets, Maintain Shared Workbooks and Tracking Changes

Applying Formulas and Functions – Using Auditing Tools to Trace and Correct Formulas , Setting Options for Iterative Calculations, Perform Data Summary Tasks, Summing Data with the SUMIF and SUMIFS Functions, Understanding and Defining Array Formulas.

Presenting Data Visually – Apply Advanced Chart Features, Adding Trendlines to Data, Visualizing the Data in a Cell by Using Sparklines, Apply Data Analysis, Performing a What-If Analysis, Goal Seek, Using Data Tables, Using Solver, Using Automated Analysis Tools, Generating Descriptive Statistics, Apply and Manipulate PivotTables, Slicing the Data in a PivotTable.

Working with Macros and Forms – Create and Manipulate Macros, Insert and Manipulate Form Controls, Making Use of ActiveX Controls, A Simple Order Form

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™

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.

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: Tuesday, October 15th, 2019

In a constantly and rapidly changing world, keeping up with changes and developments is essential for survival and growth. Successful organisations invest in one single strategy to adapt to these accelerated changes and become industry leaders – they invest in their employees’ professional development. This is where LEAD Training Services can help you.

…read more »