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.40(5 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

  • 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
4
Very Good
0
Average
0
Poor
1
Terrible
0
4.4
5 Reviews

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

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.

FAQ's

Why is this course free?

Our instructors do spend a good amount of time to create this course so the quality is not compromised. Yet they have partnered with us to provide their knowledge without any cost so that you can have access to the courses free.

How long do I have access to this course?

You will have 1 month access to this online program to complete and get the certification for the same. After 1 month, your course access will automatically stop. So we recommend that you complete this course within the overall time since it is a short course of 1-1.5hr.

Will I get a certificate for the course?

Yes we do provide a certification for the course on completing and taking a short assessment for the same in the form of a quiz.

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.

I want to ask something else. How to contact you?

Please feel free to drop an email at [email protected] for any specific queries you may have. We will be more than happy to hear from you.

Student Ratings & Reviews

4.4
Total 5 Ratings
5
4 Ratings
4
0 Rating
3
0 Rating
2
1 Rating
1
0 Rating
Excellent , enjoyed it thoroughly refreshing my knowledge on Excel
NT
3 weeks ago
It's very helpful.
ashish_agarwal
4 months ago
Good witty approaches to data analysis
2 years ago
This course is amazing, it is extremely thorough and in depth.
2 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 Premium and Trial members only.
Login Join Now