Learn Microsoft Excel Online FreeThis post will guide you how to remove decimals without rounding in Excel. How do I delete numbers after decimal point with a formula in the given cell in Excel. Deleting Numbers after Decimal Point Assuming that you have a list of data in range B1:B5, in which contain decimal values. And you want to… read more »
This post will guide you how to count the number of weekends between two dates in Excel. How do I get the number of weekends between 2 dates with a formula in Excel. How to count weekend days between dates in Excel. Count the Number of Weekends between Two dates If you want to calculate… read more »
This post will guide you how to split date and time into separate cells in Excel. How do I Separate dates and times into two separate cells in Excel. How to split a data into multiple cells in Excel. How to separate Date and time data into 2 different cells with a formula in Excel…. read more »
This post will guide you how to generate all possible combinations with a formula in excel. How do I create list with all possible combinations of two lists in Excel. How to list all combinations from two separate list or range in Excel. Generate All Possible Combinations of Two Lists in Excel Assuming that you… read more »
This post will guide you how to create a five star rating system in your current worksheet in excel. How do I change the five points system to five star rating in excel. How to use the conditional formatting function to create a five star rating system in excel. Create a Five Star Rating System… read more »
This post will guide you how to extract date part from a date with time values in Excel. How do I remove time part from a date in Excel. How to get only date part from the date with time values via Format cells feature or Excel function. How to extract date from a date… read more »
This post will guide you how to transpose multiple columns into a single columns with multiple rows in Excel. How do I put data from multiple columns into one column with Excel formula; How to transpose columns into single column with VBA macro in excel. Assuming that you have a data list in range B1:D4… read more »
This post will guide you how to use Excel TRUNC function with syntax and examples in Microsoft excel. Description The Excel TRUNC function truncates a number to an integer by removing the fractional part of the number. So this function returns a truncated number based on a given number of digits in Excel. The TRUNC… read more »
This post will guide you how to use Excel INT function with syntax and examples in Microsoft excel. Description The Excel INT function returns the integer portion of a given number. And it will rounds a given number down to the nearest integer. And the INT function rounds down, so if you provide a negative… read more »
This post will teach you how to calculate days, weeks, months and years between two dates in excel. How do I count the number of days, weeks, months and years between 2 dates in excel. Calculate days between two dates If you want to calculate the difference in days between two dates, you can use… read more »
