Training is not a commodity – all training centres are not the same. Iverson Associates Sdn Bhd is the most established, the most reputable, and the top professional IT training provider in Malaysia. With a large pool of experienced and certified trainers, state-of-the-art facilities, and well-designed courseware, Iverson offers superior training, a more impactful learning experience and highly effective results.
At Iverson, our focus is on providing high-quality IT training to corporate customers, meeting their learning needs and helping them to achieve their training objectives. Iverson has the flexibility to provide training solutions whether for a single individual or the largest corporation in a well-paced or accelerated training programme.
Our courses continue to evolve along with the fast-changing technological advances. Our instructor-led training services are available on a public and a private (in-company) basis. Some of our courses are also available as online, on demand, and hybrid training.
Formulas and functions are the building blocks of working with numeric data in MS Excel. Mastering the essential functions is the key to improve the productivity of effective data reporting.
Delivery Method - VILT
Virtual instructor-led training (VILT) refers to training that is delivered in a virtual environment when instructor and learner are in separate locations. Virtual instruction environments are designed to simulate the traditional classroom or learning experience allowing professionals flexibility of learning at their convenient locations.
Content deliveries are break-down by sessions. Each session will take approximately 45min (with Q&A) follow with short breaks.
• Concept of Formulas
• Understanding Relative and Absolute Cell References
• Using Array Formulas
• Using 3D References
• Q & A
• Concept of Functions
• Using Logical Function: IF & Nested IF
• Using Statistical functions: AVERAGEIF(S), COUNTIF(S), SUMIF(S)
• Q & A
• Using Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP
• Using IFERROR Function
• Q & A
• Converting Data in range as a Table
• Total the Data in Table
• Removing Duplicates from Table
• Using Sort and Filter
• Optional – Advanced Filter
• Q & A
13 Apr 2020
18 May 2020
PMP, Project Management Professional (PMP), CAPM, Certified Associate in Project Management (CAPM) are registered marks of the Project Management Institute, Inc.