Top 10 Excel Functions For 2019
If you have been patiently, or impatiently, waiting for the next release of Microsoft Excel, then you are in luck! The next version of the highly prized and most popular spreadsheet program in existence is here. It was released September 24, 2018. Some of you may already be experts on all of the new functionality included in this release. For those of you that are just now upgrading or will be upgrading in the near future, here is a rundown of some of the new functionality that you can look forward to in this release
1. Office Add-Ins
Add-Ins are now called apps and they are available directly from Excel. You can click a button inside the program to go to the store and download new bits of functionality that help you build stronger spreadsheets. Some of the new apps include maps, dictionaries, thesauruses, and date pickers.
2. File Sharing
The new Share button on the right side of the command ribbon allows you to automatically save your spreadsheet to your cloud OneDrive and invite people to view or collaborate on your spreadsheet with you. You can also present it directly through a Skype session or post it on your company’s internal social media site.
3. Cloud File Support
You can now save your files directly to your company cloud OneDrive or SharePoint site. You also get version control with this feature if you need to revert to a prior version. Autosave also kicks in after you save your file to a cloud location.
4. Touchscreen Support
Your tablet and smartphone can now be used to view and edit Excel. The ribbon has been redesigned to make it easier for you to fire the commands. Also, the overall experience without a physical keyboard and mouse has been revamped to make it easier to work with spreadsheets on mobile devices.
5. Data Visualization Help
Have you ever struggled to pick the correct chart or graph to represent your data? Insights are now included to help you analyze your data and pick the right type of visualizations that would best communicate your results to the viewer.
6. Reporting Visualizations
Microsoft has spent loads of R&D on new data visualizations for Power BI (Microsoft’s new reporting tool in O365) and Excel is the beneficiary of that research. It has new charts, maps, and graphs that are easier to include in your worksheets than ever before.
7. Integrated Data
Excel includes a new data table relationship modeler for data tables that you import into your worksheets. You can now define true one to one, one to many, and many to many relationships between your data tables and maintain their referential integrity.
8. wwwPivot Table Decisions
If you’re new to creating pivot tables, Excel includes a wizard to help you add and transform your data into pivot tables. It has never been easier to create powerful data analysis tools.
9. The Quick Analysis Tool
This tool appears in the lower right-hand corner of your data tables in an Excel 2019 worksheet. It can help you to quickly add functionality to your table such as summing and averaging columns, creating pivot tables, conditional formatting, or even adding sparklines to the table.
10. New Data Functions
Several new convenient data functions have been added to make working with your data easier. Some examples are UNIQUE, FILTER, SEQUENCE, and RANDARRAY. Just Google each one for an explanation of what they do and how to use them in your worksheets.
These are just a few of the exciting new features included in Excel 2019. If you really want to become an Excel wizard, there is no better way than obtaining formal training from a reputable online training company such as ONLC. Why not contact them today to see how you can maximize the use of all the new functionality included in Excel 2019?