A Comparison of Excel 2013 Compared to Excel 2019 to ...



A Comparison of Excel 2013 Compared to Excel 2019 to Office 365Highland is upgrading from Office 2013 to Office 2019. Many staff and students have taken advantage of the free Office 365 for teachers and students. Below is a chart comparing the current version used on campus (2013) with the version we are updating to and Excel 2013Excel 2019Excel in Office 365IFNew Functions – CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and TEXTJOIN. New Functions – CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and TEXTJOIN. Limited to Column, Line, Pie, Bar, Area X Y (Scatter), Stock, Surface, Radar, and Combo. New charts – Map charts and funnel charts New charts – Map charts and funnel charts Limited photo files with 2DEnhanced visuals - Scalable Vector Graphics (SVG), Convert SVG icons to shapes, and Insert 3D models to see all the angles. Enhanced visuals - Scalable Vector Graphics (SVG), Convert SVG icons to shapes, and Insert 3D models to see all the angles. Limited ink and drawing ability Ink Improvements – New ink effects, digital pencil, portable pen set, ink equations, ink replay button, lasso select, convert ink drawing to shapes, and use Surface pen. Ink Improvements – New ink effects, digital pencil, portable pen set, ink equations, ink replay button, lasso select, convert ink drawing to shapes, and use Surface pen. Less accessible Better accessibility features – One-click fixes for accessibility issues and helpful sounds improve accessibility. Better accessibility features – One-click fixes for accessibility issues and helpful sounds improve accessibility. Limited sharingSharing is easier – Insert recent links, view and restore changes in workbooks that are shared, and quickly save to recent folders. Sharing is easier – Insert recent links, view and restore changes in workbooks that are shared, and quickly save to recent folders. Less options General improvements – Precision selecting, quick access to superscript and subscript, improved autocomplete, new themes, black theme, break the language barrier, no warnings when saving a CSV file, CSV (UTF-8) support, and Data Loss Protection (DLP) in Excel. General improvements – Precision selecting, quick access to superscript and subscript, improved autocomplete, new themes, black theme, break the language barrier, no warnings when saving a CSV file, CSV (UTF-8) support, and Data Loss Protection (DLP) in Excel. Less optionsPivotTable Enhancements and Power Pivot updates PivotTable Enhancements and Power Pivot updates Not available Publish to Power BIPublish to Power BILess optionsGet & Transform (Power Query) – New and improved connectors, improved transformations, and general improvements.Get & Transform (Power Query) – New and improved connectors, improved transformations, and general improvements.Contact Academic Technology Resources, instructionaltech@highland.edu, x3411, if you have additional questions. Resources: Excel with earlier versions of ExcelExcel for Office 365?Excel 2019?Excel 2016?Excel 2013?Excel 2010?Excel 2007?More...After you have installed a new version of Excel, you may want to know how you can continue to work with workbooks that are created in an earlier version of Excel, how you can keep these workbooks accessible for users who do not have the current version of Excel installed, and how the differences between the versions affect the way that you work.For backward compatibility with earlier versions of Excel, such as Excel 97-2003, you can use one of several ways to exchange workbooks between the different versions. in Office 365Excel 2013Efficient filesWith XML-based file formats, documents are smaller, more robust, and integrate with more information systems and external data systems.XXExcel Data ModelTap into powerful analysis features that were previously available only by installing the Power Pivot add-in.XXOne-click forecastingCreate forecast charts based on existing data and predict future trends with a simple click.XNew mapping featuresTransform geographic data into professional-looking visualizations in just a few steps.XRecommended ChartsExcel recommends the best ways to present your data based on the context and recent work patterns. New bars, colors and icons help to highlight trends.XAlways up to dateAlways have the latest Office apps, features, and services.XReference: ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download