When you use Microsoft Excel to store and analyze business data, your workbooks and worksheets often contain date information. Although your original data may need to display full month, day and year ...

Learn to reuse data instead of retyping it so you can boost productivity effortlessly. Excel has tools that can help you make information appear in multiple workbooks without doing a lot of typing.

Q. I receive Excel spreadsheets regularly that contain dates. I have to manually look up the day of the week that represents these dates. Are there any functions that can help speed this process along ...

In this post, we will show you how to pull data from another sheet in Excel. While copying and pasting data is simple, pulling data from one sheet to another offers significant advantages in Excel.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components with this step-by-step tutorial. You might receive foreign data in the form of ...

Sorting by date in Excel helps organize your data so you can easily view it in chronological order. Whether you are tracking sales, project timelines, or personal records, sorting by date can make ...

This question comes up often in user forums: How do I extract a piece of information from one column and put that extracted information into another? For example, if I have a URL in one column, can I ...