Excellence Made Easy

A channel on Excellence in the workplace leveraging technology. It presents training movies on Microsoft Office applications, R Programming Language, Lean, Six Sigma, Kaizen, Theory of Constraints. and much more.

Categorization of Students Grades using INDEX and XMATCH in Excel
Categorization of Students Grades using INDEX and XMATCH in Excel
Text-to-Rows with Power Query
Text-to-Rows with Power Query
Process Capability Calculator: Leveraging the Power of R Language and Shiny Apps in Six Sigma
Process Capability Calculator: Leveraging the Power of R Language and Shiny Apps in Six Sigma
Build Interactive Graphs with Pivot Charts in Excel
Build Interactive Graphs with Pivot Charts in Excel
Pivot Data with COUNTIFS and SUMIFS in Excel
Pivot Data with COUNTIFS and SUMIFS in Excel
Prioritization Matrix with MS Excel
Prioritization Matrix with MS Excel
Build Real-Time Monkeypox Cases Dashboard with Power Query
Build Real-Time Monkeypox Cases Dashboard with Power Query
Pivot and Unpivot Data with Excel Power Query
Pivot and Unpivot Data with Excel Power Query
Automate Data Wrangling and Analysis in Excel with Power Query
Automate Data Wrangling and Analysis in Excel with Power Query
Pareto Chart: Expose the Vital Few Contributors in Your Data Visualization
Pareto Chart: Expose the Vital Few Contributors in Your Data Visualization
Creating Vital Few Visuals with Treemaps and Maps
Creating Vital Few Visuals with Treemaps and Maps
Convert Numbers to Words in Excel
Convert Numbers to Words in Excel
Building Gauge Visualization in Excel
Building Gauge Visualization in Excel
Combine Cells in Excel using the TEXTJOIN Function
Combine Cells in Excel using the TEXTJOIN Function
Using Goal Seek to Back-Solve a Formula
Using Goal Seek to Back-Solve a Formula
Creating a Heatmap using XLOOKUP and Conditional Formatting
Creating a Heatmap using XLOOKUP and Conditional Formatting
When is Using “SWITCH” Function More Efficient Than Using “IFS” in Excel
When is Using “SWITCH” Function More Efficient Than Using “IFS” in Excel
Using IFS Function instead of Nested IF in Excel
Using IFS Function instead of Nested IF in Excel
NLP in Excel with the Analyze Data Wizard
NLP in Excel with the Analyze Data Wizard
Using Nested XLOOKUP
Using Nested XLOOKUP
XLOOKUP to Replace VLOOKUP and HLOOKUP
XLOOKUP to Replace VLOOKUP and HLOOKUP
Re-arrange Columns
Re-arrange Columns
Force Unique Entries in Cells
Force Unique Entries in Cells
Use Space as Intersecting Operator
Use Space as Intersecting Operator
Count a Weekday between Two Dates
Count a Weekday between Two Dates
Convert Number to Date
Convert Number to Date
Custom Cell Formatting
Custom Cell Formatting
Fill Blank Cells
Fill Blank Cells
Vlookup using Tables
Vlookup using Tables
WeekdayName Function
WeekdayName Function