Power Query Pobieranie i przekształcanie danych. Oferta Zajęcia indywidualne, kursy grupowe, szkolenia dla firm. Program szkolenia 8h 1. Get dataFrom Table/RangeFrom File (Excel, Text, CSV, Folder)From Web2. Load queriesAutomatic (New Worksheet)Existing WorksheetOnly Create ConnectionPivot Table ReportPivot Chart3. RefreshAutomaticOn demandVBA4. TransformRemove Columns, RowsSplit ColumnUse First Row as HeadersReplace ValuesFillRenameFormatDate & TimeMathematical & Statistical OperationsColumn From ExamplesCustom ColumnConditional ColumnIndex ColumnDuplicate ColumnPower Query vs. VBA macros5. Filter and Sort6. Combine queriesMergeAppend7. Pivot tablePivot TablePivot ChartPower Query – Group ByPower Query – Pivot ColumnPower Query vs. Pivot Table