~Get Your Files Here !

  1. Create Useful Text Columns for Data Analysis

   1. The Importance of Clean Text Columns.vtt

   2. Replace a String with SUBSTITUTE.vtt

   3. Identify Text Positions with SEARCH.vtt

   4. Cut Out Text Parts with LEFT, MID, and RIGHT.vtt

   5. Capitalizing Text with UPPER and REP.vtt

   6. Join Text Strings with COMBINEVALUES.vtt

  2. Create Calendar Columns for Data Analysis

   1. Understand the Importance of Calendar Columns for Data Analysi.vtt

   2. Create the Last and First Date in a Week with WEEKDAY.vtt

   3. Create a Year and Month Column with FORMAT.vtt

   4. Create Last Date in Month Columns with EOMONTH.vtt

   5. Create the First Day in the Last and Next Month with DATEADD.vtt

   6. Create the First Date of the Month with DATE.vtt

   7. Comparing American and European Options with WEEKNUM.vtt

   8. Create Week Number Columns with WEEKNUM.vtt

  playlist.m3u