Stephanie has attended:
Excel Advanced course
Analysing quantitative data
How can I analyse the frequency of words i.e. counting the frequency of words & how often a given word appears in conjunction with another word in the text.
RE: Analysing quantitative data
Hi Stephanie,
I know we discussed this at the end of the session and I recommended using Conditional Formatting for Key words. You could then multi-level sort by colour. Let me know how that goes. If not I can explain how to learn about the text functions in Excel which can achieve the same result.
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best 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