|
If you never want to watch or create a lifeless, boring, presentation again, check out these easy to use features. If your slides have bullet list after bullet list, think “smarter”. Break the old habits and try using SmartArt and some Animation. Tip 1: Only display on the screen what you are talking about at that moment. If you show all the data at once, the audience will be way ahead of you. To avoid this, use Animation. Select the object (bullet list or graphically objects), go to the Animations tab. If it is text, bring in one paragraph at a time by using Effect Options. Tip 2: Have numbers to present? Create a Chart but don’t show the whole Chart at once. Use Animation to display 1 series or category at time. Focus attention on smaller amounts of data, then bring in more as needed. Select the Chart, go to the Animations tab use Fly In, then change the Effect Options to By Series or By Category. Tip 3: Sometimes a bullet or numbered list is appropriate, but you can mix it up by turning some into SmartArt. If you have a slide with existing bulleted items. Select the text box, from the Home tab go to the Paragraph group and click on Convert to SmartArt. It can change the lists to graphic objects. Then you can apply Animation to the objects to bring them in one at a time. Don’t go crazy on too many things on each slide, less is more when it comes to formatting, animation, transitions, etc. A little bit can do a long way. Want to learn more tricks and tips on making your next presentation a hit with the audience? We have training for all levels and custom classes are also an option. Give us a call, we can help! 
0 Comments
If you’ve ever seen the squiggly red line under a word and chosen the “Add to Dictionary”? That is the custom dictionary in Microsoft Office. All of those words are stored in a custom dictionary file on your computer’s hard drive. If you add a word to the dictionary but need to edit or remove it, you can. Also you can transfer the custom Office dictionary from one computer to another. To access the Custom Dictionary: In Word , go to File, Options, and then in the Proofing section you’ll see “Custom Dictionaries. Once in the Dictionary you can click on Edit Word List or view the path of where it is saved at on your computer.  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:
  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.
 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 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 |