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
Unique Entries in Excel Cells Using Data Validation
Force unique entries in Excel cells using the Data Validation 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.
Posted inPower 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.
Posted inPower 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.
Posted inPower of Microsoft Office
Excel Tip: Custom Cell Formatting
Using Custom Cell Formatting in Excel to make a numeric value more informative by attaching text to numeric cells.
Posted inPower of Microsoft Office
Excel Tip: Fill Blank Cells Using “Go To” Wizard
Use the "Go To" wizard in Excel to fill blank cells regardless of their count.
Posted inPower 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.
Posted inPower of Microsoft Office
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…