Preview Microsoft Power Query ( Hindi - English )

Course content

Section Materials

Exercise Files

Section 1 : Text Functions

1.1 Text Functions

1.2 Split

1.3 Left Right Mid

1.4 Delimeter

1.5 Add Prefix-Suffix

Quiz

Section 1 Text Functions

Assignment

Text Functions

Section 2 : Date Functions

2.1 DATE FUNCTIONS

2.2 Start End Month Quarter Year -converted

2.3 find age

2.4 Difference

Quiz

Section 2 Date Functions

Assignment

Date functions

Section 3 : Number Functions

3.1 Round Functions

3.2 Basic functions

3.3 Percentage

Quiz

Section 3 Number Functions

Assignment

Number Functions

Section 4 : Append Queries

4.1 Append-Sheets

4.2 Append-Data Source Settings

4.3 Append-Tables In Same Files

4.4 Append-QuickMethod

4.5 Append-Tables With Different Number Of Columns

4.6 Append-Different Data Sources

4.7 Append-Multiple CSV Files

4.8 Append-Multiple Excel Files

Quiz

Section 4 Append Queries

Assignment

Append Queries

Section 5 : Merge Queries

5.1 Merge Queries In Same Files

5.2 Merge FromDifferent Excel Files

5.3 Merge From Different Data Sources

5.4 Multiple Matching Columns

5.5 Find Common Records In Tables

Quiz

Section 5 Merge Queries

Assignment

Merged Queries

Section 6 : Data Cleaning Part 1

6.1 DataCleaning-Rename Duplicate And Blank Rows

6.2 DataCleaning-Promote Headers

6.3 DataCleaning-Data Type

6.4 DataCleaning-Fixing Errors

6.5 DataCleaning-Unpivot Columns

6.6 DataCleaning-Unpivot Colunms Ex-2

Quiz

Section 6 Data Cleaning Part 1

Assignment

Data Cleaning Part 1

Section 7 : Data Cleaning Part 2

7.1 DataCleaning-Choose Columns

7.2 DataCleaning-Remove Columns

7.3 DataCleaning-Remove Rows

7.4 DataCleaning-Keep Rows

Quiz

Section 7 Data Cleaning Part 2

Assignment

Data Cleaning Part 2

Section 8 : Miscellaneous Topics

8.1 MiscTopic-Fill Down

8.2 MiscTopic-Transpose

8.3 MiscTopic-Reverse Rows

8.4 MiscTopic-Data Preview

8.5 MiscTopic-Group By

Quiz

Section 8 Miscellaneous Topics

Assignment

Miscellaneous Topics.

Section 9 : M Functions

9.1 MFunctions-Advanced Editor

9.2 MFunctions-Date Add Function

9.3 MFunctions-Date Is In Previous

9.4 MFunctions-Date is In Current

9.5 MFunctions-Date Is In Next

9.6 MFunctions-Text FunctionsP1

9.7 MFunctions-Text FunctionsP2

9.8 MFunctions-Number

9.9 MFunctions-Shortcuts

Quiz

Section 9 M Functions

Assignment

M Functions.

Section 10 : CFE & Conditional Column

10.1 CC and CFE-Numbers

10.2 CC and CFE-Text

10.3 CC and CFE-Date

10.4 CC and CFE-Compare

10.5 CC and CFE-Example1

10.6 CC and CFE-Example2

10.7 CC and CFE-Example3

10.8 CC and CFE-AlphaNumeric

Quiz

Section 10 CFE & Conditional

Assignment

10.5 Conditional Column & CFE .

Section 11 : Sort & Filter

11.1 Sort and Filter-Sort

11.2 Sort and Filter-Filler

11.3 Sort and Filter-Advanced Filter

Quiz

Section 11 Sort & Filter

Assignment

Sort & Filter.

Section 12 : Case Studies

12.1 CaseStudy-Clean Payroll Data

12.2 CaseStudy-Get File Names from Folder

12.3 CaseStudy-Find Working Days

12.4 CaseStudy-Exclude Holidays

12.5 CaseStudy-Split in Rows

12.6 CaseStudy-Append Multiple Tables

12.7 CaseStudy-Stacked Address Table

12.8 CaseStudy-Financial Case Study

Quiz

Section 12 Case Studies

Section 13 : Get Data From PDF, WEB & CSV

13.1 GetData-From PDF

13.2 GetData-From Web

13.3 GetData-From MS-Access

13.4 GetData-Enter Data

13.5 GetData-From Querry Options

Quiz

Section 13 Get Data From PDF, WEB & CSV

Assignment

Get data from PDF, Get Data From PDF, WEB & CSV.

Project

EPQ Project Output

Preview - Microsoft Power Query ( Hindi - English )