Yawn-proof software training

3 New Features in Excel 2016

Microsoft has a few new features in the works for Excel 2016, from business insight and analysis tools, to new eye-catching, page popping charts.  Here are three features to get excited about.   

1. "Tell me" -- Granted, this feature is available in every application included in Office 2016, I mention it here as Excel is the program I know I will use it the most! Instead of searching the ribbon and tabs for a specific feature, enter your search in the "Tell Me" bar for quick access.

Tell Me

2. Power Query -- Previously available only as an add-in for Excel (2010, 2013), Power Query in now fully integrated with Excel and can be found under the "Data" tab in the ribbon. Power Query is a data analysis too that allows users to retrieve, combine, and review data from sources on your local computer, or from external sources like Wikipedia.  

Power Query

3. New Chart Formats -- The  2016 edition of Excel now includes new chart styles developed specifically for showcasing financial, statistical and hierarchical in highly visual ways.  New charts include:

     
Waterfall
Waterfall
Histogram
Histogram
Box & Whisker
Box and Whisker
Treemap
Treemap
Sunburst
Sunburst
 

 

From now until this end of this year, you can download your own trial version of Microsoft Office 2016.  PC and Mac versions are available, though not all features are available in both. 

3 New Features in Outlook 2016
5 Changes to Get Excited About in Office 2016

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Thursday, 13 December 2018

Captcha Image

Book

How To Choose a Software Trainer They'll Thank You For

Survey says: "Sitting through software training is painful".

Knowing how to use MS Office and knowing how to train people to use it are two different things. Download this Special Report and discover how to choose a trainer that leaves your employees feeling useful.

  • Claire Langfield, Executive Assistant

    Chippewas of Rama First Nation

    The majority of my computer training focused on Publisher. I have received positive comments and feedback from several of my colleagues on the changes between my first attempt and current expertise creating the monthly internal newsletter for my department. They enjoy the updated format and the way in which the information is presented. 

    Deborah assisted me through a learning curve, as I had not previously had any exposure to this program prior to joining Rama. She also provided me with a refresher course on PowerPoint and Excel.  Deborah is a patient teacher and tailored the training to suit my job requirements.