Learn Microsoft Excel Online Free
Sometimes when we import phone numbers from external sources, the formatting of the phone numbers is removed. Even if in some situations the phone numbers are not imported from external resource, sometimes the phone numbers in worksheet are not displayed in the correct format, which is very common in daily work. When we are faced… read more »
To pad a number with zeros, you need to add leading spaces and/or carriers. For example, if the original digit contains 2 digits, three additional characters will be added on before it. If there are 3 digits in total, allocating two places for these extra pieces of information ensures that your output looks correct without… read more »
Sometimes we may want to enter a sequence of days in excel for some purpose, and we can press Ctrl+; to insert current date into cell, and then drag the cell down to attach following days into other cells, then we can get a list of days. But for some special requirement, we just want… read more »
In excel, we can type a date properly if set cell format as ‘Date’. If there is a list includes multiple dates, is there any way to convert these dates to the days of week accordingly? Actually, there are some tricks to convert date to day of week simply, in this free tutorial we will… read more »
Sometimes we want to fill 1,2,3,4,5… into each cell in a column, for implement this we can enter 1 in the first cell and then drag fill handle down to fill the following cells. But if there are some texts exist with number in cell for example Student001-1-A, we drag down the fill handle, the… read more »
In some special situations we may need to generate some random times in worksheet. We can enter time manually and one by one, but if we want to require a lot of random dates in excel worksheet, we will spend a lot of time on manual entry, and this work is very boring. Above all,… read more »
This post will guide you how to combine text and dates in the same cell in Excel. How do I combine text and date values into one Cell in Excel 2013/2016. Combine Text and Date into One Cell Assuming that you have a list of data in range B1:C4, and one column contain product names… read more »
This post will guide you how to highlight cell if date is the current day or is in the current week or month in Excel. How do I highlight row if date is in current week or month with conditional formatting in Excel 2013/2016. Highlight Cell if Date is in Current Day/Week/Month Highlight Row if… read more »
This post will guide you how to convert military time to standard time with a formula in Excel. How do I convert from military time 17:29:30 to regular time 5:29:30PM in Excel. How do I Convert Standard time to military time with a formula in Excel. Convert Military Time to Standard Time Convert Standard Time… read more »
This post will guide you how to delete or remove year from a given standard date in Excel. How do I remove the year from a date with a formula in Excel. Remove Year from a Date Assuming that you have a list of data in range B1:B5, in which contain date values. And you… read more »
This post will guide you how to convert the current date to a specified date format in Excel. How do I convert date to YYYY-MM-DD format with Format Cells Feature in Excel. How to convert date format to a specific date format with a formula in Excel. Convert Date to YYYY-MM-DD Format with Format Cell… read more »
This post will guide you how to concatenate cells and keeping data format in Excel. How do I concatenate cells and retain the certain Date format with a formula in Excel 2010/2013/2016. Concatenate Cells and Keeping Date Format Assuming that you have a list of data in range A1:B4, which contain product names and dates…. read more »
This post will guide you how to display negative time value in Excel. How do I change the way negative times are displayed in Excel. How to show negative dates or times with a formula in Excel. Display Negative Time Value Display Negative Time Value with Formula Video: Display Negative Time Value If the cell… read more »
This post will guide you how to extract month and year from a date in excel. How do I get month and year from date cells with a formula in Excel. How to convert date to month and year in Excel. Extract Month and Year from Date If you want to extract month and year… read more »
This post will guide you how to convert dates stored as text format in Excel. How do I convert the date as date format to text format in excel. You can use a variety of formulas to convert the dates in your worksheet to text format. You can use the TEXT function to create a… read more »
This post will guide you how to convert dates between Australian and US American formats in Excel. How to change the data format from your local locale to other locale, such as: US or South Africa. As the different country may be has different data format. So this post will talk that how to change… read more »
This post will guide you how to combine a data column and time column into one column in Excel. How do I quickly combine data and time in the different cells into one cell in your Worksheet. For example, if you have two columns and one column contain date values and another column contain time… read more »
This post will guide you how to convert month name to number in excel. How do I convert month name to number with an excel formula. How to convert month name to number with an Excel VBA macro. How to convert 3 letter month abbreviation to number in excel. How to convert 3 character month… read more »
This post will guide you how to sort IP address in your worksheet. How do I sort IP address with an excel formula. How to sort IP address with Text To Columns feature in excel. Sort IP Address with Formula Assuming that you have an IP list of data in the range of cells B1:B5,… read more »
This post will explain that how to convert a date to weekday name or month name or year? How do I change a date in one cell to display only the weekend name or month name with an Excel formula? For example, if you want to convert a date 11/6/2018 to Tuesday or November only,… read more »
