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 ...

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.

Excel's basic formulas work fine for simple calculations, but they quickly become cumbersome when you're dealing with complex data analysis. You end up with nested functions that are hard to read, ...

How to Extract a Substring in Excel Using FIND() and MID() Functions Your email has been sent Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM, WORKDAY, ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...