Excel

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.