Posted inPower of Microsoft Office
Text-to-Rows with Power Query
A short video demonstrating splitting a column by row with Power Query in Excel.
Posted inR Programming Six Sigma
Process Capability Calculator: Leveraging the Power of R Language and Shiny Apps in Six Sigma
Using R and ShinyApps the Process Capability Calculator helps in calculating the Cpk of a process. Watch this video navigating the Process Capability Calculator with ShinyApps.
Posted inPower of Microsoft Office
Build Interactive Graphs with Pivot Charts in Excel
Pivot Charts are user-friendly. They provide the ability of user-interaction with chart dimensions and filters during presentation. Watch the video
Posted inPower of Microsoft Office
Pivot Data with COUNTIFS and SUMIFS in Excel
COUNTIFS and SUMIFS functions can be used to pivot a list of orders by customers with different Payment Types. See video.
Prioritization Matrix with Microsoft Excel: Objectivity in Projects Selection
Prioritization Matrix is an efficient tool to select an option over many others. With Microsoft Excel, you can build a PM with a few simple steps.
Posted inPower of Microsoft Office
Build Real-Time Monkeypox Cases Dashboard with Power Query
Create an ETL procedure in Power Query that presents real-time visualization of Monkeypox cases in the World.
Posted inData Science Power of Microsoft Office
Pivot and Unpivot Data with Excel Power Query
Convert Wide data to Tall and vice versa with Excel Power Query Pivot and Unpivot columns.
Posted inPower of Microsoft Office
Automate Data Wrangling & Analysis in Excel with Power Query
See how Power Query can record a series of steps to import your data, clean and transform it, then load it with the final shape into an Excel spreadsheet.
Posted inPower of Microsoft Office
Pareto Chart: Expose the Vital Few Contributors in Your Data Visualization
See how to build a Pareto Chart in Excel in two different methods to expose the vital few contributors in your data visualization.
Posted inPower of Microsoft Office
Make Vital Few Contributors Stand Out in Your Visuals Using Treemaps and Maps
Create visuals that make the vital few contributors in your data stand out using Treemaps and Maps in Excel.