9971439868 info@ncroy.in

SUMIF Function Super Trick

Sumif Function is very useful when we have to calculated sum of values in one column/row by looking criteria in another column/row. Sometime We received a data in a table where we confused to select criteria range and sum range. Just have a look on below table : Round...

Are You Still Using Excel 2007?

Excel 2019 NEW FUNCTIONS, INK IMPROVEMENT TOOL, ENHANCE VISUALS, NEW DATA TYPES … Excel 2016 ONE CLICK FORECASTING, SIX NEW CHART, MULTI SELECT SLICER, SMART LOOKUP.. Excel 2013 ALSO AVAILABLE IN AN ONLINE VERSION, ADDED FLASH FILL & QUICK ANALYSIS TOOL,...