|
There are new chart types in Excel 2016, including Waterfall, Sunburst, Tree map, Funnel, Histogram, Pareto, and Box and Whisker. They can be used from programs like, Excel, Outlook, PowerPoint, and Word. Here are a few details:
0 Comments
 Here's how - there is a new feature in Excel 2013/2016 called Quick Analysis. Simply select a range of cells then click the icon that appears at the bottom right corner to reveal options like creating a quick formula, table, chart and more. This is one of the many new features in Excel - others include major enhancements to Charts, new Formulas, Flash Fill and more.
The Microsoft Excel SUMIFS function lets you specify multiple IF conditions within one formula and add together cells based on the conditions. It can be used to evaluate if multiple conditions are true do this, but if they are false do this. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value. Syntax: SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) Sum Range is the range of cells you want to add together. The criteria range is the range(s) you want to evaluate with the criteria being the condition.   Excel, Outlook, PowerPoint, Word 2016 all have a new option on the Insert tab of the Ribbon – Icons. Once you open the Icons window, click on a category from the left-hand side. Once you find the Icon you want to use click Insert. You will have a Graphic Tools tab on the Ribbon with additional options for formatting the Icon. To learn more about this feature or other new Office 2016 options, attend one of our classes.
 Excel has built-in lists of data that you can enter by using the fill handle. When you hesitate your mouse on the bottom right corner of the active cell, you will see a black t, this is the fill handle. The custom lists included with Excel are; days of the week, months and quarters. You can also use these custom lists to sort data and you can create your own custom lists. Here is an example of how to enter data from a custom list: Type in Monday then use the fill handle to drag down or across cells. As you move across cells it will fill in Tuesday, Wednesday, Thursday, Friday, etc. as you continue dragging. You can also use the auto fill to enter a list of numbers. If you want to create a numbered list you need to enter the first 2 numbers, select the 2 cells then use the fill handle to click and drag.
New Feature - Jan 2018 Precision Selecting
Have you ever selected too many cells or the wrong ones? You can deselect any cells within the selected range with the Deselect Tool. Pressing the Ctrl key, you can click, or click-and-drag to deselect any cells or ranges within a selection. If you need to reselect any of those cells, continue holding the Ctrl key and reselect those cells. |
Computer tips that will increase productivity and your overall computer experience.
AuthorWith over 25 years in the computer industry, JoLynn Rihn has been helping people to become more efficient and effective with their computer software. She offers tips on using the latest programs so that using a computer can be more easy and fun to use. Archives
December 2018
Categories |
RSS Feed
|
Virtual Training Co (608) 769-4203
Professional Development Live Instructor-led |