Microsoft Office 2021 empowers you to work from anywhere. This all-in-one solution offers intelligent tools for individuals, teams, and businesses, enabling a seamless workflow across all your devices. With Office 2021, you can effortlessly access your documents and applications, giving you the flexibility to get your work done wherever you are.
Get the powerful tools you need to do your best work. Microsoft Office 2021 delivers the full suite of desktop applications, including Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access. With this package, you’re always using the latest versions of the software. It’s fully optimized to let you capture your ideas using a keyboard, a digital pen, or a touchscreen, giving you total creative control.
Microsoft Office 2021 is built to meet the demanding needs of modern businesses. It comes equipped with advanced security, compliance, and deployment features that empower organizations with enhanced control over their sensitive data. This also provides IT departments the flexibility and oversight required for streamlined software management across the enterprise.
Microsoft Office 2021 is no longer just for your desktop. With a newly expanded footprint on iPad and Android tablets, along with an upgraded experience on the Mac, iPhone, and web, you can get your work done from any device. The Office family also includes powerful new apps such as Sway and Office Lens, ensuring you have everything you need to keep your projects moving forward, no matter where you are.
Microsoft Office 2021 ensures you can work with anyone, regardless of their Office version. This suite, which includes Word, Excel, PowerPoint, and Outlook, provides complete backward compatibility. You can effortlessly open documents from Office 2007 all the way through Office 2016 and Office 365 without any extra effort. If you’re using a much older version, a quick compatibility pack download will get you up and running in no time.
Your documents, anywhere.
Across the Office applications, it’s easier to use the power of feature-rich applications. You can access them from anywhere and on any device to create, open, edit, and save files in the cloud from your desktop. In addition, new modern attachments in Outlook make it easy to attach files from OneDrive. Especially relevant, it automatically configures permission for the recipients – without leaving Outlook.
Collaboration.
Real-time co-authoring is available today in Office Online apps. When you are working in Word 2021 and/or Office online, you’ll be able to see where other editors are working and what they are writing. All in real-time.
Smart Applications.
Applications will learn as you work, taking advantage of subtle cues and clues to help you stay on task and get more out of the Office. Tell Me is a new search tool available in Word, PowerPoint, and Excel. It serves up the commands you need by simply typing what you want to do. Clutter – a new Exchange feature that lights up in Outlook. It uses machine learning to analyze your email patterns. And de-clutter your inbox by moving lower-priority messages out of your way and into a new Clutter folder. And Insights, powered by Bing, finds contextual information from the web within the reading experience.
Data analysis was made faster and easier.
New analysis capabilities are built into Excel, so you can pull, map, analyze, and visualize your data faster and easier than ever.
- One-click forecasting. Create forecasts on your data series with one click to future trends.
- Intuitive data connecting and shaping capabilities. With integrated Power Query, use Excel as your personal analysis workspace by connecting to and viewing all the data around you. Take advantage of a broad range of data sources, including tables from websites, corporate data like SAP Business Objects, unstructured sources like Hadoop, and services like Salesforce.
- Easy data modeling and powerful analysis. With improved Power Pivot features as part of Excel, you can map different data sets with drag-and-drop ease to build data models to give you the bigger picture of your business. Take advantage of intuitive analysis functions, automatic time grouping, and other features. They enhance your PivotTable and PivotChart analysis experience.
- Publish to Microsoft Power BI Preview. Easily publish and share your Excel workbooks with Power BI users.
- New modern charts and graphs, including TreeMap, Sunburst, Waterfall, Box and Whisker Histogram, and Pareto in Excel, help you to present your data in fresh ways.
New in Microsoft Office 2021:
In Office 2021, you’ll find new inking tools, data types, functions, translation and editing tools, motion graphics, ease-of-use features, and so much more!
Look left, look right… XLOOKUP is here:
- Row by row, find anything you need in a table or range with XLOOKUP.
Dynamic arrays:
- Write one formula and return an array of values. Expedite calculations and insights with six new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
LET function:
- The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula.
XMATCH function:
- The XMATCH function searches for a specified item in an array or range of cells and then returns the item’s relative position. You can also use XMATCH to return a value in an array.
New and improved Record Slide Show:
- Record Slide Show now supports presenter video recording, ink recording, and laser pointer recording
Replay your ink strokes:
- Take your presentations to the next level with the ink replay feature. You can now replay your ink strokes as a dynamic, step-by-step illustration, which is perfect for demonstrating a complex thought process or guiding your audience through a problem. The best part? You have total control: pause the replay at any moment and even choose a new starting point to skip ahead or focus on a specific detail.
Arrange elements on your slides for screen readers:
- See the elements in screen-reading order and re-arrange them as necessary to communicate your message effectively.
Translator and ink in Outlook:
- Translate email messages into more than 70 languages on the fly and view the transcript—all within Outlook.
- Annotate email images or draw in a separate canvas using your finger, pen, or mouse.
In Outlook, use Instant Search for instant email retrieval:
- Select the search bar (located above the Outlook ribbon) to help find email messages anywhere in Outlook.
Visual refresh:
- Work with a modernized Start experience and newly refreshed tabs in the ribbon.
- Experience a clean, clear style with Monoline iconography that communicates action and features through simple imagery.
See what’s new in stock media:
- We’re constantly adding more rich media content to the Office Premium Creative Content collection, a curated library of stock images, icons, and more that helps you express yourself.
Find what you need with Microsoft Search:
- At the top of your Microsoft Office apps on Windows, you’ll find the new Microsoft Search box. This powerful tool helps you quickly find what you’re looking for, from text and commands to help and more.
Performance improvements:
- Experience improved performance, stability, and speed across Word, Excel, PowerPoint, and Outlook.
- Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.
Updated Draw tab:
- Quickly access and change the color of all your inking tools in one place.
- Simplify your work with ink using new Draw tab additions: Point Eraser, Ruler, and Lasso.
Save your changes as they happen:
- Upload your files to OneDrive, OneDrive for Business, or SharePoint Online to make sure all your updates are saved automatically.
Support for OpenDocument format (ODF) 1.3:
- We now include support for the OpenDocument format (ODF) 1.3. The ODF 1.3 specification adds support for many new features.
Refresh, relink, or remove linked tables:
- The updated Linked Table Manager serves as a central hub for viewing and managing all data sources and linked tables within an Access database.
Try the new Date/Time Extended data type in Access:
- For enhanced syntax compatibility with SQL and greater accuracy and detail in records that include dates and times, we’ve implemented the SQL DateTime2 data type within Access.
Keep tabs on your database objects in Access:
- You can see the active tab, easily drag tabs to rearrange them, and close database objects with just one click.
New Azure stencils and shapes in Visio:
- We’ve added many more stencils to help you create up-to-date Azure diagrams. You can use these new stencils to build Azure diagrams for network topologies, virtual machine configurations, operations, and more.
New AWS stencils and shapes in Visio:
- We have enabled infrastructure shapes from another major cloud provider: Amazon Web Services (AWS). You can now use stencils with the latest AWS shapes to help you create diagrams.
Content for social distancing planning in the workplace:
- To help workplaces follow social distancing guidelines, we’ve created a new Visio template and Workplace Social Distancing stencil. This powerful tool offers a variety of shapes, patterns, and lines — both scaled and unscaled — to help you quickly redesign your office layout and maintain a safe environment.
Try the Sketched style outline:
- You can give a casual, hand-drawn look to shapes in your presentations with the Sketched style outline.
- Try out the Curved, Freehand, or Scribble options under Format Shape > Line > Sketched Style.
Pick the perfect color:
- Based on your feedback, we’ve added a new input field in the Colors dialog for Hex color values. Now you won’t have to spend time converting Hex color values into RGB values.
- For any property where you can define color, you can now enter a Hex color value in the Hex box, for example, #0F4C81 or 444.
Microsoft Office 2021 supports PCs or Windows tablets running Windows 7 or higher.
Microsoft Office 2021 is available in English, Arabic, Brazilian (Portuguese), Bulgarian, Chinese Simplified, Chinese Traditional, Croatian, Czech, Danish, Dutch, Estonian, Finnish, French, German, Greek, Hebrew, Hindi, Hungarian, Indonesian, Italian, Japanese, Kazakh, Korean, Latvian, Lithuanian, Malay, Norwegian, Polish, Portuguese, Romanian, Russian, Serbian (Latin), Slovenian, Slovak, Spanish, Swedish, Thai, Turkish, Ukrainian, and Vietnamese.
