arrow_back
Back
lock
Course content
lock
Section Materials
lock
Exercise Files
lock
Section 1 : Text Functions
lock
1.1 Text Functions
lock
1.2 Split
lock
1.3 Left Right Mid
lock
1.4 Delimeter
lock
1.5 Add Prefix-Suffix
lock
Quiz
lock
Section 1 Text Functions
lock
Assignment
lock
Text Functions
lock
Section 2 : Date Functions
lock
2.1 DATE FUNCTIONS
lock
2.2 Start End Month Quarter Year -converted
lock
2.3 find age
lock
2.4 Difference
lock
Quiz
lock
Section 2 Date Functions
lock
Assignment
lock
Date functions
lock
Section 3 : Number Functions
lock
3.1 Round Functions
lock
3.2 Basic functions
lock
3.3 Percentage
lock
Quiz
lock
Section 3 Number Functions
lock
Assignment
lock
Number Functions
lock
Section 4 : Append Queries
lock
4.1 Append-Sheets
lock
4.2 Append-Data Source Settings
lock
4.3 Append-Tables In Same Files
lock
4.4 Append-QuickMethod
lock
4.5 Append-Tables With Different Number Of Columns
lock
4.6 Append-Different Data Sources
lock
4.7 Append-Multiple CSV Files
lock
4.8 Append-Multiple Excel Files
lock
Quiz
lock
Section 4 Append Queries
lock
Assignment
lock
Append Queries
lock
Section 5 : Merge Queries
lock
5.1 Merge Queries In Same Files
lock
5.2 Merge FromDifferent Excel Files
lock
5.3 Merge From Different Data Sources
lock
5.4 Multiple Matching Columns
lock
5.5 Find Common Records In Tables
lock
Quiz
lock
Section 5 Merge Queries
lock
Assignment
lock
Merged Queries
lock
Section 6 : Data Cleaning Part 1
lock
6.1 DataCleaning-Rename Duplicate And Blank Rows
lock
6.2 DataCleaning-Promote Headers
lock
6.3 DataCleaning-Data Type
lock
6.4 DataCleaning-Fixing Errors
lock
6.5 DataCleaning-Unpivot Columns
lock
6.6 DataCleaning-Unpivot Colunms Ex-2
lock
Quiz
lock
Section 6 Data Cleaning Part 1
lock
Assignment
lock
Data Cleaning Part 1
lock
Section 7 : Data Cleaning Part 2
lock
7.1 DataCleaning-Choose Columns
lock
7.2 DataCleaning-Remove Columns
lock
7.3 DataCleaning-Remove Rows
lock
7.4 DataCleaning-Keep Rows
lock
Quiz
lock
Section 7 Data Cleaning Part 2
lock
Assignment
lock
Data Cleaning Part 2
lock
Section 8 : Miscellaneous Topics
lock
8.1 MiscTopic-Fill Down
lock
8.2 MiscTopic-Transpose
lock
8.3 MiscTopic-Reverse Rows
lock
8.4 MiscTopic-Data Preview
lock
8.5 MiscTopic-Group By
lock
Quiz
lock
Section 8 Miscellaneous Topics
lock
Assignment
lock
Miscellaneous Topics.
lock
Section 9 : M Functions
lock
9.1 MFunctions-Advanced Editor
lock
9.2 MFunctions-Date Add Function
lock
9.3 MFunctions-Date Is In Previous
lock
9.4 MFunctions-Date is In Current
lock
9.5 MFunctions-Date Is In Next
lock
9.6 MFunctions-Text FunctionsP1
lock
9.7 MFunctions-Text FunctionsP2
lock
9.8 MFunctions-Number
lock
9.9 MFunctions-Shortcuts
lock
Quiz
lock
Section 9 M Functions
lock
Assignment
lock
M Functions.
lock
Section 10 : CFE & Conditional Column
lock
10.1 CC and CFE-Numbers
lock
10.2 CC and CFE-Text
lock
10.3 CC and CFE-Date
lock
10.4 CC and CFE-Compare
lock
10.5 CC and CFE-Example1
lock
10.6 CC and CFE-Example2
lock
10.7 CC and CFE-Example3
lock
10.8 CC and CFE-AlphaNumeric
lock
Quiz
lock
Section 10 CFE & Conditional
lock
Assignment
lock
10.5 Conditional Column & CFE .
lock
Section 11 : Sort & Filter
lock
11.1 Sort and Filter-Sort
lock
11.2 Sort and Filter-Filler
lock
11.3 Sort and Filter-Advanced Filter
lock
Quiz
lock
Section 11 Sort & Filter
lock
Assignment
lock
Sort & Filter.
lock
Section 12 : Case Studies
lock
12.1 CaseStudy-Clean Payroll Data
lock
12.2 CaseStudy-Get File Names from Folder
lock
12.3 CaseStudy-Find Working Days
lock
12.4 CaseStudy-Exclude Holidays
lock
12.5 CaseStudy-Split in Rows
lock
12.6 CaseStudy-Append Multiple Tables
lock
12.7 CaseStudy-Stacked Address Table
lock
12.8 CaseStudy-Financial Case Study
lock
Quiz
lock
Section 12 Case Studies
lock
Section 13 : Get Data From PDF, WEB & CSV
lock
13.1 GetData-From PDF
lock
13.2 GetData-From Web
lock
13.3 GetData-From MS-Access
lock
13.4 GetData-Enter Data
lock
13.5 GetData-From Querry Options
lock
Quiz
lock
Section 13 Get Data From PDF, WEB & CSV
lock
Assignment
lock
Get data from PDF, Get Data From PDF, WEB & CSV.
lock
Project
lock
EPQ Project Output
Preview - Microsoft Power Query ( Hindi - English )
Discuss (
0
)
navigate_before
Previous
Next
navigate_next