Powerbi & Advance Excel
PowerBi & Advance Excel
Power Bi Training : Beginning to Advance Level
1. Column Chart
2. Stacked Column Chart
3. Pie Chart
4. Donut Chart
5. Funnel Chart
6. Ribbon Chart
7. Include & Exclude
8. View Data & Export
9. MAP
10. Filled Map
11. Map With Pie Chart
12. Map Formatting
13. Background Change in Map
14. Creating A Simple Table
15. Formatting a Table
16. Conditional Formatting in Table
17. Change Aggregation in Table
18. Creating A Simple Matrix
19. Conditional Formating in Matrix
20. Hirearchies in Matrix
21. SubTotal and Total in Matrix
22. Number Formatting in Matrix and Table
23. Line Chart
24. Drill Down in Line Chart
25. Area Chart
26. Line vs Column Chart
27. Scatter Plot
28. Water Fall Chart
29. Tree Map
30. Guage Chart
31. Number Card
32. Text Card
33. Date Card
35. Multi Row Card
36. Filter on Visual
37. Filter on Page
38. Filter in all Page
39. Drill Through
40. Text Slicer
41. Format Text Slicer
42. Date Slicer
44. Slicer for Number
45. Insert Objects
46. Index
47. BookMark Action
48. DrillThrough Action
49. Text Functions in Power Query
Merge
Split and Trim
Upper, Lower and Proper
Add Suffix and Prefix
LEFT, RIGHT AND MID
EXTRACT TEXT WITH DELIMITER
50. Date Function in Power Query
Year Quater,Month,Day
Difference between Dates,Earliest and Latest
Name of Day and Name of Month
Day of Week/Month/Year & Week of Month/Year
Extract Date from Date & Time
Calculate Age in 2 Button Clicks
Which Day of Year,Quarter,Month your date of Birth Is
51. Appending Files and Tables in Power BI
Append Multiple CSV Files from a Folder
Append Multiple excel tables/Sheets from Single file
Append Excel Table with different number of Columns
Append multiple excel files from a Folder
Append different data source files in Power Query
52. Merging Files and Tables in Power BI-[ Vlookup Without Formula]
Merge Data from multiple Excel Files/Workbooks in Power Query
Merging Table/Sheets
Merge Data from different Data Sources in Power Query (Power BI)
Merge Data having multiple matching Columns or multiple Criteria in Power Query
53. Columns from Examples and Conditional Column in Power Bi Column from Examples on Splitting Text
Column From Examples on Merging Text Column from Examples on Alphanumeric Data Conditional Column on one Column Conditional Column on two Columns
Conditional Column Comparing two column values Conditional Column on Dates
54. Important Topic in Power BI Fill Down and Fill Up
Grouping Transpose UnPivot
Replace Error and Values Keep Rows and Remove Rows Add, Remove ,GoTO Columns
55 DAX Function RELATED
Day Month QUARTER
Year Weeknum WEEKDAY
Today() Now() Datediff DATEADD
STARTOFMONTH ENDOFMONTH
EoMonth UPPER
Lower LEFT RIGHT
Mid Trim Len
Concatenate Search SUBSTITUTE
If IFERROR
And OR
56. Dashboard
57. Power BI Service
Excel Training
》Lesson 1 - Introduction of Excel
》Lesson 2- Data Entry & Basic formulas in Excel
》Lesson 3- Sorting Data in Excel
》Lesson 4- Filter Data in Excel
》Lesson 5- Advance Filter in Excel
》Lesson 6 - Data Validation in Excel
》 Lesson 7- Conditional Formatting in Excel
》Lesson 8- Text to Columns & Flash Fill
》Lesson 9- Remove Duplicates & Unique Formula
》Lesson 10 -Paste Special in Excel
》Lesson 11- IF Formula in Excel
》Lesson 12- IF with AND Formula in Excel
》Lesson 13 - IF with OR Formula in Excel
》 Lesson 14 - Nested IF Formula in Excel
》Lesson 15 - SUMIF and COUNTIF
》Lesson 16 - Sumifs and Countifs
》Lesson 17 - Match and Index Formula
》Lesson 18 - Vlookup and Hlookup Formula
》Lesson 19- Text Formula in Excel
》Lesson 20- Date Formula in Excel
》Lesson 21- Pivot Table in Excel
》Lesson 22- Pivot Chart In Excel
》Lesson 23- Slicer in Pivot Table
》Lesson 24- Timeline and Pivot Table Option
》Lesson 25- Sort and Filter Formula
》Lesson 26- Financial Function in Excel
》Lesson 27- Xlookup Formula in Excel
》Lesson 28 - Printing Tips in Excel
》Lesson 29 -Macro and Add-ins in Excel
》Lesson 30 - Offset Function in Excel
》Lesson 31- Data Validation in Excel
》Lesson 32- Use of ChatGPT in Excel
Power Bi Training : Beginning to Advance Level
1. Column Chart
2. Stacked Column Chart
3. Pie Chart
4. Donut Chart
5. Funnel Chart
6. Ribbon Chart
7. Include & Exclude
8. View Data & Export
9. MAP
10. Filled Map
11. Map With Pie Chart
12. Map Formatting
13. Background Change in Map
14. Creating A Simple Table
15. Formatting a Table
16. Conditional Formatting in Table
17. Change Aggregation in Table
18. Creating A Simple Matrix
19. Conditional Formating in Matrix
20. Hirearchies in Matrix
21. SubTotal and Total in Matrix
22. Number Formatting in Matrix and Table
23. Line Chart
24. Drill Down in Line Chart
25. Area Chart
26. Line vs Column Chart
27. Scatter Plot
28. Water Fall Chart
29. Tree Map
30. Guage Chart
31. Number Card
32. Text Card
33. Date Card
35. Multi Row Card
36. Filter on Visual
37. Filter on Page
38. Filter in all Page
39. Drill Through
40. Text Slicer
41. Format Text Slicer
42. Date Slicer
44. Slicer for Number
45. Insert Objects
46. Index
47. BookMark Action
48. DrillThrough Action
49. Text Functions in Power Query
Merge
Split and Trim
Upper, Lower and Proper
Add Suffix and Prefix
LEFT, RIGHT AND MID
EXTRACT TEXT WITH DELIMITER
50. Date Function in Power Query
Year Quater,Month,Day
Difference between Dates,Earliest and Latest
Name of Day and Name of Month
Day of Week/Month/Year & Week of Month/Year
Extract Date from Date & Time
Calculate Age in 2 Button Clicks
Which Day of Year,Quarter,Month your date of Birth Is
51. Appending Files and Tables in Power BI
Append Multiple CSV Files from a Folder
Append Multiple excel tables/Sheets from Single file
Append Excel Table with different number of Columns
Append multiple excel files from a Folder
Append different data source files in Power Query
52. Merging Files and Tables in Power BI-[ Vlookup Without Formula]
Merge Data from multiple Excel Files/Workbooks in Power Query
Merging Table/Sheets
Merge Data from different Data Sources in Power Query (Power BI)
Merge Data having multiple matching Columns or multiple Criteria in Power Query
53. Columns from Examples and Conditional Column in Power Bi Column from Examples on Splitting Text
Column From Examples on Merging Text Column from Examples on Alphanumeric Data Conditional Column on one Column Conditional Column on two Columns
Conditional Column Comparing two column values Conditional Column on Dates
54. Important Topic in Power BI Fill Down and Fill Up
Grouping Transpose UnPivot
Replace Error and Values Keep Rows and Remove Rows Add, Remove ,GoTO Columns
55 DAX Function RELATED
Day Month QUARTER
Year Weeknum WEEKDAY
Today() Now() Datediff DATEADD
STARTOFMONTH ENDOFMONTH
EoMonth UPPER
Lower LEFT RIGHT
Mid Trim Len
Concatenate Search SUBSTITUTE
If IFERROR
And OR
56. Dashboard
57. Power BI Service
Excel Training
》Lesson 1 - Introduction of Excel
》Lesson 2- Data Entry & Basic formulas in Excel
》Lesson 3- Sorting Data in Excel
》Lesson 4- Filter Data in Excel
》Lesson 5- Advance Filter in Excel
》Lesson 6 - Data Validation in Excel
》 Lesson 7- Conditional Formatting in Excel
》Lesson 8- Text to Columns & Flash Fill
》Lesson 9- Remove Duplicates & Unique Formula
》Lesson 10 -Paste Special in Excel
》Lesson 11- IF Formula in Excel
》Lesson 12- IF with AND Formula in Excel
》Lesson 13 - IF with OR Formula in Excel
》 Lesson 14 - Nested IF Formula in Excel
》Lesson 15 - SUMIF and COUNTIF
》Lesson 16 - Sumifs and Countifs
》Lesson 17 - Match and Index Formula
》Lesson 18 - Vlookup and Hlookup Formula
》Lesson 19- Text Formula in Excel
》Lesson 20- Date Formula in Excel
》Lesson 21- Pivot Table in Excel
》Lesson 22- Pivot Chart In Excel
》Lesson 23- Slicer in Pivot Table
》Lesson 24- Timeline and Pivot Table Option
》Lesson 25- Sort and Filter Formula
》Lesson 26- Financial Function in Excel
》Lesson 27- Xlookup Formula in Excel
》Lesson 28 - Printing Tips in Excel
》Lesson 29 -Macro and Add-ins in Excel
》Lesson 30 - Offset Function in Excel
》Lesson 31- Data Validation in Excel
》Lesson 32- Use of ChatGPT in Excel
Send Enquery