Udemy Certificate 0

Excel Basics - Data & Text Manipulation

About this course

In this course you'll learn how to:Quickly identify and remove duplicate recordsBreak up data using the Text To Column FeatureLearn when to use the General & Text format Understand delimitersUnderstand how to join data from multiple cells usingConcatenationConcatTextjoinLearn Text manipulatorsLeft, Right, MidUpper, Lower, ProperGain a basic understanding of the Conditional Format feature to identify duplicate recordsGain a practical understanding of Pivot Table BasicsLearn Page Layout Best Practices

55/100

CourseAsk score

What the provider tells you: 31/45
Who stands behind it: 8/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

Identify and remove duplicate records efficiently
Split and parse data using Text‑to‑Columns and delimiters
Apply General and Text number formats appropriately
Combine cell contents with CONCAT, TEXTJOIN and other string functions
Extract substrings with LEFT, RIGHT, MID and adjust text case
Use conditional formatting to highlight duplicates
Create basic pivot tables to summarize data
Arrange worksheet layout for clear presentation

Course objectives

Teach practical Excel tools for data cleaning and manipulation
Demonstrate how to transform and combine text data
Introduce foundational pivot‑table techniques and formatting standards

Data Analysis #excel #data manipulation #data analysis #pivot tables #excel functions #conditional formatting #data management #spreadsheet #text manipulation #text functions #text to column #concatenation #duplicate removal #text to columns #general format #text format #delimiters #textjoin #left function #right function #mid function #upper case #lower case #proper case #pivot table #page layout

Discounted on Udemy

List price $19.99. Udemy runs frequent sales, so the checkout price is usually far lower. We do not receive the live sale price, so we do not guess it — open the course to see today's.

See today's price

You'll be redirected to Udemy to complete enrollment.