FINANCE TIPS & TRICKS

it managed services melbourne

Quickly create data visualizations

 

Worksheet showing data bars created from the Quick Analysis menu

 

Use the Quick Analysis tool in Excel to easily apply conditional formatting, create charts or tables, or display sparklines next to your data.

  1. In Excel, select the data you want to visualize.
  2. Select [クイック分析] ボタン Quick Analysis in the lower-right corner of the selected data (or press Ctrl+Q).
  3. 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

 

The Create Forecast Worksheet window displaying a line chart forecast for selected 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.

  1. In Excel, select a series of date or time entries and the corresponding values.
  2. Select Data > Forecast > Forecast Sheet.
  3. In the Create Forecast Worksheet window, select the line chart or column chart icon.
  4. In the Forecast End box, select an end date, and then select Create.

 

Collaborate in real time on an Excel workbook

 

Screenshot of an Excel sheet, so the co-authoring notification.

 

You and your coworkers can work at the same time on the same Excel workbook. Save time and avoid countless revisions.

  1. Sign in to Office 365, select Office 365 app launcher icon > OneDrive, and then select the folder where you want to create the workbook. It’s always best to create documents online first.
  2. Select New > Excel workbook, and then select the Book box and rename the file.
  3. 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

 

Screenshot of Outlook message compose screen, with Change Permissions selected on attached file.

 

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.

  1. While composing a message in Outlook, select Message > Include > Attach File on the Ribbon.
  2. Select the file you want to share from the list, or select Browse Web Locations and browse to the file. Then select Insert.
  3. 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.
  4. Select the attachment arrow, select Change Permissions, and then select the permission level for the message recipients.

Leave a Reply

Your email address will not be published. Required fields are marked *