Udemy Certificate 0

Excel Basics - Data & Text Manipulation

Name: Excel Basics - Data & Text Manipulation
Price: 19.99 USD
Availability: InStock

About this course

You’ll learn how to clean and restructure data in Excel, covering duplicate detection, splitting columns with Text‑to‑Columns, and using the right cell formats. The course walks through string functions like CONCAT, TEXTJOIN, LEFT, RIGHT, MID and case conversion, then shows how to apply conditional formatting for duplicates and build basic pivot tables. It also includes guidance on page‑layout best practices for presenting spreadsheets.

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

$19.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.