Forum Discussion
Track FedEx shipments
You may track FedEx numbers from we site using Power Query, please see the sample at the end of this https://www.reddit.com/r/excel/comments/75xx7h/pulling_eta_data_from_fedex_into_excel/ discussion.
For the concrete number data return looks like
Similar of you have the table with FedEx tracking numbers, you may return the table with the statuses as above for all of them. Sample is at the same place as well.
I'm not sure, but most probably the same works if you change carrier from Fedex on UPS.
Good question.
First, you need to have it. If you are on Excel 2016 it's built-in, Get & Transform tab in ribbon.
If on Excel 2010 or 2013 you shall download and install it as add-in from MS download site, that's straightforward procedure.
As for PQ perhaps it's better to start from MS support article, entry point is introduction https://support.office.com/en-us/article/introduction-to-microsoft-power-query-for-excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605 and after that step by step by references. How many steps depends on how deep you'd like/you need to be in PQ.
And you may use that resource https://msdn.microsoft.com/en-us/query-bi/m/power-query-m-reference as a reference.
Plus google always helps, on "power query <how to>" usually you easy find an answer.
And yes, all above takes time.