COUNTIF() and SUMIF are very important functions in excel which are used to automate manual tasks. Furthermore, these functions are frequently used in finance and accounting. In this post, I am going to explain working of these two functions. COUNTIF() function- This function counts the values of a column when a condition if fulfilled […]
COUNTIF and SUMIF Functions in MS Excel Read More »
Python is a very popular language for data analysis and data manipulation. Furthermore, Python has a lot of libraries to manipulate Excel data. In this post, I will explain how to write to and read from Excel sheet using Python’s script . Which will be very useful for you to learn data science and Artificial
Writing and Reading Excel Data from Python Read More »
Microsoft Excel is a very popular spreadsheet program which is easy to use and it has a lot formulas which are related to finance, statistics, logical and arithmetic etc.. Furthermore, this is very popular among those who are working in office, in the field finance, administration and management. In this post, I will demonstrate how
Addition In Microsoft Excel Read More »