Excel - 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

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

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