Categorization of Students Grades using INDEX and XMATCH in Excel
Excellence Made Easy
Categorization of Students Grades using INDEX and XMATCH in Excel
2:01
Text-to-Rows with Power Query
Excellence Made Easy
Text-to-Rows with Power Query
1:01
Process Capability Calculator: Leveraging the Power of R Language and Shiny Apps in Six Sigma
Excellence Made Easy
Process Capability Calculator: Leveraging the Power of R Language and Shiny Apps in Six Sigma
1:33
Build Interactive Graphs with Pivot Charts in Excel
Excellence Made Easy
Build Interactive Graphs with Pivot Charts in Excel
1:31
Pivot Data with COUNTIFS and SUMIFS in Excel
Excellence Made Easy
Pivot Data with COUNTIFS and SUMIFS in Excel
1:31
Prioritization Matrix with MS Excel
Excellence Made Easy
Prioritization Matrix with MS Excel
1:31
Build Real-Time Monkeypox Cases Dashboard with Power Query
Excellence Made Easy
Build Real-Time Monkeypox Cases Dashboard with Power Query
4:27
Pivot and Unpivot Data with Excel Power Query
Excellence Made Easy
Pivot and Unpivot Data with Excel Power Query
2:01
Automate Data Wrangling and Analysis in Excel with Power Query
Excellence Made Easy
Automate Data Wrangling and Analysis in Excel with Power Query
3:25
Pareto Chart: Expose the Vital Few Contributors in Your Data Visualization
Excellence Made Easy
Pareto Chart: Expose the Vital Few Contributors in Your Data Visualization
3:23
Creating Vital Few Visuals with Treemaps and Maps
Excellence Made Easy
Creating Vital Few Visuals with Treemaps and Maps
2:08
Convert Numbers to Words in Excel
Excellence Made Easy
Convert Numbers to Words in Excel
2:40
Building Gauge Visualization in Excel
Excellence Made Easy
Building Gauge Visualization in Excel
2:23
Combine Cells in Excel using the TEXTJOIN Function
Excellence Made Easy
Combine Cells in Excel using the TEXTJOIN Function
1:01
Using Goal Seek to Back-Solve a Formula
Excellence Made Easy
Using Goal Seek to Back-Solve a Formula
1:00
Creating a Heatmap using XLOOKUP and Conditional Formatting
Excellence Made Easy
Creating a Heatmap using XLOOKUP and Conditional Formatting
1:31
When is Using “SWITCH” Function More Efficient Than Using “IFS” in Excel
Excellence Made Easy
When is Using “SWITCH” Function More Efficient Than Using “IFS” in Excel
1:01
Using IFS Function instead of Nested IF in Excel
Excellence Made Easy
Using IFS Function instead of Nested IF in Excel
1:31
NLP in Excel with the Analyze Data Wizard
Excellence Made Easy
NLP in Excel with the Analyze Data Wizard
1:35
Using Nested XLOOKUP
Excellence Made Easy
Using Nested XLOOKUP
1:31
XLOOKUP to Replace VLOOKUP and HLOOKUP
Excellence Made Easy
XLOOKUP to Replace VLOOKUP and HLOOKUP
1:28
Re-arrange Columns
Excellence Made Easy
Re-arrange Columns
0:53
Force Unique Entries in Cells
Excellence Made Easy
Force Unique Entries in Cells
1:01
Use Space as Intersecting Operator
Excellence Made Easy
Use Space as Intersecting Operator
0:48
Count a Weekday between Two Dates
Excellence Made Easy
Count a Weekday between Two Dates
1:08
Convert Number to Date
Excellence Made Easy
Convert Number to Date
0:55
Custom Cell Formatting
Excellence Made Easy
Custom Cell Formatting
0:57
Fill Blank Cells
Excellence Made Easy
Fill Blank Cells
0:16
Vlookup using Tables
Excellence Made Easy
Vlookup using Tables
0:39
WeekdayName Function
Excellence Made Easy
WeekdayName Function
1:00
dplyr Package for R Language
Excellence Made Easy
dplyr Package for R Language
1:18
Learning R Programming for Data Science Course
Excellence Made Easy
Learning R Programming for Data Science Course
1:50
Process Improvement in Practice
Excellence Made Easy
Process Improvement in Practice
3:12
R Data Structures - Vectors
Excellence Made Easy
R Data Structures - Vectors
3:26
Data Types in R
Excellence Made Easy
Data Types in R
3:33
Arithmetics and Variable Assignment
Excellence Made Easy
Arithmetics and Variable Assignment
2:49
A Quick Tour of RStudio Interface
Excellence Made Easy
A Quick Tour of RStudio Interface
2:26
Installing R and RStudio
Excellence Made Easy
Installing R and RStudio
2:15