About Course

Advanced Excel Data & Text Manipulation Course

Our Advanced Excel Data & Text Manipulation Course offers practical skills and deep knowledge. It covers techniques for effective data work, a recurring theme.

The Advance Excel Learning course starts with tasks for data and text manipulation without tricky methods. You’ll learn to select columns using CHOOSECOLS, creating new lists easily. CHOOSEROWS lets you select rows with special constants. The DROP function, combined with sorting, helps exclude unnecessary data, a key Excel learning aspect.

EXPAND is your tool for adding rows or columns. HSTACK and VSTACK merge data from different sources, a fundamental Excel skill.

You’ll explore functions like REMOVE TEXT BEFORE-AFTER CHARACTERS, TEXTAFTER, and TEXTBEFORE for text precision. They help cut and split text. The TAKE function selects required rows and columns, enhancing your Excel proficiency.

The Advanced Excel Data & Text Manipulation Course also covers data transformation. TOCOL turns rows into a column, TOROW does the opposite. WRAPCOLS and WRAPROWS change data format by organizing it into columns or rows, another critical Excel aspect.

TEXTSPLIT is introduced for splitting text into parts. You’ll become adept at sorting, stacking, transforming, and splitting data. This knowledge equips you to handle and reshape data for analysis and organization in diverse, advanced ways, making Excel learning a key expertise component.

What Will I Learn

1. CHOOSECOLS Function: You’ll learn how to extract specific columns from a data range and create a new list.

2. CHOOSECOLS Function with List Constant: Similar to the first task, but you’ll also incorporate a list constant to choose specific columns.

3. CHOOSECOLS Function with Different Columns: This task involves selecting columns 1 and 5 to create a new list.

4. CHOOSECOLS Function with List Constant (Different Columns): Similar to the previous tasks, but with columns 2, 3, and 4 and using a list constant.

5. CHOOSECOLS Function with Column Reordering: You’ll rearrange columns 3 and 4, then 4 and 3, to create a new list.

6. CHOOSECOLS Function with Reversed Order: You’ll reverse the order of columns 1 to 4 and create a new list.

7. CHOOSEROWS Function: You’ll learn how to extract specific rows from a data range using a quasi-list constant.

8. DROP Function with Rows and Columns: You’ll exclude specific rows and columns to create a new list.

9. DROP Function with Different Rows and Columns: Similar to the previous task, but with different rows and columns.

10. DROP and SORT Function: You’ll sort and drop data from a specific range.

11. DROP Function with Combined Scores: You’ll combine scores from different rounds and then drop the lowest scores.

12. EXPAND Function: You’ll expand a data range by adding rows or columns.

13. EXPAND Function with Different Rows and Columns: Similar to the previous task, with different row and column counts.

14. EXPAND Function with Left Expansion: You’ll expand the data range to the left.

15. HSTACK Function: You’ll horizontally stack data from two rows into a single row.

CHOOSECOLS: Extract specific columns using list constants.
CHOOSEROWS: Extract rows using quasi-list constant.
DROP: Exclude rows and columns, sort, combine scores and drop lowest.
EXPAND: Add rows/columns to range, differently, and expand left.
HSTACK: Stack data horizontally, unequal lists, unique winners, w/wo errors.
REMOVE TEXT: Extract portions, text after, text before.
TAKE: Extract rows and columns.
TOCOL: Transform rows to single column, with different data.
TOROW: Transform columns to single row, with different data.
VSTACK: Stack unequal lists vertically, with different data.
WRAPCOLS/WRAPROWS: Wrap data from columns/rows.
TEXTSPLIT: Split text into columns using delimiter.

Course Content

CHOOSECOLS Function

3000-A Excel Advanced Users: Place Columns 1 and 3 into a New List with Excel’s CHOOSECOLS Function

09:07
Place Columns 1 and 3 into a New List with the CHOOSECOLS Function
3001-A Excel’s CHOOSECOLS Unleashed: Creating Custom Lists with List Constants for Advanced Users

02:48
Creating Custom Lists with List Constants

DROP Function

EXPAND Function

HSTACK Function

TAKE Function

TEXTAFTER Function

TEXTBEFORE Function

TEXTSPLIT Function

TOCOL Function

TOROW Function

VSTACK Function

WRAPCOLS Function

