Excel - Excellence Made Easy

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.

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

Convert Numbers to Words in Excel

NumberToWords is a significant custom Excel function in the toolbox of Accounting and Finance folks. It helps them to write numeric monetary values in words.

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

Power of Microsoft Office

Building Gauge Visualization in Excel

Gauge visualization is often used to display a single quantitative measure compared to a preset target value. This is how to build it in Excel.

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

Power of Microsoft Office

Combine Cells in Excel using the TEXTJOIN() Function

Use TEXTJOIN function to combine text from multiple ranges in Excel with the ability to specify a delimiter used between text values.

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

Power of Microsoft Office

Using Goal Seek to Back-Solve a Formula in Excel

Using Goal Seek in Excel to back-solve a formula for a specific input value that drives a predefined output.

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

Power of Microsoft Office

Creating a Heatmap using XLOOKUP and Conditional Formatting

Using XLOOKUP and Conditional Formatting to create a heatmap that gives a quick insight and a story to tell about COVID during 2021 around the globe.

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

Power of Microsoft Office

When is Using “SWITCH” Function More Efficient Than Using “IFS” in Excel?

IFS can be used instead of SWITCH in Excel but not necessarily the opposite. Both are important. Each one is better used than the other in specific situations.

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

Power of Microsoft Office

Using “IFS” Function instead of Nested “IF” in Excel

Using IFS in Excel instead of nested IF to check whether one or more conditions are met and to return a value that corresponds to the first TRUE condition.