by Crispo Mwangi | Feb 9, 2023 | INTERMEDIATE EXCEL
Analysts spend between 60% to 80% cleaning data. Here is how to cut that time by using the SUMIFS function in Data Validation. Given the below data, how do you ensure staff is awarded only salaries within their job grade scale? Here are the 4 steps: Select the Salary...
by Crispo Mwangi | Feb 1, 2023 | ADVANCED EXCEL
If you do not have Office365, the easiest option you have for splitting text is FILTERXML How do you split and sum below multiple sales? The easiest way to solve this is by using the FILTERXML function FILTERXML function returns specific data from XML text using the...
Recent Comments