WRAPROWS Function

Student Ratings & Reviews

4.0

Total 2 Ratings

1 Rating

0 Rating

1 Rating

0 Rating

1 year ago

I've taken other Excel courses, but this one was special. I definitely recommend it!

1 year ago

Wow, this course was great! It helped me understand advanced Excel stuff much better.

About Course

Advanced Excel Data & Text Manipulation Course

What Will I Learn

What Will You Learn?

Course Content

CHOOSECOLS Function

3000-A Excel Advanced Users: Place Columns 1 and 3 into a New List with Excel’s CHOOSECOLS Function

Place Columns 1 and 3 into a New List with the CHOOSECOLS Function

3001-A Excel’s CHOOSECOLS Unleashed: Creating Custom Lists with List Constants for Advanced Users

Creating Custom Lists with List Constants

DROP Function

3022-A Excel Advanced Users: Place Rows 1-6 and Columns 1, 2 and 3 into a New List with Excel’s DROP Function

Place Rows 1-6 and Columns 1, 2 and 3 into a New List with the DROP Function

3032 – Advanced Excel: Combining Scores from Rounds 1 and 3 with DROP Function

EXPAND Function

3040-A Advanced Excel Techniques: Transforming a 9×3 to a 9×4 List with EXPAND Function

Transforming a 9×3 to a 9×4 List with EXPAND Function

3043-A Excel Advanced: Expand a 9×3 List Left and Up to a 12×4 List with Excel’s EXPAND Function

Expand a 9×3 List Left and Up to a 12×4 List with the EXPAND Function

HSTACK Function

3052-A Excel Pro Strategies: Identifying Unique Winners and Merging via HSTACK

Identifying Unique Winners and Merging via HSTACK

3054-A Excel Advanced: Combine Two Unequal Sized List into a One with Excels HSTACK Function

Combine Two Unequal Sized List into a One with the HSTACK Function

TAKE Function

3075-A Combine the First 4 Rows and 3 Columns with Excel’s TAKE Function for Advanced Users

Combine the First 4 Rows and 3 Columns with the TAKE Function

3076-A Advanced Users: Combine All Columns and Only Rows 1 and 2 in a New List with Excel’s TAKE Function

Combine All Columns and Only Rows 1 and 2 in a New List with the TAKE Function

TEXTAFTER Function

4000-A Advanced Excel Techniques: Creating New Lists with Only Last Names Using TEXTAFTER

Creating New Lists with Only Last Names Using TEXTAFTER

4005-A Excel Advanced Users: Show All Text After 2nd Comma with Excel’s TEXTAFTER Function

4005 Show All Text the 2nd Comma

TEXTBEFORE Function

4012-A Excel Beginners Tutorial: Using TEXTBEFORE to Show Only the First Name

Use TEXTBEFORE to Show Only the First Name

TEXTSPLIT Function

4029-A Excel’s Advanced Techniques: Creating Three-Column Fruit Lists with TEXTSPLIT

Create Three-Column Fruit Lists with TEXTSPLIT

4038-A Excel Advanced: Separate Fruit, Score and Rating into Column 1, 2 and 3 with Excel’s TEXTSPLIT Function

Separate Fruit, Score and Rating into Column 1, 2 and 3 with the TEXTSPLIT Function

TOCOL Function

3085-A Advanced Users: Combining Rows 1-3 and 1-2 with Excel’s TOCOL Function

Combine Rows 1-3 and 1-2 with the TOCOL Function

TOROW Function

3095-A Unleashing Excel’s TOROW: Creating a Single Row from Two Lists (Rows 1-3 and 1-2)

Creating a Single Row from Two Lists (Rows 1-3 and 1-2)

VSTACK Function

3104-A Excel’s VSTACK: Advanced Strategies for Merging Lists Like a Pro

VSTACK: Merging Lists Like a Pro

WRAPCOLS Function

3120-A Advanced Excel Data Manipulation: Sorting and Wrapping Columns into a 10×2 List

Sorting and Wrapping Columns into a 10×2 List

WRAPROWS Function

3131-A Beyond the Basics: Advanced Techniques for Creating 3-Row by 3-Column Lists with WRAPROWS

Creating 3-Row by 3-Column Lists with WRAPROWS

Student Ratings & Reviews

Company

Support