Excel’s Best Data Cleaning Tricks (Updated 2022)

سرفصل های دوره

Excel's best data cleaning tricks - a course to supercharge your Excel productivity in 1.5 hrs

1. Go To (Special) - select cells by specific criteria

1.1 Go To - Special.xlsx

1. Use Go To (Special) feature - to locate errors and formula inconsistency

2. Use Go To (Special) feature - to fill up blank cells logically

3. Use Go To (Special) feature - for smart formatting

4. Quiz related to Go To - Special.html

2. FlashFill - automatically gives solution based on sample pattern

1.1 FlashFill.xlsx

1. Basics of FlashFill (Ctrl E) - Dos & Donts

2. Project - Extract complex bank details using FlashFill & Formulas

3. Project - Cleanup electricity usage details using FlashFill, Find & Replace

4. Quiz related to Flash Fill.html

3. Find & Replace

1.1 Find & Replace.xlsx

1. Find & Replace - Basics

2. Find & Replace - with wildcard characters

3. Find & Replace - Hidden tricks

4. Quiz related to Find and Replace.html

4. Text formulas - Extract relevant data and cleanup unformatted data

1. Use LEFT, RIGHT, MID and VALUE - to extract data

2.1 Text Formulas.xlsx

2. Use SEARCH with MID - to extract data

3. Use TRIM, LEN, SUBSTITUTE - to cleanup data

4. Use UPPER, PROPER, LOWER - to change case

5. Quiz related to Text Formulas.html

5. Text to Columns - split data into multiple cells

1.1 Text to Columns.xlsx

1. Text to Columns - Delimiter vs. Fixed Width

2. Text to Columns - Format Change (Date)

3. Text to Columns - Troubleshoot hanging formulas

4. Quiz related to Text to Columns.html

6. Concatenate - Join data in one cell

1.1 Concatenate - Join Strings.xlsx

1. CONCATENATE (Basics) - using two methods

2. CONCATENATE vs. FlashFill

3. CONCATENATE vs. & vs. TEXTJOIN vs. CONCAT - Who is the best

4. Performing Concatenation using different methods in Excel.html

7. Excel's Power Query for Data Preparation

1.1 Power Query - Data Cleansing.xlsx

1. Power Query's feature - Split to Rows vs. Excel's Text to Columns

2. Power Query's feature - UnPivot columns

3. Quiz related to Power Query.html

8. Dealing with Duplicates

1.1 Duplicates.xlsx

1. Using Remove Duplicates feature vs. UNIQUE

2. Use COUNTIFS to detect duplicates

3. Quiz related to Remove or Recognize duplicates.html

9. Formatting tricks

1.1 Formatting.xlsx

1. Formatting tricks - Clear Format, Double-click Format Painter

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training