Office Apps

Microsoft Word 2024 is the latest version of Microsoft's acclaimed word processing software, designed to enhance productivity and streamline document creation. With a modernized interface and a host of new features, Word 2024 empowers users to easily create professional documents, whether for personal use, education, or business. Benefits of Microsoft Word 2024 Improved Collaboration: Enhanced commenting features allow users to like and respond to comments, making teamwork more efficient and interactive. Automatic Document Recovery: In the event of a crash or unexpected closure, Word 2024 automatically restores all open documents, ensuring you never lose your work. Advanced Formatting Options: New features like multiple column layouts and line numbering provide greater flexibility in document design. User-Friendly Interface: A revamped design aligned with Microsoft's Fluent Design principles offers an intuitive experience that simplifies navigation and document management. Features of Microsoft Word 2024 Cameo Integration: Embed live camera feeds directly into your documents for more engaging presentations and collaborations. Checkbox Support: Easily create checklists with hotkey insertion for better document task management. Enhanced Navigation Pane: A redesigned navigation pane allows quicker access to sections and improved document organization. Paste Formatting by Default: The new "Merge Formatting" feature automatically matches pasted text formatting to the destination, streamlining the editing process. Support for OpenDocument Format (ODF) 1.4: Improved compatibility with ODF 1.4 enhances document sharing across different platforms. System Requirements Windows: Windows 10 or later Processor: 1.6 GHz or faster processor RAM: Minimum of 4 GB RAM; 2 GB RAM for 32-bit Storage: At least 4 GB of available disk space Display: 1280 x 768 screen resolution or higher Internet Connection: Required for installation, activation, and updates Microsoft Word 2024 is essential for anyone looking to enhance their writing capabilities while enjoying a robust set of features designed for modern productivity.

Microsoft Word 2024 for Mac is the latest version of Microsoft's acclaimed word processing software, designed to enhance productivity and streamline document creation. With a modernized interface and a host of new features, Word 2024 empowers users to easily create professional documents, whether for personal use, education, or business. Benefits of Microsoft Word 2024 for Mac Improved Collaboration: Enhanced commenting features allow users to like and respond to comments, making teamwork more efficient and interactive. Automatic Document Recovery: In the event of a crash or unexpected closure, Word 2024 automatically restores all open documents, ensuring you never lose your work. Advanced Formatting Options: New features like multiple column layouts and line numbering provide greater flexibility in document design. User-Friendly Interface: A revamped design aligned with Microsoft's Fluent Design principles offers an intuitive experience that simplifies navigation and document management. Features of Microsoft Word 2024 for Mac Cameo Integration: Embed live camera feeds directly into your documents for more engaging presentations and collaborations. Checkbox Support: Easily create checklists with hotkey insertion for better document task management. Enhanced Navigation Pane: A redesigned navigation pane allows quicker access to sections and improved document organization. Paste Formatting by Default: The new "Merge Formatting" feature automatically matches pasted text formatting to the destination, streamlining the editing process. Support for OpenDocument Format (ODF) 1.4: Improved compatibility with ODF 1.4 enhances document sharing across different platforms. System Requirements macOS: Latest three versions of macOS Processor: 1.6 GHz or faster processor RAM: Minimum of 4 GB RAM; 2 GB RAM for 32-bit Storage: At least 4 GB of available disk space Display: 1280 x 768 screen resolution or higher Internet Connection: Required for installation, activation, and updates Microsoft Word 2024 is essential for anyone looking to enhance their writing capabilities while enjoying a robust set of features designed for modern productivity.

Microsoft Excel 2024 is the ultimate tool for transforming your data into actionable insights. Whether you're a business professional, a student, or simply someone who loves to organize information, Excel 2024 is designed to elevate your productivity and creativity. With advanced AI capabilities and a user-friendly interface, managing your spreadsheets has never been easier or more efficient. Why Choose Microsoft Excel 2024? Enhanced AI Features: Utilize the powerful Copilot to automate tasks, generate insights, and create stunning visualizations effortlessly. Seamless Collaboration: Share and collaborate in real-time with colleagues, ensuring everyone stays on the same page no matter where they are. Advanced Data Analysis: Leverage new functions like TRIMRANGE and Python integration for deeper analysis and streamlined workflows. User-Centric Design: Enjoy an intuitive interface that simplifies complex tasks, making it accessible for users of all skill levels. Features Copilot Integration: Experience the future of productivity with Copilot, which assists in creating custom charts and PivotTables and summarizing textual data. Simply prompt Copilot with your requirements, and watch it work its magic. Dynamic Watermarking: Protect sensitive information with dynamic watermarking powered by Microsoft Purview Information Protection. This feature prevents unauthorized actions like screenshots while allowing full collaboration. Regex Modes for XLOOKUP and XMATCH: Unlock new capabilities with regex modes in XLOOKUP and XMATCH functions. This allows for more flexible data matching and searching within your spreadsheets. Performance Optimization Tools: Utilize the new "Check Performance" feature to optimize large workbooks for faster loading times and improved navigation. This ensures you can focus on analysis without delays. Python Integration: For advanced users, Excel 2024 now supports Python integration through Copilot. Conduct complex analyses using plain English prompts that generate Python code directly within your spreadsheet. System Requirements Operating System: Windows 10 or later, macOS Monterey or later Processor: 1.6 GHz or faster, 2-core processor RAM: 4 GB RAM; 2 GB RAM (32-bit) Storage: At least 4 GB of available disk space Display: 1280 x 768 screen resolution

Microsoft Excel 2024 is the ultimate tool for transforming your data into actionable insights. Whether you're a business professional, a student, or simply someone who loves to organize information, Excel 2024 is designed to elevate your productivity and creativity. With advanced AI capabilities and a user-friendly interface, managing your spreadsheets has never been easier or more efficient. Why Choose Microsoft Excel 2024? Enhanced AI Features: Utilize the powerful Copilot to automate tasks, generate insights, and create stunning visualizations effortlessly. Seamless Collaboration: Share and collaborate in real-time with colleagues, ensuring everyone stays on the same page no matter where they are. Advanced Data Analysis: Leverage new functions like TRIMRANGE and Python integration for deeper analysis and streamlined workflows. User-Centric Design: Enjoy an intuitive interface that simplifies complex tasks, making it accessible for users of all skill levels. Features Copilot Integration: Experience the future of productivity with Copilot, which assists in creating custom charts and PivotTables and summarizing textual data. Simply prompt Copilot with your requirements and watch it work its magic. Dynamic Watermarking: Protect sensitive information with dynamic watermarking powered by Microsoft Purview Information Protection. This feature prevents unauthorized actions like screenshots while allowing full collaboration. Regex Modes for XLOOKUP and XMATCH: Regex modes in the XLOOKUP and XMATCH functions unlock new capabilities, allowing for more flexible data matching and searching within your spreadsheets. Performance Optimization Tools: Utilize the new "Check Performance" feature to optimize large workbooks for faster loading times and improved navigation. This ensures you can focus on analysis without delays. Python Integration: Excel 2024 now supports Python integration through Copilot for advanced users. Conduct complex analyses using plain English prompts that generate Python code directly within your spreadsheet. System Requirements Operating System: Windows 10 or later, macOS Monterey or later Processor: 1.6 GHz or faster, 2-core processor RAM: 4 GB RAM; 2 GB RAM (32-bit) Storage: At least 4 GB of available disk space Display: 1280 x 768 screen resolution

Install for one device One-time purchase for 1 person Licensed for home and school use Runs on Windows 10 & 11 (PC version only) Create amazing and engaging documents using Word 2021  Word 2021 for Windows enables you to create compelling content and includes new stock media from the Office Premium Creative Content collection. It also has some handy additions like the Point Eraser, Ruler, and Lasso tools to help with your artistic endeavors. Word 2021 for Windows enables you to create compelling content, including co-authoring, improved performance, and new stock media from the Office Creative Content collection. You also get Draw tab additions such as Lasso, Point Eraser, and Ruler. And if you're upgrading to Word 2021 for Windows from Word 2019, you'll have the features you're used to — and new ones. Improved performance Word 2021 for PC is the most efficient and stable version of Word yet, with improved performance on all Windows. It provides faster operations and smoother workflow! Co-authoring You and your colleagues can co-work on the same document - co-authoring - allowing you to see each other's changes almost instantly. Visual refresh With updated tables and modernized ribbon, the new and improved Start experience in Word 2021 will help you start your project the right way. It doesn't get any more convenient than this! Experience a clean, clear style with a neutral color palette, monoline iconography, and softer window corners.  Microsoft Search With Microsoft Search, find what you need in Word 2021 with one click. The new Microsoft Search box is located at the top of your app on Windows and provides powerful features to help users quickly locate any information they are looking for from text files or commands that would otherwise require hours scouring through online documentation. Autosave Toggle You can now save your changes as they happen. Upload your files to OneDrive for Business, OneDrive, or SharePoint Online to ensure you save all updates automatically. Insert premium content Update your Office library with the new features in Word 2021 and create professional-looking documents with rich media content! Microsoft is constantly adding more shapes and icons to this collection. New Draw tab Word 2021 has just made it easier to work with digital ink. With new additions in the Draw tab, you can now access all of your tools from one place and quickly change their colors without ever having to open another app! Simplify your work in Word 2021 with ink using a new Draw tab containing tools like the Point Eraser and Lasso. Sketched style outline Try out the Sketched style outline in Word 2021. With this new feature, you can give a casual, hand-drawn look to shapes, and it's easy as pie! First, make your shape however you want, then go into Format Shape > Line > Sketched style. Try out the Curved, Freehand, or Scribble options for some unique looks to add interesting visual touches to your Word documents. Processor: Windows 11 or Windows 10 with 1.6 GHz Operating system: Windows 11 or Windows 10 for PC Memory: 4 GB (64bit), 2 GB (32bit) RAM Hard disk space: 4 GB available disk space Display: 1024 x 768 resolution for PC Graphics: DirectX 10 graphics card for graphics hardware acceleration for PC Additional system requirements: Internet access, Microsoft account

Install for one device One-time purchase for 1 person Licensed for home and school use Runs on the latest macOS (Mac version only) Create amazing and engaging documents using Word 2021  Microsoft Word 2021 for Mac has come with new features, better tools, and a visual overhaul. Users also get special sets of tools that help in various fields, such as design and digital inking. Microsoft Word 2021 for Mac has come with new features, better tools, and a visual overhaul. Users also get special sets of tools that help in various fields, such as design and digital inking. Improved performance Word 2021 for Mac is the most efficient and stable version of Word yet, with improved performance on all macOS systems. With this new update, you can expect to experience faster operations that will allow a smoother workflow! Co-authoring Enjoy document co-authoring between you and your colleagues, family, or friends as you see each other's changes quickly — almost immediately. Advanced page color Do you find reading on the computer a strain on your eyes? Word for Mac 2021 has an updated Immersive Reader with ways to choose a page color that will make text easy to scan with less eye strain. Choose from 20+ predefined colors to pick their own page color as well! Autosave, save your changes as they happen Upload your files to OneDrive for Business, OneDrive, or SharePoint Online to set all your updates to save automatically. Natural Read Aloud voices The improved Read Aloud feature in Word 2021 for Mac is great not only to give your eyes a break but also as an opportunity to catch any errors before they reach readers. With more natural sounding voices and improved accessibility features like Line Focus that enhance the listening experience, this will be one tool you can't afford to live without! Dark Mode, to reduce eye strain  Previously, Word only had a dark ribbon and toolbars, but your document color stayed bright white. Now, the whole Word document has a Dark Mode canvas. Plus, you can balance the colors. Insert premium content Update your office library with the new features in Word 2021 for Mac. Create professional-looking documents with rich media content using the improved Office Premium creative content collection.  Word “Tell me” bar is in Mac Use the Tell-me bar, an in-app search solution, to find text, features, and help without having to fire up your browser or ask for assistance. Just enter keywords, and Word 2021 will find what you want. Visual refresh Use the new and improved start experience to start your project correctly. A modernized ribbon, updated tabs, and more allows Word 2021 for Mac to give you easier access to tools! Experience a clear style and clean monoline iconography that communicates features and action with simple visuals. Line Focus to Improve comprehension Move through your document in Word 2021, line by line, without distractions. You just need to adjust the focus to put one, three, or five lines in view at a time. Save as SVG Save your pictures and graphics as SVG in Word 2021 for Mac. The app now supports saving various elements from your documents without losing quality when upscaling. You can also resize these SVG files without affecting their appearance when displayed on screen or printed. Sketched style outline Try out the Sketched style outline in Word 2021 for Mac. With this new feature, you can give a casual, hand-drawn look to shapes, and it's easy as pie! Free for iPad Microsoft Word 2021 for Mac is now free for iPad. Processor: 2-core processor/recent macOS Operating system: macOS 11 or newer Memory: 4 GB RAM Hard disk space: 10 GB for Mac Additional system requirements: Internet access, Microsoft account

Install for one device One-time purchase for 1 person Licensed for home and school use Runs on Windows 10 & 11 (PC version only) Turn your data into useful insights using Excel 2021  Excel 2021 for Windows allows you to collaboratively work with others and analyze data with new Excel capabilities, including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions. Excel 2021 for Windows allows you to collaboratively work with others and analyze data with new Excel capabilities, including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions. Improved performance Excel 2021 is the most efficient and stable version of Excel yet, with improved performance on all Windows-based systems. With this new update, you can expect to experience faster operations (calculations, chart generation, etc.) that will allow for a smoother workflow! Visual refresh The new and improved Start experience will help you start your project the right way. With a modernized ribbon, and updated tabs in Excel 2021's tab bar for easier access to tools, complete with all-new Monoline iconography that communicates action with simple visuals! Co-authoring You and your colleagues can open and work on the same Excel workbook through co-authoring. When you co-author, you can see each other's changes quickly — almost immediately. Know who's in your workbook See who else is working on the workbook along with you and where they are in the workbook. Consult and make amends easily. Better collaboration with modern comments Control when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps. XLOOKUP The XLOOKUP function is a game changer in Excel 2021. Row by row, find whatever you need in a table or range with XLOOKUP​. The search term will return results from any column on the same side of your table. Dynamic arrays In Excel 2021, you can write one formula and return an array of values. Expedite calculations and insights with six ​more new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY. This behavior is called “spilling” and can be used in many ways to create complex formulas or get quick answers from one cell! LET function The LET function assigns names to calculation results, allowing storing intermediate calculations, values, or defining names inside a formula only within the scope of the function (LET). Like variables in programming, LET is accomplished through Excel’s native formula syntax. XMATCH function With XMATCH in Excel 2021, you can search for a specified item in an array or range of cells, and it will return the item's relative position. You can also use this function to get the absolute position of one value within another array, which is useful if you're trying to find cells at different intervals! Sheet views Create customized views in an Excel worksheet without disrupting others. This is the best way to co-author and work alone simultaneously. Accessibility Use the new way to reach the Accessibility tools. The Accessibility ribbon puts all the tools you need to create accessible content in one place. Microsoft Search With Microsoft Search, find what you need in Excel 2021 with one click. The new Microsoft Search box is located at the top of your app on Windows, and provides powerful features to help users quickly locate any information they are looking for from text files or commands. New Draw tab Excel 2021 has just made it easier to work with digital ink. With new additions in the Draw tab, you can access all of your tools from one place and quickly change their colors without ever having to open another app! The new Draw tab contains tools like the Point Eraser and Lasso. Support for OpenDocument format New in Excel 2021 is expanded support for the OpenDocument file format (ODF), which supports many new features. This specification was updated with version 1.3 from ODF 1.2 to include even more capabilities than before! Processor: Windows 11 or Windows 10 with 1.6 GHz Operating system: Windows 11 or Windows 10 for PC Memory: 4 GB (64bit), 2 GB (32bit) RAM Hard disk space: 4 GB available disk space Display: 1024 x 768 resolution for PC Graphics: DirectX 10 graphics card for graphics hardware acceleration for PC Additional system requirements: Internet access, Microsoft account

Install for one device One-time purchase for 1 person Licensed for home and school use Runs on latest macOS (Mac version only) Turn your data into useful insights using Excel 2021  Excel 2021 for Mac allows you to collaboratively work with others and analyze data with new Excel capabilities, including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions. Excel 2021 for Mac allows you to collaboratively work with others and analyze data with new Excel capabilities, including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions. Improved performance Excel 2021 is the most efficient and stable version of Excel yet, with improved performance on all Windows-based systems. With this new update, you can expect to experience faster operations (calculations, chart generation, etc.) that will allow for a smoother workflow! Visual refresh The new and improved Start experience will help you start your project the right way. With a modernized ribbon, and updated tabs in Excel 2021's tab bar for easier access to tools, complete with all-new Monoline iconography that communicates action with simple visuals! Co-authoring You and your colleagues can open and work on the same Excel workbook through co-authoring. When you co-author, you can see each other's changes quickly — almost immediately. Know who's in your workbook See who else is working on the workbook along with you and where they are in the workbook. Consult and make amends easily. Better collaboration with modern comments Control when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps. XLOOKUP The XLOOKUP function is a game changer in Excel 2021. Row by row, find whatever you need in a table or range with XLOOKUP​. The search term will return results from any column on the same side of your table. Dynamic arrays In Excel 2021 for Mac, you can write one formula and return an array of values. Expedite calculations and insights with six ​more new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY. This behavior is called “spilling” and can be used in many ways to create complex formulas or get quick answers from one cell! LET function The LET function assigns names to calculation results, allowing storing intermediate calculations, values, or defining names inside a formula only within the scope of the function (LET). Like variables in programming, LET is accomplished through Excel’s native formula syntax. XMATCH function With XMATCH in Excel 2021 for Mac, you can search for a specified item in an array or range of cells, and it will return the item's relative position. You can also use this function to get the absolute position of one value within another array, which is useful if you're trying to find cells at different intervals! Sheet views Create customized views in an Excel worksheet without disrupting others. This is the best way to co-author and work alone simultaneously. Accessibility Use the new way to reach the Accessibility tools. The Accessibility ribbon puts all the tools you need to create accessible content in one place. Microsoft Search With Microsoft Search, find what you need in Excel 2021 for Mac with one click. The new Microsoft Search box is located at the top of your app on Windows, and provides powerful features to help users quickly locate any information they are looking for from text files or commands. New Draw tab Excel 2021 has just made it easier to work with digital ink. With new additions in the Draw tab, you can access all of your tools from one place and quickly change their colors without ever having to open another app! The new Draw tab contains tools like the Point Eraser and Lasso. Support for OpenDocument format New in Excel 2021 is expanded support for the OpenDocument file format (ODF), which supports many new features. This specification was updated with version 1.3 from ODF 1.2 to include even more capabilities than before! Processor: Windows 11 or Windows 10 with 1.6 GHz Operating system: macOS 11 or newer Memory: 4 GB or more Hard disk space: 4 GB available disk space Display: 1024 x 768 resolution  Graphics: DirectX 10 graphics card for graphics hardware acceleration  Additional system requirements: Internet access, Microsoft account

Get work done easier. Work more naturally with new and improved inking features like the roaming pencil case, pressure sensitivity, and tilt effects. Word 2019 gives you new ways to work with documents, like improved digital pen features, book-like page navigation, Learning Tools, and translation. ____________________ Black theme Learning tools (captions and audio descriptions) Speech feature (text-to-speech) Improved inking functionality Accessibility improvements Reading Made Easy Bookmarks. Simple changes in document viewing and reading, frees up more time to do other things. Word now bookmarks the last place you read, so you won’t have to remember where you left off.   Side-by-side viewing. Side-by-side viewing makes it easy to scan and read your document, while the toolbar fades away for more simple, book-like feel. Microsoft eliminated distractions and cleaned up read-mode.  Audio. We don't all read the same way, but now Word provides new ways to build bridges. Sit back and let Word read to you by accessing the audio tool. Don’t know multiple languages?  Translation. Let Word translate text by clicking on the under the Review tab, right next to all familiar revision tools. Improved Design Digital pen. Create attractive documents easily by using the digital pen feature.  Digital inking. Maneuver around the screen to insert signatures, or convert shapes and text with digital inking.The 2019 MS Word offers over sixteen colors and a variety of texture and thickness for pencil, pen, and highlighter. Lasso whole phrases by selecting the eraser. Insert videos/images with SVG. Maybe you’re a teacher or a student who wants to add an interactive experience to their document. You can now insert online videos into your document. Improved SVG capability enhances pictures. Microsoft gives you the options to add excellent visual design. Get all the angles with 3D images. Easily insert a 3D model, and then rotate it a complete 360 degrees. Your readers will be able to rotate it too. More Features  Use LaTeX syntax in your equations. Compose your equations with the latest application, LaTeX. Word now supports LaTeX math syntax to create and edit math equations. Write equations by selecting LaTeX format from the Equations tab. Make it easy to respond to real-time revisions with new modifications to reply comments and markup for revision tools. For text enlargement, simple click twice on your mouse or tap to enable object zoom. Share documents on the cloud with SharePoint or SkyDrive. Available for one-user on PC. Let Microsoft widen the spectrum for persons with disabilities with audio cues and accessibility checks. Processor: 1.6 gigahertz (GHz) or faster, 2-core.  Operating System: Windows 10 or newer, Windows Server 2019 RAM: 4 GB RAM; 2 GB RAM (32-bit) Hard disk: 4.0 GB of available disk space Display: 1280 x 768 screen resolution Graphics: Graphics hardware acceleration requires DirectX 9 or later, with WDDM 2.0 or higher for Windows 10 (or WDDM 1.3 or higher for Windows 10 Fall Creators Update). Skype for Business requires DirectX 9 or later, 128 MB graphics memory, and 32 bits per pixel capable format.

Get work done easier. Work more naturally with new and improved inking features like the roaming pencil case, pressure sensitivity, and tilt effects. ____________________ Black theme Learning tools (captions and audio descriptions) Speech feature (text-to-speech) Improved inking functionality Accessibility improvements Word 2019 for Mac gives you new ways to work with documents, like improved digital pen features, focus mode, Learning Tools, and translation. Here are highlights of what's new since Word 2016 for Mac. Reading Made Easy Bookmarks. Simple changes in document viewing and reading, frees up more time to do other things. Word now bookmarks the last place you read, so you won’t have to remember where you left off.   Side-by-side viewing. Side-by-side viewing makes it easy to scan and read your document, while the toolbar fades away for more simple, book-like feel. Microsoft eliminated distractions and cleaned up read-mode.  Audio. We don't all read the same way, but now Word provides new ways to build bridges. Sit back and let Word read to you by accessing the audio tool. Don’t know multiple languages?  Translation. Let Word translate text by clicking on the under the Review tab, right next to all familiar revision tools. Improved Design Digital pen. Create attractive documents easily by using the digital pen feature.  Digital inking. Maneuver around the screen to insert signatures, or convert shapes and text with digital inking.The 2019 MS Word offers over sixteen colors and a variety of texture and thickness for pencil, pen, and highlighter. Lasso whole phrases by selecting the eraser. Insert videos/images with SVG. Maybe you’re a teacher or a student who wants to add an interactive experience to their document. You can now insert online videos into your document. Improved SVG capability enhances pictures. Microsoft gives you the options to add excellent visual design. Get all the angles with 3D images. Easily insert a 3D model, and then rotate it a complete 360 degrees. Your readers will be able to rotate it too. More Features  Use LaTeX syntax in your equations. Compose your equations with the latest application, LaTeX. Word now supports LaTeX math syntax to create and edit math equations. Write equations by selecting LaTeX format from the Equations tab. Make it easy to respond to real-time revisions with new modifications to reply comments and markup for revision tools. For text enlargement, simple click twice on your mouse or tap to enable object zoom. Share documents on the cloud with SharePoint or SkyDrive. Available for one-user on PC. Let Microsoft widen the spectrum for persons with disabilities with audio cues and accessibility checks. Operating systems supported: macOS 11 or newer Platform supported: macOS Processor: Intel processor. Memory: 4 GB RAM. Storage: 10 GB of available disk space. Display: 1280x800 screen resolution.

Perform better data analysis. Excel 2019 adds powerful new data analysis features, including new formulas, charts, and enhancements to PowerPivot.  If you're upgrading to Excel 2019 for Windows from an earlier Excel version, you'll still have all the features you're used to—and you'll also notice a few new ones! ____________________ Funnel charts, 2D maps, and timelines New Excel functions and connectors Ability to publish Excel to PowerBI PowerPivot enhancements PowerQuery enhancements In Excel 2019 we have significantly improved many of the data transformation features in the Power Query Editor. For example: Splitting columns, inserting custom columns, and adding columns from an example are improved. Plus, merge and append operations, and filtering transforms are enhanced as well. Improved Functions  CONCAT: This function is like CONCATENATE, but better. It’s shorter and easier to type, and also supports range references and cell references.  IFS: Tired of typing complicated, nested IF functions? The IFS function is the solution. With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else "catch all" if none of the conditions are met.  MAXIFS: This function returns the largest number in a range, that meets a single or multiple criteria.  MINIFS: This function is similar to MAXIFS, but it returns the smallest number in a range, that meets a single or multiple criteria. Learn more about MINIFS. SWITCH: This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the "else" is returned. Learn more about SWITCH. TEXTJOIN: This function combines text from multiple ranges, and each item is separated by a delimiter that you specify. Learn more about TEXTJOIN. New charts Map charts: Create a map chart to compare values and show categories across geographical regions in your data, like countries/regions, states, counties or postal codes. Funnel charts: Funnel charts show values across multiple stages in a process. For example, you could use a funnel chart to show the number of sales prospects at each stage in a sales pipeline. Typically, the values decrease gradually, allowing the bars to resemble a funnel. Enhanced visuals  Scalable Vector Graphics (SVG) helps you bring visual interest to your documents, worksheets, and presentations. Convert SVG icons to shapes: Transform all SVG pictures and icons into Office shapes so you can change their color, size, or texture. Insert 3D models to see all the angles: Use 3D to increase your workbooks' visual and creative impact. Easily insert a 3D model, then you can rotate it through 360 degrees. Ink improvements Microsoft introduced Inking features in Office 2016, but are constantly improving, and adding features. In Microsoft Excel 2019, you get: New ink effects: rainbow, galaxy, lava, ocean, gold, silver, and more. Digital Pencil: Write or sketch out ideas with our new pencil texture. Customizable, portable pen set Ink equations Show ink equation pane in PowerPoint Lasso Select at your fingertips Convert ink drawing to shapes Use your Surface pen to select and change objects PivotTable enhancements Excel gives a flexible and powerful analysis experience, through the familiar PivotTable authoring environment. The introduction of Power Power Pivot and the Data Model enhanced Pivots' ability to easily build sophisticated models across your data, augment them with measures and KPIs, and then calculate over millions of rows with high speed. More enhancements include: Personalize the default PivotTable layout    Automatic relationship detection    Creating, editing, and deleting custom measures    Automatic time grouping    PivotChart drill-down buttons    Search in the PivotTable   Smart rename    Multiple usability improvements    Multi-select Slicer Faster OLAP PivotTables! Sharing is easier Insert recent links View and restore changes in workbooks that are shared Quickly save to recent folders General improvements Precision selecting Quick access to superscript and subscript Quick Access Toolbar showing superscript and subscript commands Improved autocomplete New Themes Black Theme Break the language barrier No warnings when saving a CSV file CSV (UTF-8) support Data Loss Protection (DLP) in Excel Operating System: Windows 10 or newer, Windows Server 2019 Processor: 1.6 gigahertz (GHz) or faster 2-core. RAM: 4 GB RAM; 2 GB RAM (32-bit) Hard disk: 4.0 GB of available disk space Display: 1280 x 768 screen resolution Graphics: Graphics hardware acceleration requires DirectX 9 or later, with WDDM 2.0 or higher for Windows 10 (or WDDM 1.3 or higher for Windows 10 Fall Creators Update). Skype for Business requires DirectX 9 or later, 128 MB graphics memory, and 32 bits per pixel capable format.

Perform better data analysis. Excel 2019 adds powerful new data analysis features, including new formulas, charts, and enhancements to PowerPivot. ____________________ Funnel charts, 2D maps, and timelines New Excel functions and connectors Ability to publish Excel to PowerBI PowerPivot enhancements PowerQuery enhancements In Excel 2019 we have significantly improved many of the data transformation features in the Power Query Editor. For example: Splitting columns, inserting custom columns, and adding columns from an example are improved. Plus, merge and append operations, and filtering transforms are enhanced as well. Improved Functions  CONCAT: This function is like CONCATENATE, but better. It’s shorter and easier to type, and also supports range references and cell references.  IFS: Tired of typing complicated, nested IF functions? The IFS function is the solution. With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else "catch all" if none of the conditions are met.  MAXIFS: This function returns the largest number in a range, that meets a single or multiple criteria.  MINIFS: This function is similar to MAXIFS, but it returns the smallest number in a range, that meets a single or multiple criteria. Learn more about MINIFS. SWITCH: This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the "else" is returned. Learn more about SWITCH. TEXTJOIN: This function combines text from multiple ranges, and each item is separated by a delimiter that you specify. Learn more about TEXTJOIN. New charts Map charts: Create a map chart to compare values and show categories across geographical regions in your data, like countries/regions, states, counties or postal codes. Funnel charts: Funnel charts show values across multiple stages in a process. For example, you could use a funnel chart to show the number of sales prospects at each stage in a sales pipeline. Typically, the values decrease gradually, allowing the bars to resemble a funnel. Enhanced visuals  Scalable Vector Graphics (SVG) helps you bring visual interest to your documents, worksheets, and presentations. Convert SVG icons to shapes: Transform all SVG pictures and icons into Office shapes so you can change their color, size, or texture. Insert 3D models to see all the angles: Use 3D to increase the visual and creative impact of your workbooks. Easily insert a 3D model, then you can rotate it through 360 degrees. Ink improvements Microsoft introduced Inking features in Office 2016, but are constantly improving, and adding features. In Microsoft Excel 2019, you get: New ink effects: rainbow, galaxy, lava, ocean, gold, silver, and more. Digital Pencil: Write or sketch out ideas with our new pencil texture. Customizable, portable pen set Ink equations Show ink equation pane in PowerPoint Lasso Select at your fingertips Convert ink drawing to shapes Use your Surface pen to select and change objects PivotTable enhancements Excel gives a flexible and powerful analysis experiences, through the familiar PivotTable authoring environment. The introduction of Power Power Pivot and the Data Model enhanced Pivots bringing the ability to easily build sophisticated models across your data, augment them with measures and KPIs, and then calculate over millions of rows with high speed. More enhancements include: Personalize the default PivotTable layout    Automatic relationship detection    Creating, editing, and deleting custom measures    Automatic time grouping    PivotChart drill-down buttons    Search in the PivotTable   Smart rename    Multiple usability improvements    Multi-select Slicer Faster OLAP PivotTables! Sharing is easier Insert recent links View and restore changes in workbooks that are shared Quickly save to recent folders General improvements Precision selecting Quick access to superscript and subscript Quick Access Toolbar showing superscript and subscript commands Improved autocomplete New Themes Black Theme Break the language barrier No warnings when saving a CSV file CSV (UTF-8) support Data Loss Protection (DLP) in Excel Publish to Power BI If you have a Power BI subscription, you can now publish files that are stored locally to Power BI with EXCEL 2019.  Operating systems supported: macOS 11 or newer Platform supported: macOS Processor: Intel processor. Memory: 4 GB RAM. Storage: 10 GB of available disk space. Display: 1280x800 screen resolution.

Install for one device One-time purchase for 1 person Licensed for home and school use Runs on Windows 10 & 11 (PC version only) Quickly connect and share files with the people and groups that matter most Outlook 2021 for Windows lets you better manage your inbox by adding new capabilities, including Search at Top and Translator. Microsoft Outlook 2021 for Windows: Basic features of Outlook include email service, email search, flagging and color coding, and preview pane options. The calendar function enables scheduling, viewing, and communication about appointments and meetings. Outlook provides 99 gigabytes of archiving data and the ability to set automatic replies. Use Instant Search to find emails quickly Select the search bar (located above the Outlook ribbon) to help find email messages anywhere in Outlook. Translator and ink in Outlook Outlook 2021 allows you to translate email messages into more than 70 languages on the fly and view the transcript. You can also annotate email images or draw on a separate canvas using your finger, pen, or mouse. New in stock media Microsoft is constantly adding more rich media content to the Office Premium Creative Content collection, a curated library of icons, stock images, and more to help you express yourself. Pick the perfect color Microsoft has added a new input field in the Colors dialog for Hex color values. You don’t need to spend time converting Hex color values into RGB values. Just enter a Hex color value in the Hex box, for example, #0F4C81 or 444. Your inbox, your rules Outlook 2021 allows you to set up inboxes for focused and other incoming messages. This lets you separate important mail from personal or junk messages. You can set up custom rules, whitelist email addresses, and make your inbox fit your unique needs. Instant Search Instant searches are fast and easy for finding email messages anywhere within Outlook 2021. Using the new Instant Search to find emails in Outlook 2021 is quick and easy. Just select the search bar from any screen and type away! Processor: Windows 11 or Windows 10 with 1.6 GHz Operating system: Windows 11 or Windows 10 for PC Memory: 4 GB (64bit), 2 GB (32bit) RAM Hard disk space: 4 GB available disk space Display: 1024 x 768 resolution for PC Graphics: DirectX 10 graphics card for graphics hardware acceleration for PC Additional system requirements: Internet access, Microsoft account

Install for one device One-time purchase for 1 person Licensed for home and school use Runs on latest macOS (Mac version only) Quickly connect and share files with the people and groups that matter most Outlook 2021 for Mac comes with new features and a strong arsenal of existing tools. You’ll be able to type up emails, manage your personal and work life, and keep in touch with the people in your life. All from one app. Basic features of Outlook include email service, email search, flagging and color coding, and preview pane options. The calendar function enables scheduling, viewing, and communication about appointments and meetings. Outlook provides 99 gigabytes of archiving data and the ability to set automatic replies. Use Instant Search to find emails quickly Select the search bar (located above the Outlook ribbon) to help find email messages anywhere in Outlook. Translator and ink in Outlook Outlook 2021 allows you to translate email messages into more than 70 languages on the fly and view the transcript. You can also annotate email images or draw on a separate canvas using your finger, pen, or mouse. New in stock media Microsoft is constantly adding more rich media content to the Office Premium Creative Content collection, a curated library of icons, stock images, and more to help you express yourself. Pick the perfect color Microsoft has added a new input field in the Colors dialog for Hex color values. You don’t need to spend time converting Hex color values into RGB values. Just enter a Hex color value in the Hex box, for example, #0F4C81 or 444. Your inbox, your rules Outlook 2021 allows you to set up inboxes for focused and other incoming messages. This lets you separate important mail from personal or junk messages. You can set up custom rules, whitelist email addresses, and make your inbox fit for your own unique needs. Instant Search Instant searches are fast and easy for finding email messages anywhere within Outlook 2021. Using the new Instant Search to find emails in Outlook 2021 is quick and easy. Just select the search bar from any screen and type away! Processor: 2-core processor/recent macOS Operating system: macOS 11 or newer Memory: 4 GB RAM for Mac Hard disk space: 10 GB for Mac Display: 1280 x 800 for Mac Additional system requirements: Internet access and Microsoft account

Install for one device One-time purchase for 1 person Licensed for home and school use Runs on Windows 10 & 11 (PC version only) Customize every chart and presentation layout to create your own, unique style with PowerPoint 2021. PowerPoint 2021 for Mac comes with a host of new features that will enhance your user experience and provide you with all sorts of tools when creating presentations. PowerPoint 2021 for Windows lets you create compelling content with the addition of features including co-authoring, Ink Replay, improved slide show recording, new stock media, and new Draw tab additions such as Point Eraser, Ruler, and Lasso. Improved slideshow recording The new and improved Record Slide Show in PowerPoint 2021 will make it easier to record your presentations. You can use the presenter video recording and ink writing tool with seamless transitions between sections and still pause to take a look at revisions or speaker notes! New stock media With the updated Office stock media library, you can create professional slides with rich media content that will take any presentation from good to great! New Draw tab PowerPoint 2021 for Windows has made it easier to work with digital ink with new additions in the Draw tab, like the Point Eraser and Lasso. You can now access all your tools from one place and change their colors without ever having to open another app!  Ink Replay In PowerPoint 2021, you can replay your ink strokes as they were drawn. This is a great way to illustrate things step by step or show how an idea came about with multiple steps playback.  Enhanced color picker In PowerPoint 2021, there is a new input field for color values in the Colors dialog. No more converting between RGB and HEX formats! You can now define colors on your slides or objects by entering them as their respective HEX codes, such as #0F4C81 (Red) or 444 (Dark Gray). Sketched style outline Sketched style outline is now available in PowerPoint 2021. With this new feature, you can give a casual, hand-drawn look to shapes, and it's easy as pie! Try out the Curved, Freehand, or Scribble options for some unique looks to add interesting visual touches to your presentations. Microsoft Search Find what you need immediately with Microsoft Search in PowerPoint 2021, located at the top of your app on Windows. It helps users quickly locate any information they want from text files. Know who's in your presentation See who else works with you and where they are in the presentation document. Screen-reader compatibility To make your slides compatible with screen readers, place the elements on them in a way that's easy to understand when read out loud. Support for OpenDocument format New in PowerPoint 2021 is expanded support for the OpenDocument file format (ODF), which supports many new features. This specification was updated with version 1.3 from ODF 1.2 to include even more capabilities than before! Link to a slide Ask a colleague to contribute to your slide deck, and start them directly on the slide you need help with. Processor: Windows 11 or Windows 10 with 1.6 GHz Operating system: Windows 11 or Windows 10 for PC Memory: 4 GB (64bit), 2 GB (32bit) RAM Hard disk space: 4 GB available disk space Display: 1024 x 768 resolution for PC Graphics: DirectX 10 graphics card for graphics hardware acceleration for PC Additional system requirements: Internet access, Microsoft account