When is excel 2018 coming out

Now supports Office Preview. Learning Tools improve readability: Give your eyes a rest. Adjust text spacing, column width, and page color. Or listen as Word reads your document aloud, highlighting text as it's read. Fill data in a flash: Give Flash Fill a few examples, and it will fill your data for you.

Learn more Break the language barrier: Translate words, phrases, or sentences in another language with Microsoft Translator. Break the language barrier: Translate words, phrases, or sentences in another language with Microsoft Translator. Learn more Hyperlinks in living colors: Hyperlinks aren't just blue anymore.

Create a signature they'll remember: Express yourself with rich font styles, colors, images, links, and more. No problem! Add and remove members, too. Collaboration on the Mac just got easier. Chat with co-authors while you edit: Collaborate more effectively by chatting with your co-authors without ever leaving Word. Learn more Insert and edit icons: Use icons to add visual impact to your document by inserting and editing one of icons. Learn more Write your best resume or CV with help from LinkedIn: Resume Assistant shows you work experiences, top skills, and more for a given role.

Find it on the Review tab. Learn more Accessibility built right in: Use your keyboard to access the ribbon quickly and to format the words or pictures you just inserted. Chat with co-authors while you edit: Collaborate more effectively by chatting with your co-authors without ever leaving Excel. Learn more Insert and edit icons: Use icons to add visual impact to your workbook by inserting and editing one of icons.

Learn more Use a timeline to filter your data: Easily filter a PivotTable by sliding the date range with a timeline filter. Chat with co-authors while you edit: Collaborate more effectively by chatting with your co-authors without ever leaving PowerPoint. Learn more Insert and edit icons: Use icons to add visual impact to your presentation by inserting and editing one of icons.

Customize swipe gestures: Set the swipe left and swipe right gestures to the actions you use most. Better sharing and collaboration: Your locally synced OneDrive documents open directly from the cloud, allowing you to AutoSave, share, and collaborate easily. Add visual impact: Insert and edit Scalable Vector Graphics SVGs in your documents to add visual interest and retain a high image quality. Better sharing and collaboration: Your locally synced OneDrive workbooks open directly from the cloud, allowing you to AutoSave, share, and collaborate easily.

Add visual impact: Insert and edit Scalable Vector Graphics SVGs in your workbooks to add visual interest and retain a high image quality. Better sharing and collaboration: Your locally synced OneDrive presentations open directly from the cloud, allowing you to AutoSave, share, and collaborate easily.

Add visual impact: Insert and edit Scalable Vector Graphics SVGs in your presentations to add visual interest and retain a high image quality. Add visual impact: Insert and edit Scalable Vector Graphics SVGs in your emails to add visual interest and retain a high image quality. Learn more A more actionable calendar: Click any meeting or event in your calendar to see all of the associated details. Check out who is invited, edit your response, or join the meeting, all in one place.

Easier scanning of search results: Outlook highlights your search term in the item list or Preview pane. Week numbers: Week numbers are now displayed in Calendar month view and mini-calendar in the sidebar. Scheduling Skype meetings: Delegates can now schedule Skype for Business Online meetings on behalf of principals using principals' email addresses. Skype for Business Online only. This will be enabled for Skype for Business Server in a future server update.

Improved error handling when editing and deleting server rules. Server rules containing errors are now highlighted when first displayed in the rules list.

Support for the msupdate command-line tool. Do more with Focus Mode: Focus Mode now opens at your set zoom level and shows the page number while you scroll. Embedded fonts: Embedded fonts ensure that your presentation looks the same on every computer and people experience your content as you intend.

Tables: Insert tables in your messages and calendar events, and bring structure to your content. No more copying and pasting from other Office apps. Learn more View two time zones at once: Want to know what time it is in another part of the world? Now you can add a second time zone to Outlook. Schedule across time zones: Traveling across time zones?

Create an event with different start and end time zones, and Outlook will take care of the conversion. Change text size: Increase or decrease the font size in your sidebar, message list, and reading pane. Fix an issue, where if the default time zone for your computer observes daylight saving time DST and Week view is selected, you may see that all events are shifted by one hour on the calendar grid on the week when DST starts.

Precision selecting: Ever selected too many cells or the wrong ones? You can now deselect extraneous cells without having to start over. Learn more Slice and dice your table data: You loved slicers for PivotTables. You can now use them in tables too to see exactly what filters you have applied.

Shine the light on what matters: Grab the new highlighter to flag important information. Edit with others in real time: Thumbnails in the upper-right corner of the window show who else is working with you in a shared document.

Flag icons show where others are working and you can view changes as they type. Learn more We save for you! Changes are saved automatically for documents, worksheets, and presentations stored in the cloud, and you can see others' updates in seconds.

Need to roll back? Check the version history for a list of changes and access to earlier versions. Learn more Quickly access your sites and groups: Quickly find presentations stored in your frequently used sites and groups in the Open menu. Collaborative editing: Work with others at the same time in your workbook. Thumbnails in the upper-right corner of the window show who else is viewing or editing the file with you.

