Showing posts with the label ms officeShow All
work from home excel tricks
vba
Union and Intersect in Excel VBA
Union and Intersect The Union method in Excel VBA returns a Rang…
Read more
wfh
How to apply multiple data validation in one cell in Excel worksheet
How to apply multiple data validation in one cell in Excel worksheet In Excel worksheet, applying …
Read more
work from home excel tricks
tricks
Combine cells using &.
Combine cells using &. Databases tend to split out data to make it as exact as possible. For …
Read more
vba
tips and tricks
ms office
How to use IFNA Function in Excel
How to use IFNA Function in Excel There is the Excel IF function that creates True or Fal…
Read more
ms office
How to Use the IF Function in Excel
How to Use the IF Function in Excel When you’re using Excel, it’s easy to be daunted by fo…
Read more
spreadsheet
Build a Secret Santa Spreadsheet
Build a Secret Santa Spreadsheet Christmas is here again, and while we at Spreads…
Read more
Sumproduct
Magic of Sumproduct Formula
Sumproduct To calculate the sum of the products of corresponding numbers in one …
Read more
Social Plugin