Data Analysis - Excellence Made Easy

Categorization of Students Grades using INDEX and XMATCH in Excel

Using INDEX and XMATCH in Excel, learn how to assign Grades to students based on their marks where grades are categorized with ranges of min and max marks.

By Mohammed Barakat October 14, 2023Data Science, Power of Microsoft OfficeNo Comments

Data Science R Programming

Transforming the Tedious: Streamlining Reconciliation Process by Automating R Script

Bank statement reconciliation is a pivotal yet often a dreaded task for accountants. Many find themselves grappling with the tedious process of gathering data, cleaning and transforming it, matching records,…

By Mohammed Barakat September 14, 2023Data Science, R ProgrammingNo Comments

Power of Microsoft Office

Text-to-Rows with Power Query

A short video demonstrating splitting a column by row with Power Query in Excel.

By Mohammed Barakat September 15, 2022Power of Microsoft OfficeNo Comments

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

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

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.

By Mohammed Barakat May 28, 2022Power of Microsoft OfficeNo Comments

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

By Mohammed Barakat May 17, 2022Data Science, Power of Microsoft OfficeNo Comments

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

By Mohammed Barakat April 15, 2022Power of Microsoft OfficeNo Comments

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

By Mohammed Barakat March 29, 2022Power of Microsoft OfficeNo Comments