Text Manipulation: Beginners

Excel Beginner Data & Text Manipulation

In our introductory Excel Beginner Data & Text Manipulation course, you’ll explore the power of formulas that simplify text manipulation. With these tools, you can effortlessly reorganize columns, filter specific rows or columns, and create new data combinations. Think of it as rearranging your toys for more enjoyment.

Moreover, you’ll become adept at working with text data. For example, you can instruct Excel to extract text following a comma or split text into segments. It’s akin to solving word puzzles to pinpoint the precise information you seek. These formulas empower you to select specific data components, making data analysis efficient, much like preparing a quick snack instead of a full meal. With these Excel training courses, you’ll gain the skills to excel in various creative data tasks.

What Will I Learn

Each task involves manipulating data using specific Excel functions. I’ll provide a brief explanation of what each task is about and what you will learn from it:

1. CHOOSECOLS Function: You’ll learn how to rearrange columns in a specific order using the CHOOSECOLS function.

2. Quasi-List and CHOOSECOLS Function: You’ll learn how to create a new list by selecting specific columns from an existing data range using the CHOOSECOLS function.

3. CHOOSEROWS Function: You’ll learn how to extract specific rows from a data range using the CHOOSEROWS function.

4. CHOOSEROWS Function with Quasi-List: You’ll learn how to select certain rows from a data range using the CHOOSEROWS function, based on a quasi-list.

5. Combine Scores using CHOOSECOLS Function: You’ll learn how to combine data from two specific columns into a new list using the CHOOSECOLS function.

6. TAKE Function: You’ll learn how to extract a specific number of rows and columns from a data range using the TAKE function.

7. TOCOL Function: You’ll learn how to transform a range of columns into a single column using the TOCOL function.

8. TOROW Function: You’ll learn how to transform a range of rows into a single row using the TOROW function.

9. VSTACK Function: You’ll learn how to vertically stack multiple lists to create a new list using the VSTACK function.

10. WRAPCOLS and WRAPROWS Functions: You’ll learn how to wrap or combine rows and columns to create new lists using the WRAPCOLS and WRAPROWS functions.

11. TEXTAFTER Function: You’ll learn how to extract text from a specific position in a string using the TEXTAFTER function.

12. TEXTSPLIT Function: You’ll learn how to split text strings based on specific delimiters and place the results into rows and columns using the TEXTSPLIT function.

And a lot more