Advanced Excel & IT Skills
Microsoft Excel and the Office Package is heavily used at almost all workplaces. However the knowledge and skill level among the users are at a very low level. By equipping the employees with these skills, we ensure a productivity growth of at least 40%!
Advanced Excel Training Program
Participants of “Advanced Excel Training” program will gain a thorough understanding on advanced data handling techniques and also be able to; effectively use logical statements for faster decision making, make effective presentations and reporting using Pivot Tables.
- Managing workbooks with Sorting, Filtering & Organizing Data
- Using Conditional & Logic Functions for Decision Making, Data Management & Representation
- Referencing & Lookup for Data Management and Handling (VLOOKUP, HLOOKUP, MATCH, INDEX etc.)
- Data Validation
- Conditional Formatting
- Pivot Tables & Pivot Charts
- Text Functions
- Date and time functions
- Report Preparation
Training on Automating Work with Microsoft Excel Macro
This is a project based training implemented on a weekly model in order to guide and coach through the knowledge acquisition as well as problem solving within the work environment. This will include skill development sessions, project identification, project implementation, coaching, feedback and evaluation.
The objective is not only to equip with skills but also to implant the attitude to continuously think about possible improvements using Excel tools in order to increase the productivity at work.
Contact Us to Get a Customized Quotation
The Trainer
Sam Karandagoda
With over a decade of experience in Consulting and Training, Sam is well equipped with the knowledge, skills and attitudes to carry out individual as well as collective consultancy projects thanks to his sound education at the University of Melbourne; Australia, CIMA UK & University of Moratuwa; Sri Lanka. He had worked with Tata Consultancy Services - India, NODWIN Consultants - India, Olanka Travels - China, Highfive Consultancy and Training - Sri Lanka, IIDT - Sri Lanka where he has acquired insights about multiple industries such as Agriculture, Manufacturing, Tourism, Finance and Information Technology. He was a coach for the RMIT Melbourne Entrepreneurship Accelerator Program in 2020 and a coach for the University of Melbourne US21 Entrepreneurship Program in 2021. As a trainer, he has served a multitude of the most successful large scale companies in Sri Lanka. His training programs are conducted at Companies, Universities as well as Not-for-Profit Organizations. Some of his esteemed clients are MAS Holdings, Hirdaramani Group, Hayleys Group, DHL, Trelleborg, CMA-CGM, Midas Safety etc. (a total of 30 companies). Sam is passionate about training others to perform better and conducts training on;- Soft Skills Development (Public Speaking, Motivation, Team Work, Personal Effectiveness, Problem Solving, Negotiation etc.)
- Hard Skills Development (Financial Management, Business Process Improvement, Problem Solving & Decision Making, Microsoft Advanced Excel etc).
- Consultation to Farmer Organizations on Institutional Strengthening, especially with a focus on Governance and Developing the Capacity of the Leaders of the FO
- Production process analysis and improvement at an apparel manufacturing company
- Production process analysis and improvement at a cable manufacturing company
- Financial analysis and business plan for a coconut & mixed crop plantation
- Financial analysis and business plan for an automated fee collection system using vehicle number plate reading software
- Financial analysis and business plan for a canned fish manufacturing
- Financial analysis for a CEB tender bid by a foreign client
- Business formation and strategy formulation consultancy for a property development company