DESCRIPTION:
This training-course will give you a deep understanding of the Intermediate to advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, Trainer would teach you on how to apply the formula and understand its business and analytical application as well.
OBJECTIVES:
After taking the course the participants :
• Able to do Autofill, Data Validation
• Create Analytical Functions like - Goal Seek, Scenario Manager and Data table
• Understanding the Functions like PMT, Vlookup, Hlookup, Multiple vlookup,Identifying and deleting duplicates
• How to Importing and exporting data, creating subtotal based reports
• Create Pivot tables, Pivot Charts
• Understanding Functions like count, countif, countifs, sum, sumif,sumifs,
• Introduction to basic Macros and Mail Merge
• PREREQUISITES: Microsoft Excel should be installed on your system, this course is compatible with Excel 2013, or later Some experience with basic formulas is recommended
• Team leaders and supervisors
• Managers and executives
• Project managers
• HR professionals
• Any professionals working in teams
• Lecturing and Class room session and Case Study
• Interactive sharing information and experience
• Group discussion, question and answer session
He is expert trainer for MS PROJECT training and IT related. Active in served public and inhouse training program in Jakarta, Bandung, Surabaya or invited as an Inhouse Trainer in several companies in the fields of industry, mining, finance, insurance, banking throughout Indonesia. He conducted training on international IT standard and Management topics and is also supported by internationally certified trainers or practitioners in their fields. Hery Purnama, who has more than 19 years of experience in the IT field at the technical or managerial level, including in the scope of training or management. *) Team
Our sessions are conducted by certified professionals with real industry experience.
For more information, please contact our customer service or register to be contacted by our team.
Join our proven programs designed to help professionals grow, comply with regulations, and excel in their careers.
Explore Trainings