Ato | search
Click here to view Ato news from 60+ newspapers.
Bookmark or Share- Calculate the difference between two dates - Microsoft SupportUse the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following. : If the Start_date is greater than the End_date, the result will be #NUM!. In this example, the start date is in cell D9, and the end date is in E9.
- Create a PivotTable timeline to filter dates - Microsoft SupportInstead of adjusting filters to show dates, you can use a PivotTable Timeline—a dynamic filter option that lets you easily filter by date/time, and zoom in on the period you want with a slider control. Click Analyze > Insert Timeline to add one to your worksheet.
- Get started with Python in Excel - Microsoft SupportTo begin using Python in Excel, select a cell and on the Formulas tab, select Insert Python. This tells Excel that you want to write a Python formula in the selected cell. Or use the function =PY in a cell to enable Python.
- Using Flash Fill in Excel - Microsoft SupportFor example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns. Let's say column A contains first names, column B has last names, and you want to fill column C with first and last names combined.
- Filter dates in a PivotTable or PivotChart - Microsoft SupportWith the Mark as Date Table dialog box, you specify a unique date column, which enables the use of advanced date filters against Power Pivot data in Excel pivot reports.
More
