arrow_back
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 )
Discuss (
0
)
navigate_before
Previous
Next
navigate_next