Quickly create data visualizations
Use the Quick Analysis tool in Excel to easily apply conditional formatting, create charts or tables, or display sparklines next to your data.
- In Excel, select the data you want to visualize.
- Select Quick Analysis in the lower-right corner of the selected data (or press Ctrl+Q).
- Point to the formatting options to preview them, and then select the visualization you want to create.
Quickly predict future values based on historical data
If you have historical time-based data, you can use it to create a forecast. A forecast can help you predict things like future sales, inventory requirements, or consumer trends.
- In Excel, select a series of date or time entries and the corresponding values.
- Select Data > Forecast > Forecast Sheet.
- In the Create Forecast Worksheet window, select the line chart or column chart icon.
- In the Forecast End box, select an end date, and then select Create.
Collaborate in real time on an Excel workbook
You and your coworkers can work at the same time on the same Excel workbook. Save time and avoid countless revisions.
- Sign in to Office 365, select > OneDrive, and then select the folder where you want to create the workbook. It’s always best to create documents online first.
- Select New > Excel workbook, and then select the Book box and rename the file.
- Select Share, add the email addresses of those you want to share with, and select Send.When other people open and edit the workbook while you’re working in it, a notification appears at the top and colored flags show where they’re working in the document.
Securely share files with colleagues
Email a link to an Excel workbook stored in SharePoint or OneDrive for Business to ensure that everyone is viewing and working in the same file.
- While composing a message in Outlook, select Message > Include > Attach File on the Ribbon.
- Select the file you want to share from the list, or select Browse Web Locations and browse to the file. Then select Insert.
- If the file is on SharePoint or OneDrive for Business, select Share as OneDrive link in the How do you want to attach this file? box.
- Select the attachment arrow, select Change Permissions, and then select the permission level for the message recipients.