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…