Learn more More charts: Use new charts, such as funnel, sunburst and histogram, to transform your data into professional visualizations, or use the new Map chart type to transform geographic data into a map with just a few steps. Quickly access your sites and groups: Quickly find presentations stored in your frequently used sites and groups in the Open menu. Better support for PivotTable charts: Change your filters in a PivotTable, and the chart you created will automatically adjust to show exactly what you want.

Multi-threaded calculation Formulas are updated faster when values are changed, because Excel uses multiple processing threads. Learn more See what's changed: Slides that have been modified by others while you were away are highlighted. Learn more A quick start to your research: Starting from scratch is hard. QuickStarter automatically creates an outline for your topic of choice with suggested talking points and designs that make your presentation pop.

Learn more Trim media: Remove unwanted content from the beginning or end of an audio or video clip. Laser pointer in Slide Show: Use your mouse as a laser pointer to draw attention to certain parts of your slide. Text Highlighter: Text highlight is now on Mac! Use text highlighter to emphasize important pieces of text.

Archive or delete with just one swipe: Save time organizing your Inbox by swiping left with two fingers across the touchpad to archive an email or swiping right to delete it.

Improved readability and accessible, too: Your email message and meeting invitation headers are now easier on the eyes. Less clutter, better keyboard navigation, and improved VoiceOver.

Alerts users to re-install MAU when missing or broken components are detected. Researcher: Find relevant quotes, citable sources, and images without leaving Word. If the link is deemed malicious, the user is redirected to a warning page instead of the original target URL.

Pictures in headers and footers: Customize your printed workbooks by adding images to headers and footers. Send email on your schedule: Delay the delivery of a message or choose when it will be sent. Learn more All your favorite folders in one place: Create shortcuts to all the folders you use regularly.

All shortcuts are listed in Favorites at the top of your Sidebar. Learn more Format Painter: Available when creating emails, events, and tasks. Spend less time writing emails: Create an email template and reuse it later to save time. If you need help with an issue with using Office, we recommend that you post your question on Microsoft's Answers forum or Tech Community , or you can contact support.

Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. And it puts tasks you rarely do within easy reach as well.

You can also use it to look up word definitions using Bing, and users with Office business accounts can use it to search for company contacts or for files stored in OneDrive or SharePoint. Right-click a cell with a word or group of words in it, and from the menu that appears, select Smart Lookup.

Click any result link to open the full page in a browser. If you just want a definition of the word, click the Define tab in the pane. If you want more information, click the Explore tab in the pane. Smart Lookup is handy for finding general information, such as definitions of financial terms. And also keep in mind that Microsoft is constantly enhancing its AI capabilities in Office, so Smart Lookup has improved over time. Once you do so, it will be turned on across all your Office applications.

Charts are great for visualizing and presenting data, and for gaining insights from it. If you use the older. Select any to create the chart. Excel for Office includes several new chart types, including waterfall.

This chart type creates a hierarchical view of your data, with top-level categories or tree branches shown as rectangles, and with subcategories or sub-branches shown as smaller rectangles grouped inside the larger ones. Thus, you can easily compare the sizes of top-level categories and subcategories in a single view. A treemap chart lets you easily compare top-level categories and subcategories in a single view.

This chart type also displays hierarchical data, but in a multi-level pie chart. Each level of the hierarchy is represented by a circle. The innermost circle contains the top-level categories, the next circle out shows subcategories, the circle after that subsubcategories and so on. Sunbursts are best for showing the relationships among categories and subcategories, while treemaps are better at showing the relative sizes of categories and subcategories.

A sunburst chart shows hierarchical data such as book categories and subcategories as a multi-level pie chart. This chart type is well-suited for visualizing financial statements. It displays a running total of the positive and negative contributions toward a final net value. A waterfall chart shows a running total of positive and negative contributions, such as revenue and expenses, toward a final net value.

This kind of chart shows frequencies within a data set. It could, for example, show the number of books sold in specific price ranges in a bookstore. Histograms are good for showing frequencies, such as number of books sold at various price points. This chart, also known as a sorted histogram, contains bars as well as a line graph. Values are represented in descending order by bars. The cumulative total percentage of each bar is represented by a rising line. In the bookstore example, each bar could show a reason for a book being returned defective, priced incorrectly, and so on.

The chart would show, at a glance, the primary reasons for returns, so a bookstore owner could focus on those issues. In a Pareto chart, or sorted histogram, a rising line represents the cumulative total percentage of the items being measured. This chart, like a histogram, shows frequencies within a data set but provides for a deeper analysis than a histogram.

For example, in a bookstore it could show the distribution of prices of different genres of books. Outliers that are priced outside the whiskers are shown as dots, the median price for each genre is shown with a horizontal line across the box, and the mean price is shown with an x.