After a long, long wait, the 2016 version of Microsoft Excel has finally arrived on. Like the latest version of, Excel is available now to Microsoft Office 365 subscribers and will be coming later this month as a one-time purchase. The latest version of the popular spreadsheet application delivers a long list of new features including support for Retina Display, a streamlined user interface, full-screen view, and multitouch gestures. But that's only scratching the surface of what individual components like Excel 2016 have to offer, which is why we've compiled this gallery of six ways to improve your spreadsheet experience while learning a few tricks at the same time. Prev Page 1 of 7 Next Prev Page 1 of 7 Next Windows keyboard shortcuts. Browser download for mac os x 10.7.5 lion 10. The dual-platform nature of Office 365 means some users will be required to jump between Windows (for work) and Mac (for home) — an experience that has been quite exasperating over the years when it comes to keyboard shortcuts.

Windows 8.1 drivers for mac windows 10. The good news is Excel 2016 has brought some sanity to this dilemma at long last, with many shortcuts that require the Windows CTRL modifier key now working the same way on the Mac. Most common functions like cut, copy, paste, undo, redo, and save also retain the equivalent Command key shortcut as well. Microsoft has a full list of Excel 2016 keyboard shortcuts on its, should you need a refresher. Prev Page 2 of 7 Next Prev Page 2 of 7 Next Formula Builder to the rescue.

Those who use Excel day in and day out certainly don't need hand-holding when it comes to crunching numbers. For the rest of us, Excel 2016 introduces Formula Builder, a new feature that helps novice users overcome daring financial acrobatics with the greatest of ease. A click on Shift-F3 calls up this handy option, which offers the complete range of formulas, along with the kind of hand-holding novices need to overcome their unnatural fear of mathematical computations.

Prev Page 3 of 7 Next Prev Page 3 of 7 Next Charts made simple. Converting a spreadsheet to a chart hasn't always been the most simple or intuitive task, even in an application as powerful as Excel. That's why Microsoft added a new Recommended Charts feature to Excel 2016, which assists in the process by offering suggestions for a chart based upon the data selected in the worksheet. To use it, click the Insert option on the Ribbon, highlight the data to be included, and click the Recommended Charts button; a drop-down menu serves up one or more samples of the chart Excel will create for you in just a click. From there, the chart is added to the spreadsheet for the user to do as they wish with it. Prev Page 4 of 7 Next Prev Page 4 of 7 Next Slice those PivotTables. We're not hardcore number crunchers that use PivotTables on a daily basis, but if we were, we'd probably be dancing on the ceiling over Excel 2016's new slicer tool.