10 rules for better dashboard. As you learn to build your first dashboards, you will get feedback from the end users. Their feedback will directly challenge you to ‘re-think’ what you […]
Data is often in unstructured formats, which makes ETL (extract, transform, and load) very useful. The data integration process gathers data from multiple data sources (sql, csv, txt) and combines […]
A function in Excel is a preset formula that helps perform mathematical, statistical and logical operations. Once you are familiar with the function you want to use, all you have […]
Everybody wants to learn VLOOKUP.. that’s so 2020. If you want to make your life easy and you had trouble learning VLOOKUP.. Forget about it! XLOOKUP is easier to learn […]
Everybody wants to learn VLOOKUP.. that’s so 2020. If you want to make your life easy and you had trouble learning VLOOKUP.. Forget about it! XLOOKUP is easier to learn […]