- Home
- Training
- All Courses
- MS. MS Application Training
- Microsoft Excel Power Query
Training with Iverson classes
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.
Microsoft Excel Power Query
TRAINING ONLY
Overview
The Excel Power Query gets data from almost anywhere (web sites, databases, Excel files, SharePoint, Salesforce etc.) and enables you to manipulate it in many ways (clean, transform, merge and append) using a straightforward interface add-in to Microsoft Excel. Non-technical Excel users can access large corporate databases to conduct analysis and produce reports.
Audience Profile
Experienced Excel users wishing to create complex reports, or needing advanced data analytics to process, analyse and display data.
At Course Completion
At the end of this course, delegates will be able to:
• Create effective and professional reports
• Gather and transform data from multiple sources
• Discover and combine data in mashups
• Learn about data model creation
• Explore, analyse, and visualize data
Course Outline
PMP, Project Management Professional (PMP), CAPM, Certified Associate in Project Management (CAPM) are registered marks of the Project Management Institute, Inc.