power query capability

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Power Query Capability

Power Query Capability

resolvedResolved · Medium Priority · Version 2016

Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course

Power Query Capability

FAO Jens

In ref to my previous question on Power Query, I have tested an additional reporting in Power Query which I cant seem to get to work.

I have forwarded a copy of the file to the STL mailbox marked with your name.

Please can you kindly review and let me know if there is any functionality that could work for this type of reporting.

Many Thanks

RE: Power Query Capability

Hi Kay,

I will send you my answer within 30 minutes.

What you want seems easy but it isn't. I hope my steps make sense and you can always look at my queries in the file I send you.


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

Mon 5 Apr 2021: Automatically marked as resolved.


 

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.05 secs.