Excel - Excellence Made Easy

Excel Tip: Count a Weekday between Two Dates

How many Sundays are there between 2/19 and 5/22/2022? Have you ever been faced with such a question during one of your data analysis tasks? Unfortunately, there’s no native function…

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

Power of Microsoft Office

Converting Numbers to Words in Microsoft Office Excel

The process of converting numbers to words is indispensable in the finance/accounting sections of any organization. Yet, it is cumbersome and time-consuming especially when you have scores of transactions to…

By Mohammed Barakat June 26, 2020Power of Microsoft OfficeNo Comments

Power of Microsoft Office

Excel Tip: Using Paste Special to Perform Simple Calculations

You can perform a simple calculation (division, multiplication, addition, or subtraction) on a list of numbers without the need to write formulas. Is this possible?! With Paste Special tool in…

By Mohammed Barakat March 12, 2012Power of Microsoft OfficeNo Comments

Power of Microsoft Office

Excel Tip: Using Conditional Formatting to Warn on Deadlines

Suppose that you manage a set of suppliers’ agreements which start and expire on specific dates. You need to be warned on the expiry of any agreement, say, 10 days…

By Mohammed Barakat March 8, 2012Power of Microsoft Office1 Comment

Power of Microsoft Office

Excel Tip: Calculate Difference in Hours between Two Dates

From time to time, people approach me with an Excel problem that looks easy to calculate while, unfortunately, there’s no straightforward solution to it. The problem is calculating the difference…

By Mohammed Barakat March 7, 2012Power of Microsoft Office10 Comments

Power of Microsoft Office Six Sigma

Interrelationship Digraph: PART TWO

In this part of “Interrelationship Digraph: Demystifying Complex Relationships” video I explain how we can use the Interrelationship Matrix to reflect results of the Interrelationship Digraph. I also show how…

By Mohammed Barakat February 27, 2011Power of Microsoft Office, Six SigmaNo Comments

Power of Microsoft Office Six Sigma

Interrelationship Digraph: PART ONE

Interrelationship Digraph or Relations Diagram is one of the seven Management and Planning Tools that helps us analyze the cause-and-effect relationships among different issues in a complex situation. It also…

By Mohammed Barakat February 27, 2011Power of Microsoft Office, Six SigmaNo Comments

Power of Microsoft Office Project Management Six Sigma

Prioritization Matrix: Objectivity in Decision Making

Prioritization Matrix is a decision-making tool and is one of the seven management and planning tools used in Six Sigma and Quality Management in general. It is used to determine…

By Mohammed Barakat February 11, 2011Power of Microsoft Office, Project Management, Six Sigma1 Comment

Power of Microsoft Office Six Sigma

Creating Pareto Chart in Microsoft Office Excel

During the Define step of a Six Sigma project the project team needs to identify the problem or the opportunity that the project is intended to solve. Usually, there would…

By Mohammed Barakat February 2, 2011Power of Microsoft Office, Six Sigma1 Comment

Power of Microsoft Office

Calculate Loan Terms using Goal Seek in Microsoft Excel

Goal Seek feature in Microsoft Office Excel is used to find out the correct input value to a formula in order to get a desired formula result. This video shows…

By Mohammed Barakat January 28, 2011Power of Microsoft OfficeNo Comments