Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

power query

ResolvedVersion 365

Puisum has attended:
Excel Advanced - Formulas & Functions course

Power Query

We are currently using Select HR but will more to WorkDay at the end of the year. Can Excel link to live data of these two HR systems?

RE: Power Query

Hi Pui-Sum,

Thank you for the forum question.

Unfortunately I have not been able to find an example of how to connect Power Query to Select HR but I would be very surprised if it is not possible based on my experience working with Power Query. All application developers always make sure the their applications can communicate with Microsoft's applications.

Below you will find a guide how to connect to WorkDay



https://www.cdata.com/kb/tech/workday-cloud-power-query.rst


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 28 May 2024: Automatically marked as resolved.

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.