98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Jens - tool to assess data cleanliness and identify spelling mis
Jens - tool to assess data cleanliness and identify spelling mis
Resolved · Medium Priority · Version 365
Wed 5 Jun 2024, 17:09Delegate Adam said...
Adam has attended:
Excel Pivot Tables course
Jens - tool to assess data cleanliness and identify spelling mis
Hello!
I completed with training with Jens last month and I remember him showing me some magic trick on excel where excel shows you have clean your data is across all columns and rows so that you can easily make it uniform for analysis.
I'm checking my notes and all I can see if Power Query Editor and Power Pivot but I can't confirm through what I am seeing online whether it is either of those!
Help me when you can! Thanks
Adam Sadullah
Thu 6 Jun 2024, 17:13Trainer Jens said...
RE: Jens - tool to assess data cleanliness and identify spelling
Hi Adam,
Thank you for the forum question.
The magical tool is Power Query.
I have found a couple of videos which may be helpful.
https://www.youtube.com/watch?v=Obs7NaBhic4
https://www.youtube.com/watch?v=WHxKvHSyWcs
If the videos are not helpful, I will need to have more details about your specific issue.
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between split pane sections in a spreadsheetIf you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections: |
