© 2022 Hashnode
#excel
If you are someone who often spend time cleaning and processing raw and dirty data in spreadsheets you know how repetitive some tasks can be like filtering the data, sorting it, trimming unwanted spac…
Financial institutions are obligated under the Inland Revenue Ordinance to furnish return reporting the required information of reportable accounts to the Department in a specified format on an annual basis. The IT department is responsible…
This week was a proper HUSTLE, and I remember telling our Teams Supervisor at Side Hustle why it was and that I am sure some people in my team have given up on Data Analytics. THE TASK The task is to Work on any Health/Disease Insight Analy…
So, the task for the second week came in on Monday 13th July. The task at first looked very easy, the team had a meeting and we agreed to work with Malaria and Cholera datasets, duties were assigned t…
Where to start from now... THE TASK Yes! our task quite confused us at first: "Choose a Product in Nigeria or used by Nigerians and work on a Product Sales Insight using Excel and Power BI. You are to do the following: Data Scraping Data cl…
INTRODUCTION Today’s businesses consider data as a very important tool for making well-informed and data-driven decisions. However, going through a dataset to get an answer to your question can be very exhausting. This is where data visuali…
The Task Data analysis has been an area of interest in recent times, according to Wikipedia, data analysis is a process of inspecting, cleansing, transforming, and modeling data with the goal of di…
Although there are some opensource solutions such as Luckysheet and handsontable for creating javascript spreadsheet, I found none of them meet my requirements. Handsontable lacks many Excel functionalities out of the box and I have to imp…
Get the Net Present Value (NPV) for a series of cash flows that may not be periodic. XNPV uses specific dates that correspond to each cash flow being discounted in the series, whereas the regular NPV …
In which language where you increment a character (well .... it has to be uppercase in this case) by 1 and you get the next character in ASCII (also alphabetic) sequence ? I don't know if this is supported in any other language but this is …
