How to Format and Clean Data in Excel // Excel for scientists Series Lesson 2

Format your data, text, and numbers.

In this video, I show you how to separate text into different columns using delimiters. Then, we format text including changing capitalization, combining text, and separating non-delimited text. We then will move on to formatting numbers including formatting dates, changing decimal places, rounding numbers, and formatting money. Finally, we work through conditional formatting.

---------------------------------------------------------------------------------------------------------------------------
Follow me:

My Filming Setup:

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you.

Timestamps
0:00 Formatting data in Excel
00:21 Formatting Text in Excel
00:59 Separating Text in Columns
04:27 Format Text in Excel
04:53 Changing Capitalization of text in Excel
07:02 Pull specific text from a column
10:59 Formatting Numbers in Excel
11:59 Formatting Dates in Excel
13:37 Change the number of decimal places displayed
17:10 Formatting Money in Excel
17:31 Converting Measurements in Excel
19:07 Conditional Formatting in Excel
21:39 Visualizing data on a Scale with Conditional formatting in Excel
24:11 Data Fills
25:29 Find Duplicates with Conditional Formatting
27:38 Combining text in Excel