Need everyone at a meeting? Outlook mobile helps you find a time when everyone is available.
Pick a date and time for your meeting.
If you see red, this meeting time doesn't work for everyone.
Tap Time to see when everyone is available.
If No availabilities on this day, select another date and time. Green means the meeting time works for everyone.
Tap the checkmark to schedule.
For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters.
ASC(text)
Text is the text or a column reference that contains the text you want to change. If text does not contain any full-width letters, text is not changed.
Formula | Description (Result) |
|---|---|
| =ASC(" | " |
| =ASC("EXCEL") | "EXCEL" |
You can add text to a PowerPoint slide or a slide master by inserting a text box and typing inside that box. You can then format that text by selecting the text or the entire box. You can also add text to placeholders and shapes.
Select a heading below to open it and see the detailed instructions.
To add text to a text placeholder on a slide, do the following:
Click inside the placeholder, and then type or paste the text.
Note: If your text exceeds the size of the placeholder, PowerPoint reduces the font size and line spacing incrementally as you type to make the text fit.
Below, the dotted border represents the placeholder that contains the title text for the slide.
To add text to a text box that anyone can edit, in Normal view, click inside the text box, and then type or paste the text.
To add text to a text box that is contain permanent and un-editable, in Slide Master view, click inside the text box, and then type or paste the text.
Use text boxes to place text anywhere on a slide, such as outside a text placeholder. For example, to add a caption to a picture, create a text box and position it near the picture.
Note: When you add a text box in Normal view, the text is editable by anyone. When you add a text box in Slide Master view, the text you add to it will become permanent and un-editable outside the Slide Master.
Shapes such as squares, circles, callout balloons, and block arrows can contain text. When you type text into a shape, the text attaches to the shape and moves and rotates with it.
To add text that becomes part of a shape, select the shape, and then type or paste the text.
A text box is handy if you want to add text to a shape, but you don't want the text to attach to the shape. You can add a border, fill, shadow, or three-dimensional (3-D) effect to text in a text box.
To add text that moves independently of a shape, add a text box, and then type or paste the text.
Add a text box
On the Insert tab, in the Text group, click Text Box.
Note: If you are using an East Asian language, from the Text Box drop-down menu, click either Horizontal or Vertical alignment.
Click the slide, and then drag the pointer to draw the text box.
Notes: In Slide Master view, there's a difference in how you use a text placeholder versus a text box:
Add a text placeholder from within Slide Master view when you want to prompt users of your template to replace the prompt text with text that is pertinent to their own project. (Normal behavior of custom prompt text in a text placeholder is that it disappears when you begin typing.)
Add a text box from within Slide Master view when you want it to contain permanent, uneditable text.
When you add a text box in Normal view, the text is editable by anyone.
Select a heading below to open it and see the detailed instructions.
Click inside the border and type or paste your text.
You can add text boxes and put them anywhere on a slide. When you add a text box in normal view, the text can be edited directly in the slide. If the text box is added in slide master view, you can edit the text only in the slide master.
In newer versions
On the Home tab, in the Insert group, click Text Box.
On the slide, click the location where you want to add the text box.
Type or paste your text in the text box.
In PowerPoint for Mac 2011
On the Home tab, under Insert, click Text.
On the pop-up menu, click Text Box.
On the slide, click the location where you want to add the text box.
Type or paste your text in the text box.
Shapes such as squares, circles, callout balloons, and block arrows can contain text. When you type text into a shape, the text attaches to the shape and moves and rotates with it.
In newer versions
On the Home tab, in the Insert group, click Shapes.
In the list, click the shape that you want to add.
On the slide, click the location where you want to add the shape, and then drag the sizing handle until the shape is the size that you want.
To add text that becomes part of a shape, select the shape, and then type or paste your text.
In PowerPoint for Mac 2011
On the Home tab, under Insert, click Shape.
On the pop-up menu, point to a kind of shape, and then click the shape that you want to add.
On the slide, click the location where you want to add the shape, and then drag the sizing handle until the shape is the size that you want.
To add text that becomes part of a shape, select the shape, and then type or paste your text.
Important: As of March 31, 2018, the SharePoint Online public website feature has been discontinued. Links that point to discontinued topics have been removed.
If you've been using the web page editor to change the general layout and appearance of a web page but still haven't got the look and feel you want, adding your own HTML code may be the answer. Adding to or editing the HTML that underlies a web page helps you further customize your public site according to your taste and requirements, so you can achieve the engaging site you have in mind. For example, you can:
Change page design, by adding a frame around a block of text.
Make the footer on every page work for you, by adding a special font style or size.
Check your code to make sure it's valid and complete before you add it to the source.
Logon to your public website and go to the page you want to edit.
Click Page > Edit and then from the Format Text tab, click Edit Source.
Locate the position where you want to insert the block of code. You may need to delete code that you want to replace or remove. The page you see will look something like this, with a cursor marking the insertion point for new code:
Enter the HTML code.
Important: HTML code is not validated when you add it to your web page. Errors in the HTML code can cause a web page to display incorrectly.
Click OK.
After you insert the HTML code, verify that everything appears as you expect.
If the page looks correct, click Page > Save > Save, and then open the page in a new browser window to confirm.
If you experience problems you can't resolve, then do not save the page. Instead, click Page > Save > Stop Editing > Cancel.
If you're a team owner, go to the team name and click More options 
> Get link to team. Click Copy and send the link to the person you want to invite to your team.
That person can simply paste the link into any browser to join the team.
Note: Currently, guests can't join a team via a link or code.
When you send someone a code for joining a team, they can join directly—you won't get a join request. You can use the code as many times as you want.
If you're a team owner, go to the team name and click More options > Manage team. Select the Settings tab > Team code > Generate. Click Copy. Share the code with your invitees however you choose—send the code to a single person via chat or write it on a white board for a whole room full of people.
People can use the code on the Suggested teams screen.
Note: Currently, guests can't join a team via a link or code.
As you make the switch from G Suite to Microsoft 365, it's important to learn the basics to make the transition as smooth as possible. Whether you want to work in the web or use the desktop apps, use the guides below to get started.
Need help moving your organization's accounts to Microsoft 365 from G Suite? See Switch from G Suite to Microsoft 365.
To learn more, check out the Outlook training.
To learn more, check out the OneDrive training.
To learn more, check out training for Word, Excel, and PowerPoint.
You tap the File button to print in Excel for iPad. Watch this video to learn how. At this time, you can only print to an AirPrint compatible printer.
Open email attachments. Open, edit, and send back email attachments using Excel for iPad.
How saving works in Excel for iPad. Excel for iPad automatically saves your work every time you make even a small change. In most cases, you don't have to do anything at all to save your document. Watch this training video to learn about AutoSave.
Type in Excel for iPad. Typing in Excel for iPad can be tricky at first, especially if you're used to a physical keyboard. This training video shows you some typing tips for Excel for iPad. It covers typing text, numbers and formulas.
How to print in Excel for iPad. (You are here!) You tap the File button to print in Excel for iPad. Watch this video to learn how. At this time, you can only print to an AirPrint compatible printer.
Automatically fill a column with Flash Fill
For example, automatically fill a First Name column from a Full Name column.
In the cell under First Name, type Molly and press Enter.
In the next cell, type the first few letters of Garret.
When the list of suggested values appears, press Return.
Select Flash Fill Options 
for more options.
Try it! Select File > New, select Take a tour, and then select the Fill Tab.
Quickly calculate with AutoSum
Select the cell below the numbers you want to add.
Select Home > AutoSum 
.
Press Enter.
Tip For more calculations, select the down arrow next to AutoSum, and select a calculation.
You can also select a range of numbers to see common calculations in the status bar. See View summary data on the status bar.
Create a chart
Use the Quick Analysis tool to pick the right chart for your data.
Select the data you want to show in a chart.
Select the Quick Analysis button 
to the bottom-right of the selected cells.
Select Charts, hover over the options, and pick the chart you want.
Try it! Select File > New, select Take a tour, and then select the Charts tab. For more information, see Create charts.
Use conditional formatting
Use Quick Analysis to highlight important data or show data trends.
Select the data to conditionally format.
Select the Quick Analysis button to the bottom-right of the selected cells.
Select Formatting, hover over the options, and pick the one you want.
Try it! Select File > New, select Take a tour, and then select the Analyze Tab.
Freeze the top row of headings
Freeze the top row of column headings so that only the data scrolls.
Press Enter or Esc to make sure you're done editing a cell.
Select View > Freeze Panes > Freeze Top Row.
For more information, see Freeze panes.
Next: Collaborate in Excel
You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk(*), or forward slash (/) signs.
Let's take an example of a simple formula.
On the worksheet, click the cell in which you want to enter the formula.
Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation.
For our example, type =1+1.
Notes:
Instead of typing the constants into your formula, you can select the cells that contain the values that you want to use and enter the operators in between selecting cells.
Following the standard order of mathematical operations, multiplication and division is performed before addition and subtraction.
Press Enter (Windows) or Return (Mac).
Let's take another variation of a simple formula. Type =5+2*3 in another cell and press Enter or Return. Excel multiplies the last two numbers and adds the first number to the result.
You can use AutoSum to quickly sum a column or row or numbers. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter (Windows) or Return (Mac), and that's it!
When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Note: You can also type ALT+= (Windows) or ALT+ 
+= (Mac) into a cell, and Excel automatically inserts the SUM function.
Here's an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click AutoSum. A formula appears in cell B7, and Excel highlights the cells you're totaling.
Press Enter to display the result (95.94) in cell B7. You can also see the formula in the formula bar at the top of the Excel window.
Notes:
To sum a column of numbers, select the cell immediately below the last number in the column. To sum a row of numbers, select the cell immediately to the right.
Once you create a formula, you can copy it to other cells instead of typing it over and over. For example, if you copy the formula in cell B7 to cell C7, the formula in C7 automatically adjusts to the new location, and calculates the numbers in C3:C6.
You can also use AutoSum on more than one cell at a time. For example, you could highlight both cell B7 and C7, click AutoSum, and total both columns at the same time.
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.
Note: For formulas to show results, select them, press F2, and then press Enter (Windows) or Return (Mac).
Data | ||
|---|---|---|
| 2 | ||
| 5 | ||
| Formula | Description | Result |
| =A2+A3 | Adds the values in cells A1 and A2 | =A2+A3 |
| =A2-A3 | Subtracts the value in cell A2 from the value in A1 | =A2-A3 |
| =A2/A3 | Divides the value in cell A1 by the value in A2 | =A2/A3 |
| =A2*A3 | Multiplies the value in cell A1 times the value in A2 | =A2*A3 |
| =A2^A3 | Raises the value in cell A1 to the exponential value specified in A2 | =A2^A3 |
| Formula | Description | Result |
| =5+2 | Adds 5 and 2 | =5+2 |
| =5-2 | Subtracts 2 from 5 | =5-2 |
| =5/2 | Divides 5 by 2 | =5/2 |
| =5*2 | Multiplies 5 times 2 | =5*2 |
| =5^2 | Raises 5 to the 2nd power | =5^2 |
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
This error is shown when you use an incorrect range operator in a formula, or when you use an intersection operator (space character) between range references to specify an intersection of two ranges that don't intersect. An intersection is a point in a worksheet where data in two or more ranges cross.
If you've used an incorrect range operator, make sure you use:
A colon (:) to separate the first cell from the last cell when you refer to a continuous range of cells in a formula. For example, SUM(A1:A10) refers to the range that includes cells A1 through cell A10.
A comma (,) as the union operator when you refer to two areas that don't intersect. For example, if the formula sums two ranges, make sure that a comma separates the two ranges (SUM(A1:A10,C1:C10)).
If you get this error because you've used a space character between ranges that don't intersect, change the references so that ranges do intersect.
For example, in the formula =CELL("address",(A1:A5 C1:C3)), the ranges A1:A5 and C1:C3 don't intersect, and the formula returns the #NULL! error. If you change this to =CELL("address",(A1:A5 A3:C3)), the CELL function returns the cell address at which the two ranges intersect—cell A3.
Tip: If error checking is turned on in Excel, you can click 
next to cell that shows the error. Click Show Calculation Steps if it's available. Then pick the resolution that works for your data.
Outlook on the web makes it easy to schedule your event or meeting, find a time that works for everyone, make it a Microsoft Teams meeting, or find the perfect meeting room in your organization.
Select Calendar.
Select an open time on your calendar.
Add the details of the event.
Add invitees to make it a meeting.
If you want to add more info, select More options.
Use the calendar to find a free time. Green means everyone is available. You can also select a Suggested free time or use Scheduling Assistant.
Add a Suggested location or Browse more rooms to use search to find the right spot.
If you want, make it a Teams meeting.
Add any more details and select Send.
Create, modify, or delete a meeting request or appointment in Outlook on the web
Using the Scheduling Assistant in Outlook on the web
Watch this video to learn how to create more complex formulas using multiple operators, cell references, and functions.
Now, we'll create more complex formulas using multiple operators, cell references, and functions.
We are going to calculate the sales commission based off of the net revenue.
To do this, I take the Sales Price and subtract from it the Cost of goods sold.
This is in parentheses to ensure it occurs first.
I then multiply the Net profit by the Commission percentage in B4, 3%.
This returns the commission.
Let's take a look at how this works in a formula.
Because the cell references are in parentheses, first the cost of goods sold is subtracted from the sales price.
This returns a Net profit of $3200.
This is then multiplied by 3%, returning a commission of $96.
Now, we are going to determine the Weighted scores for students.
By Weighted scores, I mean that different tests account for a different percentage of the students' final grade.
Tests 1 and 2, each account for 10%, and the mid-term and final tests, each account for 40%.
To do this, I multiply the Test 1 score for Bob by its Weight.
I press F4 after I select the Weight value in B3, so that when I copy the formula, the Weight for Test 1 will always remain cell B3.
This is referred to as Absolute Cell Reference.
I then add Bob's Mid-term score multiplied by its Weight in B4, and press F4 again.
I follow the same steps for Test 2 and the Final test.
To copy the formula, I click the cell, put the mouse pointer over the bottom right-hand corner of the cell until I get a black + sign, click the left mouse button, and drag the border to the right.
Here are the weighted scores for the students.
Let's take a look at what's happening in this formula for Bob's Weighted score.
Each of the test scores and their weights are multiplied, resulting in this formula.
Then the numbers are added together, resulting in 74.5.
What's the value returned by this formula? First, we do the inner most parentheses, 5 minus 3 is 2, resulting in this formula.
Next, we do the remaining parentheses, 10 times 2 is 20 and 1 minus 4 is -3, resulting in this formula.
Now, we do multiplication and division, from left to right.
6 times 20 is 120, divided by 3 is 40, resulting in this formula.
Lastly, we do addition and subtraction from left to right. 4 + 40 is 44, - 3 is 41.
You can use functions in formulas with multiple operators, including nested parentheses.
Functions and cell references are evaluated and treated as their resulting numbers.
The parentheses that follow a function name act only as a container for the function's arguments, such as numbers or cell references, and don't affect the order of operations in a formula.
Let's take a look at what's happening in this formula.
The functions and cell references are evaluated, resulting in this formula. The operations in parentheses occur first, resulting in a formula of 12 minus 3, and this is 9.
Now, you have a good idea about how to do basic math in Excel.
Of course, there's more to learn.
So, check out the course summary at the end, and best of all, explore Excel 2013 on your own.
In Reading view you can step through the presentation and read notes.
Move from slide to slide, or to the next effect on the same slide. Click Notes to open and close the Notes pane.
Click Start Slide Show to see the presentation full-screen. If you connect your computer to a projector, you can use this mode to present the slide show.
Click Edit in Browser to edit the presentation in the browser; click Open in PowerPoint to work on it in the PowerPoint desktop application.
Editing view is where you add and remove slides and edit the content of slides.
PowerPoint Web App has the familiar look and feel of PowerPoint:
On the File tab, click Print to print the slide show (In Reading view and in Editing view).
The Home tab has commands for formatting text. Also use the Home tab to add, delete, duplicate, and hide slides.
Use the Insert tab to add pictures, SmartArt graphic, hyperlinks, and clip art.
Use the View tab to switch back to view mode or to run the slide show.
PowerPoint Web App saves your work automatically. Use Undo to get rid of changes you don't want to keep.
In Microsoft OneNote for IPad you can convert crudely drawn shapes into perfect circles, ovals, squares, rectangles, and triangles to help you create professional-looking diagrams and drawings.
On the Draw tab, select the pen, color, and stroke thickness you want, and then tap the Ink to shape tool near the far right of the ribbon.
On the page, use your finger or stylus to draw a shape — such as a circle, oval, square, rectangle, or triangle. You can draw the shape in one stroke (for example, a circle or an oval) or with several strokes (for example, a square, a rectangle, or a triangle).
For best results, be sure to connect your ink strokes as best as you can.
If you make a mistake at any time while drawing, or if OneNote's recognition of the shape is not what you wanted, you can tap the Undo arrow near the top left corner of the app to undo the last action, and then try again. If necessary, you can tap the Undo arrow repeatedly to step back in your drawing as far as you want.
If you want OneNote to stop recognizing and correcting shapes, tap the Ink to shape tool once more to turn off shape recognition.
This feature is currently not available when using Microsoft OneNote on iPhone.
When you edit a file in the OpenDocument Text (.odt) format by using Word for the web, and then open it again in Word 2010, you might notice some formatting differences between the original version and the edited version. Likewise, you might also see formatting differences when you open an OpenDocument Text file in Word for the web. This is because of the different features that the file formats support.
Note: The differences you will experience when you work with two file formats are generally limited to formatting differences. Data and content will convert, but how you format and interact with the data and content might be different between the formats.
The following table shows which Word for the web feature areas are supported or partially supported in the OpenDocument (.odt) format.
Supported Both Word for the web and the OpenDocument Text format support this feature. Content, formatting, and usability will not be lost.
Partially Supported Both Word for the web and the OpenDocument Text format support this feature, but formatting and usability might be affected. No text or data is lost, but formatting and how you work with text or graphics might be different.
For information about graphic features that are fully, partially, or not supported in the OpenDocument Format, see the Graphics Features table later in this article.
Area | Subarea | Level of support | Comments |
|---|---|---|---|
| Collaboration | Mail Merge | Supported | The connection to the data source must be established again if the document is edited by another ODF application. |
| Content | Cross References | Supported | |
| Content | Equation Editor | Supported | |
| Content | Equations | Supported | |
| Content | Footnotes-Endnotes | Supported | Custom separators not supported. |
| Content | Header-Footer | Supported | |
| Content | Index | Supported | Multiple columns indices not supported. |
| Content | Insert Break | Partially Supported | Continuous section breaks might lose some properties, such as top/bottom margins, headers/footers, borders, and line numbering. |
| Content | Office Art | Supported | See Graphics Features table for details. |
| Content | Page Numbering | Supported | |
| Content | Pictures | Supported | Pictures from a document created in OpenOffice are not displayed. |
| Content | Tables | Partially Supported | Tables with more than 64 columns are not supported. |
| Content | Text boxes | Partially Supported | Text boxes cannot be nested. |
| Content | Table of Contents (TOC) | Partially Supported | TOC loses items labeled with a SEQ field. |
| Editing | AutoCorrect | Supported | |
| Editing | Cut-Copy-Paste | Supported | |
| Editing | Drag and Drop | Supported | |
| Editing | Envelopes and Labels | Supported | |
| Editing | Selection | Supported | |
| Editing | Undo-Redo-Repeat | Supported | |
| File Operations | WSS Integration | Supported | |
| Formatting | Borders and Shading | Supported | Patterns on shading not supported. |
| Formatting | Bullets and Numbering | Supported | Spacing between number/bullet and text might be slightly different. |
| Formatting | Drop Caps | Supported | Anchors to some regions of the margin are not supported. |
| Formatting | Highlighter | Supported | The highlighting is converted to character background color when you save the document. |
| Formatting | Horizontal Lines | Supported | |
| Formatting | Paragraph | Supported | |
| Formatting | Reveal Formatting | Supported | |
| Formatting | Styles | Supported | There is an increase in the number of styles after you save the document in .odt format, and all formatting in ODF is style based. |
| Formatting | Tabs | Supported | Positional tabs are not supported. |
| Formatting | Text Columns | Supported | Some properties associated with the section might be lost, for example, top/bottom margins, headers/footers, borders, or line numbering. |
| Formatting | Text Orientation | Partially Supported | The following text orientation formats are supported: |
| Formatting | Positioning | Partially Supported | The position of some text boxes, frames and shapes might change depending on the type of anchor used. |
| Infrastructure | Bookmarks | Supported | |
| Infrastructure | Fields | Partially Supported | Fields that are not supported are converted to plain text. |
| Infrastructure | Hyperlinks | Supported | Documents from OpenOffice do not have the hyperlink style applied but are still functional. |
| Infrastructure | OLE | Partially Supported | Objects embedded in document created in OpenOffice are not displayed. The image type is not supported, and the link is relative. |
| International | IME | Supported | |
| International | Two Lines in One | Supported | |
| Printing | Supported | ||
| Proofing | Language AutoDetect | Supported | |
| Proofing | Language Properties | Supported | |
| Proofing | Spelling | Supported | Areas of text that that are marked "don't check spelling or grammar" will lose that property. Spelling and grammar will now be checked for that text. |
The following table shows which graphics features are supported or partially supported in the OpenDocument Format (.odt).
Supported Both Word for the web and the OpenDocument Format support this feature. Graphics using this feature generally appear and behave the same in either format.
Partially Supported Both Word for the web and the OpenDocument Format support this feature, but graphics might appear different between the formats. No data is generally lost between the formats, but formatting and how you work with these graphics might be different.
Basic Shapes | Level of support | Comments |
|---|---|---|
| Shapes | Supported | |
| Text boxes | Supported | Supported except for objects in text boxes that are partially supported for Word 2010. SmartArt graphics, shapes, or text boxes inside a text box are not supported and are lost when you open the file. |
| WordArt | Supported | |
| 3D shapes options | Supported | |
| Pictures | Supported | Supported except for the insert and link option that are not supported by ODF. |
| Objects in charts | Supported | Converted to a group containing the chart and objects. Word 2010 cannot support a group containing a chart so the objects are ungrouped when you open the file in Word 2010. |
| Ink annotation | Supported | The ink annotation is converted to an Enhanced Metafile (EMF) image. |
| Group of objects | Partially Supported | Some objects cannot be grouped together in Word 2010, so the objects are ungrouped when you open the OpenDocument file. This includes anything grouped with a chart, and a picture grouped with a shape, text box, or OLE object. |
| Object visibility | Partially Supported | Invisible objects become visible after saving the file and opening again in Word 2010. |
| Object borders | Supported | Not all border styles are supported. Border styles that are not supported are saved as the default border style (black, solid line). |
| Object fills | Supported | Supported except for gradient fills with more than two stops lose all stops after the first two. |
| Line formatting | Supported | Not all line and line end styles are supported in ODF. Styles that are not supported are saved as the default, black solid line and open arrow type, respectively. |
| Picture recoloring | Partially Supported | Some picture recoloring has the equivalent in ODF, such as black and white. Other picture recoloring does not have an equivalent and is flattened. The picture appears the same but the recoloring can no longer be changed or removed. |
| Picture styles | Partially Supported | Borders are partially supported, but might not look the same. |
")
"
