skillfine
skillfine

Excel Text Functions

  1. Home
  2. Excel Text Functions
ashish_agarwal
ashish_agarwal
/
June 24, 2025

Excel Text Functions

4.5511
22 Enrolled
Excel
This content is for Free Trial members only.
Login Join Now
This content is for Free Trial members only.
Login Join Now

What Will I Learn?

  • Complete overview of Microsoft Excel interface
  • Data analysis in Excel
  • Data manipulation in Excel
  • Data cleaning in Excel
  • Application of TEXT functions in data analysis

Course Content

Welcome On Board: Data cleaning and analysis using TEXT functions in Excel

  • Meet Your Instructor
    01:07
  • Itinerary of this Learning trip
    04:40
  • Download the excel template for this module
    00:00
  • Illustration 1: Introduction
    01:45
  • Illustration 1: Understanding LEN, FIND, LEFT, CONCATENATE functions
    15:05
  • Illustration 2: Understanding the TRIM and FIND function
    08:35
  • Illustration 2: Understanding the LEFT and MID function
    12:28
  • Illustration 3: Introduction
    01:44
  • Illustration 3: Understanding the SEARCH function
    06:27
  • Illustration 3: Understanding the IFERROR function
    03:34
  • Illustration 3: Understanding the IF function
    00:00
  • Summing Up: Let’s relive our trip ( Quick Recap)
    00:52
  • Quiz
  • Share your thoughts
  • Live Practice Session
    00:00

About the instructor

ashish_agarwal

ashish_agarwal

Ashish is a Business and Finance Expert with around 10 years of experience in this domain. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked at McKinsey in the Strategy and Corporate Finance practice. He is also the founder of the website skillfinlearning.com which creates online programs in Business, Finance and Data Analysis topics. At Skillfin Learning, we believe we can change the way we adults learn.
4.67 (215 ratings)

33 Courses

208 students

Student Feedback

Excellent
8
Very Good
2
Average
0
Poor
1
Terrible
0
4.6
11 Reviews
D

Best course to get a good knowledge about Excel

J

The course covered a wide range of text functions, including those for extracting, formatting, and manipulating text strings. It also explored best practices for cleaning and transforming data using text functions.

LG

The course content was comprehensive and well-structured, covering a wide range of text functions available in Excel. It provided a thorough understanding of how to manipulate and analyze text data effectively. The content was presented in a clear and organized manner, making it easy to follow and apply.

A

"Excel Text Functions Mastery" course is Amazing and Also Depth Knowledge Sharing to useful for me

J

Excellent of this course!

D

I am thrilled to share my enthusiastic review of the "Excel Text Functions Mastery" course. This course offers an exceptional and comprehensive exploration of Excel's text functions, catering to both beginners and experienced users looking to enhance their data manipulation and analysis skills. The course content, expert instruction, and practical application make it an invaluable resource for anyone aiming to work efficiently with text data in Excel.

DT

Excellent , enjoyed it thoroughly refreshing my knowledge on Excel

NT

It's very helpful.

ashish_agarwal

Good witty approaches to data analysis

This course is amazing, it is extremely thorough and in depth.

Pick a plan

Enrollment validity: Membership Wise
  • Beginner
  • 22 Total Enrolled
  • 1 hour Duration
  • June 24, 2025 Last Updated
  • Certificate of completion
Durations: 1 hour
Lectures: 14
Students: Max 0
Level: Beginner
Language: English
Certificate: Yes

Material Includes

  • Annual (1 year) access
  • Take the course anytime anywhere
  • 1.5 hours on-demand video
  • Access on Mobile and Tablet

Requirements

  • None. We will teach everything from scratch.