BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Brainwork Resources - ECPv6.16.5.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Brainwork Resources
X-ORIGINAL-URL:https://brainwork-resources.com
X-WR-CALDESC:Events for Brainwork Resources
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20261123T080000
DTEND;TZID=UTC:20261124T170000
DTSTAMP:20251210T105026Z
CREATED:20251210T105026Z
LAST-MODIFIED:20251210T105026Z
UID:1565-1795420800-1795539600@brainwork-resources.com
SUMMARY:Power Query in Microsot Excel
DESCRIPTION:INTRODUCTION \nThe 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. \n  \nOBJECTIVES \nAt the end of this course\, delegates will be able to: \n\nCreate effective and professional reports\nGather and transform data from multiple sources\nDiscover and combine data in mashups\nLearn about data model creation\nExplore\, analyse\, and visualize data\n\n \nCOURSE CONTENT \nSESSION 1 : INTRODUCTION TO POWER QUERY  \n\nExcel 213 – Installing Power Query\nExcel 2016 – Get & Transform\nCreate and Edit a simple query\n\nSESSION 2 : COMMON DATA IMPORT SOURCES  \n\nWorking with CSV; Text; Excel Files\nImporting multiple files\nWorking with Web data\nScraping Data from Web Pages\nCalling a Web Service\n\nSESSION 3 : WORKING WITH FOLDERS AND MULTIPLE FILES  \n\nUsing data from Windows File manager\nCombining Data from Multiple Files\n\nSESSION 4 : WORKING WITH COLUMNS  \n\nName; Move; Split; Merge Filtering and Sorting\nUsing Auto-Filter\nUsing Number\, Text and Data Filters\nFiltering Rows by Range\nRemoving Duplicate Values\nFiltering out Rows with Errors\nSorting\nGrouping rows\n\nSESSION 5 : CHANGING VALUES IN A TABLE  \n\nReplacing Values\nTransformations: – Text; Number; Date/Time\nReplacing Missing Values\nTable Transformations\nUn-pivoting Columns to Rows\nTransposing a Table\nCreating Custom Columns\n\nSESSION 6 : LOADING DATA  \n\nLoading Data into a Worksheet\nLoading Data into the Excel Data Model\nPower Query and Table Relationships\nRefreshing Queries Manual & Auto\n\nSESSION 7 : QUERY EDITOR  \n\nEdit Query Steps\nEdit Query Step Settings\nRefresh a Query\n\nSESSION 8 : QUERIES  \n\nUnderstanding Power Query’s language syntax\nMerging tables and queries\nUsing Power Query functions in columns\nUsing conditional (IF) statements\nCreating custom Power Query functions\nImplementing dynamic parameter tables\nCreating calendar tables\nSharing queries\nBest practices for Query organization\n\n\nMETHODOLOGY \nAn adult learning approach using a combination of lectures and simulation\, exercises\, hands-on with close supervision by the trainers\, presentation\, management games & group discussions \n  \nWHO SHOULD ATTEND? \nExperienced Excel users wishing to create complex reports\, or needing advanced data analytics to process\, analyze and display data and those who are intrested. \n  \nTRAINER \nShamsiyah Abd Kadir \nFakhrul Syahmi \n  \nFEES (WITHOUT ACCOMODATION) \nRM1\,100.00 per pax \nEarly Bird RM1\,000.00 per pax \n(20 days before program) \n2 pax RM 1\,050.00 per pax \n3 pax > RM1\,000.00 per pax \n(This fees is inclusive of 2 morning tea breaks\, 2 lunch \, 2 afternoon tea breaks\, notes and certificate of attendance for the participants)
URL:https://brainwork-resources.com/event/power-query-in-microsot-excel/
LOCATION:Kuala Lumpur/Selangor\, Malaysia
END:VEVENT
END:VCALENDAR