Course Outline
- Get and Transform Data
- How to import data from different resources
- How to import data from website
- Split Column techniques
- Merge Columns techniques
- Contemporary Data Transformation techniques
- Merge Queries like VLOOKUP Option
- Append Queries
- Unpivot columns
- Pivot values
- Add Custom Columns
- Append data from different worksheets using Append function
- Append Workbooks from Folder
- Combine Worksheets from Folder
- Combine tables from same worksheets
- Group Rows based on their values
- Apply Formulas for workbooks
- Get file names from Folders
- Clean Rough data with repeating headings
- Clean Multi Header data
- Play with Dates / Times
- Get dates, months, years, weeks, quarters from date value
- Calculate Time, Hours, Minutes from the time datasets