Working with Data columns in Excel is many a times a necessity. There are various data tables that contains one or more date columns. There can be a need to work with the date column to do various calculations. One
Category: Microsoft Excel
This category covers detailed articles about Microsoft Excel. Various topics around Microsoft Excel are described in detailed steps. The category is useful for anyone looking to learn MS Excel in detail.
Working with Date values is one of the key aspect in any data analysis. Date column is present in almost every dataset. Storing of date value and working with it requires different set of functions and its knowledge. From a
Working with dates column is need of the hour being a Data Scientist or anyone working with Dataframes. Date column requires different functions to process. Various requirement like finding days difference, extraction of year from date and many other. Everything
Right function helps in extracting content from text in an Excel Cell. There can be many use cases where we have to work with Text values in Excel. For example there may be a need to extract, Last name from
Comparison of text between cells is possible in Excel through an Excel Formula. Exact function helps in comparing 2 cells, to check if the values within the cell is matching exactly. This function can be very helpful, as various use
Combining text in Excel can be very useful in many situation. There can be various use cases like combining first name and last name, combining address and zip codes, combining phone number and country codes etc. Concat function helps in
Lower Case function helps in making text in Lower case, i.e. all characters of each word as Lower. Lower case function is helpful to format the content in Excel file. All the text that is not present in proper cases,
Upper Case function helps in making text in Upper case, i.e. all characters of each word as upper. Upper case function is helpful to format the content in Excel file. All the text that is not present in proper cases,
Proper Case function helps in making text in proper case, i.e. First letter capital and rest lower case for all words. Proper case function is helpful to properly format the content in Excel file. All the text that is not
Left function helps in extracting content from text in an Excel Cell. There can be many use cases where we have to work with Text values in Excel. For example there may be a need to extract, first name from