Search results
Results from the WOW.Com Content Network
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly—in a matter of seconds. And with certain versions of Excel, you'll see other people's selections in different colors.
The sensitivity bar makes it easy for you to see what label is applied to your file, and to apply or change a label whenever you need to, including when saving the file. Just select the sensitivity bar in the save dialog to see the labeling options for this file.
Create a Gantt chart to present your data, schedule your project tasks, or track your progress in Excel.
Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months. Windows Mac.
The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE ("1/1/2008") returns 39448, the serial number of the date 1/1/2008.
Create a custom filter that uses multiple criteria. For more information, see Filter by using advanced criteria. Learn how to Filter for unique values or remove duplicate values. Use the AutoFilter to filter a range of data in Excel 2010 and learn how to remove filters.
The #VALUE! error is also shown when a formula references one or more cells that have text instead of numbers, and uses the standard math operators (+, -, *, and /) to add, subtract, multiply, or divide the different data types.
Keyboard shortcuts for the File menu in Microsoft 365 for Windows. Keyboard shortcuts for SmartArt graphics in Microsoft 365 for Windows. Use a keyboard to customize the Quick Access Toolbar. Use the keyboard to work with the ribbon.
Use Power Query to combine multiple files with the same schema stored in a single folder into one table. For example, each month you want to combine budget workbooks from multiple departments, where the columns are the same, but the number of rows and values differ in each workbook.
About the shared workbook feature. Applies To. Important: "Shared Workbooks" is an older feature that allows you to collaborate on a workbook with multiple people. This feature has many limitations, and has been replaced by co-authoring.
How does versioning work in a SharePoint list or library. Restore a previous version of an item or file in SharePoint. Enable and configure versioning for a list or library. Use Version History to view previous versions of files stored in OneDrive or SharePoint libraries.