Here are all the new Excel articles and webinars from the Excel Community in April 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.
Virtual events have become popular during lockdown with new tools and techniques showing how they can be just as good as in-person events.
Hello all and welcome back to the Excel Tip of the Week. This week we have a Creator level post in which we’re taking a definitive revisit to the handy data transformation tool, Text to Columns. This was last covered back in TOTW #105
When working with data from text files it is often necessary to split a single column into multiple columns, or even rows. For example, an account code might encompass several components such as account type, department and detailed analysis and, to allow the data to be summarised by each of these components, it will be necessary to separate each of them into their own columns.