Learn Excel functions to do data cleaning, data manipulation and analysis using the TEXT functions

Excel Text Functions

Learn Excel functions to do data cleaning, data manipulation and analysis using the TEXT functions

Categories Excel
4.60(10 Ratings)

What I will 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 Curriculum

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

  • 01:07
  • 04:40
  • 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

Student Feedback

Excellent
8
Very Good
1
Average
0
Poor
1
Terrible
0
4.6
10 Reviews

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.

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.

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

Excellent of this course!

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.

Excellent , enjoyed it thoroughly refreshing my knowledge on Excel

It's very helpful.

Good witty approaches to data analysis

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

Great starting point for learning Swift. If you have never programmed, or never used Swift it is a great place to start.

Requirements

  • None. We will teach everything from scratch.

Material Includes

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

FAQ's

How does the certification program work?

We have created short courses on specific skills that you will need to master in the business and finance domain. Once you go through the recorded lessons and attend practice sessions online, you will need to finish a short assessment like a quiz and an assignment and send it over. We will review your submission and send you back a score. If you obtain more than 80% result, we will award you a certification for the same.

How long does it take to complete the certification?

We have divided the certifications into very specific modules to make it very easy for you to complete any one certification in the least time possible. But really the pace of completing the certification is up to you. As soon as you send us your assignment, we will take 2-3 days to review and send over your result. So whenever you are ready, you should complete the assessment and get certified.

Can you retake the assessments?

Yes you can, we allow you to make 10 submissions per certification to ensure you have enough opportunities to clear and get certified.

Do I have access to the materials even after completing the certifications?

Yes, as long as you have an active membership, you will continue to have access to all resources to the certification.

Will I get a certification for the individual courses?

Yes, each course will have a certification provided on successful completion and taking the assessment successfully at the end of the program

Can I upload my certification online?

Yes, we will provide a LinkedIn verifiable certificate in different formats that you can add on your social media profile to get access to more opportunities. For example, You can add the certificate under the certification section of LinkedIn where recruiters look at to understand the different skills you possess.

How will we support me to find more opportunities?

We have a very active LinkedIn presence where we will showcase your certifications on completion. Ideally the more the certifications you complete the better will your chances to be noticed by other members of our LinkedIn community. Our push to your profile will potentially lead to more opportunities coming your way.

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.

Student Ratings & Reviews

4.6
Total 10 Ratings
5
8 Ratings
4
1 Rating
3
0 Rating
2
1 Rating
1
0 Rating
J
5 months ago
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
6 months ago
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
6 months ago
"Excel Text Functions Mastery" course is Amazing and Also Depth Knowledge Sharing to useful for me
J
7 months ago
Excellent of this course!
D
7 months ago
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
10 months ago
Excellent , enjoyed it thoroughly refreshing my knowledge on Excel
NT
10 months ago
It's very helpful.
ashish_agarwal
1 year ago
Good witty approaches to data analysis
3 years ago
This course is amazing, it is extremely thorough and in depth.
3 years ago
Great starting point for learning Swift. If you have never programmed, or never used Swift it is a great place to start.

Pick a plan

Enrollment validity: Membership Wise
This content is for Free Trial members only.
Login Join Now