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!
You may also like
- Deceased Estates: Reporting deceased estate
- 20/20 Business Education for Healthcare Entrepreneurs
- Grant writing – Improve your win rate
- Fiverr 2023 : Learn Fiverr From Basics To Advance Level
- HR Analytics – Build Dynamic Excel Dashboard from Scratch
- Digital Transformation In Banking – Practitioner
- (Oxford) Diploma : Leadership & Cultural Diversity
- Content Marketing Funnel for Creators
- ProfitFunnel Masterclass – How To Create A Sales Funnel
- Sales Transformation Mastery: Dynamics of Modern Sales
- Marketing Professional Certification
- Master in Data Visualization and Analysis with R in 2023
- Agile HR Implementation
- Voice recording – How to record professional voice over
- Strategic Program Management
- WIN A CLIENT EVERY TIME WITH THIS OPEN HOUSE COURSE!
- Writing for a Living: Queries & Summaries
- Practical Risk Management for Business and Projects
- CPA Affiliate Amazon Marketing on Steroids – Without Website
- Excel Basics – Data & Text Manipulation