Posted inPower 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.
Posted inPower 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.
Posted inPower 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.
Posted inPower 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.
Posted inPower 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.
Posted inPower of Microsoft Office
Building a Custom WeekdayName Function in Excel
Building a custom WeekdayName function in Excel using the Advanced Formula Environment.
Posted inPower 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.
Posted inPower 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.
Posted inPower of Microsoft Office
Rearrange Columns in Excel Sheets Using the Sort Wizard
Rearrange Columns in Excel Sheets using the Sort wizard.
Posted inPower 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.