Excel: Power up with Power Query
Автор: Vue IT Training
Загружено: 2025-02-28
Просмотров: 416
How to prepare a report on who has paid/not paid based on some fictional data. First we will import an Excel file, then prepare a basic query to list who has paid. Then we will duplicate the query to view who has not paid. Finally we will look at refreshing the query so it pulls through the up to date details. You will never use sort, copy and paste again!!!!
#exceltips #excel365 #excel #exceltricks #exceltricksandtips #microsoftoffice #dates #conditionalformattinginexcel #conditionalformattinginexcel #spreadsheet #countcolouredcells #copypaste #excelhack #excelhacks #spreadsheetmagic #spreadsheet #exceltricks #filter #filters #data #sort #powerquery #powerquerytutorial #tutorial #list #reports
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: