Excel Basics - Data & Text Manipulation
Enroll now →
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
What you'll learn
- identify and remove duplicate records
- use Text To Columns feature
- understand delimiters
- apply concatenation and text joining techniques
- manipulate text with functions like Left, Right, Mid, Upper, Lower, and Proper
- gain a basic understanding of Conditional Formatting
- understand Pivot Table basics
- learn Page Layout Best Practices
Skills you'll gain
Related courses
Data Science Foundations
USD 49
Data Analytics in the Public Sector with R
USD 49
Data Science as a Field
USD 99
Geographic Information Systems (GIS)
USD 49
Programming for Python Data Science: Principles to Practice
USD 49
Statistical Methods and Data Analysis
USD 49
Data Visualization & Analytics in Tableau
USD 49
Enhancing Reproducible Science with GitHub and Docker
USD 49
Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.