Excel Basics – Data & Text Manipulation

Excel Basics – Data & Text Manipulation, available at $44.99, has an average rating of 4.65, with 7 lectures, based on 671 reviews, and has 4406 subscribers.

You will learn about Data manipulation techniques. Formulas to manipulate text such as Upper, Lower, Proper, Left, Right, Mid, Contatenation, Concat, TextJoin Small intro to the use of Pivot Tables How to use the Text To Column feature Delimiters 101 – General versus Text This course is ideal for individuals who are Beginner level through advance students. or Anyone that works with Excel. or Anyone in a Business Analyist, Project Manager, Data Entry, Customer Service role, or in Accounting & Finance It is particularly useful for Beginner level through advance students. or Anyone that works with Excel. or Anyone in a Business Analyist, Project Manager, Data Entry, Customer Service role, or in Accounting & Finance.

Enroll now: Excel Basics – Data & Text Manipulation

Summary

Title: Excel Basics – Data & Text Manipulation

Price: $44.99

Average Rating: 4.65

Number of Lectures: 7

Number of Published Lectures: 7

Number of Curriculum Items: 7

Number of Published Curriculum Objects: 7

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Data manipulation techniques.
Formulas to manipulate text such as Upper, Lower, Proper, Left, Right, Mid, Contatenation, Concat, TextJoin
Small intro to the use of Pivot Tables
How to use the Text To Column feature
Delimiters 101 – General versus Text

Who Should Attend

Beginner level through advance students.
Anyone that works with Excel.
Anyone in a Business Analyist, Project Manager, Data Entry, Customer Service role, or in Accounting & Finance

Target Audiences

Beginner level through advance students.
Anyone that works with Excel.
Anyone in a Business Analyist, Project Manager, Data Entry, Customer Service role, or in Accounting & Finance

In this course you’ll learn how to:

Quickly identify and remove duplicate records

Break up data using the Text To Column Feature
- Learn when to use the General & Text format
- Understand delimiters

Understand how to join data from multiple cells using
- Concatenation
- Concat
- Textjoin

Learn Text manipulators
- Left, Right, Mid
- Upper, Lower, Proper

Gain a basic understanding of the Conditional Format feature to identify duplicate records

Gain a practical understanding of Pivot Table Basics

Learn Page Layout Best Practices

Course Curriculum

Chapter 1: Introduction

Lecture 1: Intro

Chapter 2: Part 1 Prepping the data file

Lecture 1: Prepping the data file

Chapter 3: Part 2 & 3 Text To Columns & Text Manipulation Formulas

Lecture 1: Text To Columns & Text manipulators

Chapter 4: Part 4 Concatenation formulas

Lecture 1: Concatenation Formulas

Chapter 5: Part 4 Continued

Lecture 1: Left, Mid, Right text formulas

Chapter 6: Pivot Table Application

Lecture 1: Intro to Pivot Tables

Chapter 7: Part 6 Page Layout Best Practices

Lecture 1: Page Layout setup

Instructors

Luis Juarez
Excel Geek

Rating Distribution

1 stars: 5 votes
2 stars: 7 votes
3 stars: 57 votes
4 stars: 256 votes
5 stars: 346 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu