February, 2022 - Excellence Made Easy

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.

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

Power of Microsoft Office

Using NLP in Excel with the Analyze Data Wizard

Using NLP in Excel to answer your narrative questions and get insights into your data with the Analyze Data wizard.

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

Power of Microsoft Office

Building a Custom WeekdayName Function in Excel

Building a custom WeekdayName function in Excel using the Advanced Formula Environment.

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

Power of Microsoft Office

Using Nested XLOOKUP to Search for Multiple Values in Excel

Using a formula of nested XLOOKUP to search for multiple values from a matrix-like table in Excel.

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

Power of Microsoft Office

XLOOKUP to Replace VLOOKUP and HLOOKUP in Excel

Using the new function XLOOKUP that is an improved version of VLOOKUP to overcome all search limitations.

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

Power of Microsoft Office

Rearrange Columns in Excel Sheets Using the Sort Wizard

Rearrange Columns in Excel Sheets using the Sort wizard.

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

Power of Microsoft Office

Unique Entries in Excel Cells Using Data Validation

Force unique entries in Excel cells using the Data Validation wizard.

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

Power of Microsoft Office

Using Spaces as Intersecting Operators in Excel

Using spaces to act as intersecting operators that pick a value from a matrix-like table in Excel.

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

Power of Microsoft Office

Count a Weekday between Two Dates in Excel

Building a custom function in Excel's Advanced Formula Environment to count a specific weekday between two dates.

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

Power of Microsoft Office

Excel Tip: Convert Numbers to Dates with Text to Columns

Using Text to Columns in Excel to convert a date represented in numbers into a formatted date.

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