July, 2022 - Excellence Made Easy

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.

By Mohammed Barakat July 30, 2022R Programming, Six SigmaNo Comments

Power 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

By Mohammed Barakat July 24, 2022Power of Microsoft OfficeNo Comments

Power 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.

By Mohammed Barakat July 21, 2022Power of Microsoft OfficeNo Comments

Power of Microsoft Office Project Management

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.

By Mohammed Barakat July 15, 2022Power of Microsoft Office, Project ManagementNo Comments