AdminNov 6, 20191 minHow to Calculate Working Days Tutorial in Excel (Indonesian)In this video, we share how to calculate number of working days using networkdays.intl function in Excel, completed with the Weekends and...
Nikolaus StevenAug 28, 20182 minWhy Macros run so slowly in Excel 2016? (Solved!)So, I think this is one of the major, and desperate problem that Excel Lovers could face when implementing and using Macros / VBA in...
Nikolaus StevenApr 10, 20182 minCreate .Zip Password file with Excel? Is it even possible?So recently our Company requires a mechanism to store our files/ documents in a shared folder within our local network server. However,...
AdminMar 10, 20182 minUse Map for Data Visualization in ExcelDo you know that Excel 2016 has the capability to use Map to visualize your data in Excel? Take a look here. Microsoft Excel 2016 has two...
AdminMar 8, 20184 minFuzzy Lookup in ExcelHave you been in a situation where Vlookup/ Hlookup/ Lookups function just don't work for you? Because the dataset you have does not...
AdminMar 5, 20184 min7 Amazing Tips & Tricks in Excel1. Entering Line Sparkline Microcharts Line Sparklines are mini charts placed in single cells, each representing a row of data in your...