You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.

On the Outlook status bar, if you see Disconnected, Working Offline, or Trying to connect…, then Outlook can't reach the email server to send your mail.. To fix this problem, on the ribbon, select the Send/Receive tab, then, in the Preferences group, select Work Offline to toggle between offline mode and online mode.You may need to open the message and send it again or choose Send/Receive.

Cloud files can exist locally on the disk or be available online only. To choose the conditions for when inactive files are made online only, under Content will become online-only if not opened for more than: choose your preferred amount of time. Note that starting in Windows 11, version 22H2, the default for OneDrive cloud files is to make files online-only if not opened for more than 30 days.

Total row Once you add a total row to a table, Excel gives you an AutoSum drop-down list to select from functions such as SUM, AVERAGE, and so on.When you select one of these options, the table will automatically convert them to a SUBTOTAL function, which will ignore rows that have been hidden with a filter by default.

If the Encrypt contents to secure data check box is selected, you have to have the certificate that was used to encrypt the file or folder to be able to open it. In this situation, you should obtain the certificate from the person who created or encrypted the file or folder, or have that person decrypt the file or folder.

Setting up the modem and Internet connection. After you have all the equipment, you'll need to set up your modem and Internet connection. If your modem wasn't set up for you by your Internet service provider (ISP), follow the instructions that came with your modem to connect it to your PC and the Internet.

In Outlook, you have the option to: Attach a file | Upload a locally saved file to your OneDrive | Insert a picture into the body of a message | Attach an email item | Solve problems with attachments. Attach a file to an email message in new Outlook. New Outlook keeps track of the files you have worked on recently and suggests them whenever you decide you want to attach a file to an email message.

How do I add or subtract Times? You can add and subtract times in a few different ways. For example, to get the difference between 8:00 AM - 12:00 PM for payroll purposes you would use: =("12:00 PM"-"8:00 AM")*24, taking the end time minus the start time.Note that Excel calculates times as a fraction of a day, so you need to multiply by 24 to get the total hours.

Install language accessory packs after installing Microsoft Office, to add additional display, help, or proofing tools. Install the language accessory pack for your desired language.

To resize desktop icons, right-click (or press and hold) the desktop, point to View, then select Large icons, Medium icons, or Small icons.