Excel Tips and Tricks - 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

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

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

VLOOKUP Using Tables in Excel

Tables in Excel could be leveraged to overcome VLOOKUP common mistakes and provide more accurate and reliable results.

By Mohammed Barakat February 26, 2022Power of Microsoft OfficeNo Comments