Share Description
In this course, you will learn
- Create Averages with outliers
- Create dynamic concatenations
- Create robust Regular Expressions formulas
- Understand types of Joins and how they work
- Parse data using Text to Columns
- Create Percentage Format
- Convert date to string formats and string to date formats
- Create Generate Rows for loop expressions
- Work with Transposing and Appending data
- Perform Log Transformations
- Create Time Differences
- Combine Merged Strings
- Create Running Averages
- Determine distance using Spatial tools
- Find Missing Values
- Create Batch Macros
- Create In-Database Connection
- Create In-Database Joining and Aggregation
- Work with Fuzzy Matching
- Count Key Words
- Combine Files from Single Input
- Create Multi-Row Formulas
- Perform Data Cleansing
- Create Dynamic Variables
