Text Manipulation: Intermediate Users

Excel Intermediate Data & Text Manipulation

In this Excel Intermediate Data & Text Manipulation Course, you’ll learn some really useful things you can do with your data. Imagine you have a table of information, like a list of people and their ages. With these formulas, you’ll discover how to pick out specific rows, such as selecting people who are older than 30. You’ll also learn how to create new lists with only the information you need. For example, you can make a separate list that includes only the names and ages of certain individuals.

Moreover, you’ll find out how to organize your data more effectively. Imagine you have a long list of text, like a bunch of sentences. These formulas will show you techniques for finding and removing specific words or phrases from the text. You’ll also learn how to split text into different parts, which can be really helpful if you have something like a list of names and addresses all mixed together. In simple words, you’ll discover how to customize your data’s appearance so it’s easier to understand and work with.

What Will I Learn

1. CHOOSEROWS Function: You’ll learn how to extract specific rows from a dataset based on row indices or conditions.

2. DROP Function: You’ll learn how to select specific rows and columns from a dataset to create a new list.

3. EXPAND Function: You’ll learn how to expand the size of a dataset by adding rows and columns.

4. HSTACK Function: You’ll learn how to combine data from different sources horizontally (columns-wise).

5. REMOVE TEXT BEFORE-AFTER CHARACTERS: You’ll learn how to manipulate text data by removing text before or after specific characters, like commas.

6. TAKE Function: You’ll learn how to select specific rows and columns from a dataset to create a new list.

7. TOCOL Function: You’ll learn how to reshape data from a matrix-like structure into a single column.

8. TOROW Function: You’ll learn how to reshape data from a matrix-like structure into a single row.

9. VSTACK Function: You’ll learn how to combine data from different sources vertically (rows-wise).

10. WRAPCOLS and WRAPROWS Functions: You’ll learn how to place a column or row data into a new layout with specific dimensions.

11. TEXTAFTER Function: You’ll learn how to extract text after a specific keyword or character.

12. TEXTBEFORE Function: You’ll learn how to extract text before a specific keyword or character.

13. TEXTSPLIT Function: You’ll learn how to split text data into multiple parts based on delimiters.

And a lot more…