Return to site

Update Powerpoint 2016 To 2019

broken image


Microsoft started rolling out a new Microsoft Office a few years back which now means that we have three versions at hand. We have Microsoft office 2016, Office 365 and now the brand new Office 2019.

Update

To update Office, follow these steps. The following tables provide the update history for the volume licensed version of Office 2019, as well as the retail versions of Office 2016 C2R and Office 2019, with the most recent release date listed first. New versions contain all the updates. This video is not about a PowerPoint tutorial but we have a very big update from Microsoft. On 24th of this September, Microsoft has officially released thei.

  1. Microsoft Excel 2019. Classic Microsoft Office program that allows users to create and edit.
  2. This article describes update 4461599 for Microsoft PowerPoint 2016 that was released on.
  3. Discover Update Powerpoint 2016 Free why thousands of people have trusted Royal as their one-stop software shop. Rack up rewards points to save extra on Update Powerpoint 2016 Free purchases. Experience the best Update Powerpoint 2016 Free customer support in the business. We believe in making a difference for our Update Powerpoint 2016 Free members.

Powerpoint Free Download

If you have been thinking of upgrading from Microsoft Office 2016 to 2019, there are a few things you should know. Most of the people have a hard time noticing any changes and even comparing the two versions.

In this article, I will take some time comparing the two versions to give you a clearer picture of the two.

Office 2016 is the killer version that most of the people went for some time back. It has all the features that people and businesses have been looking for. It was developed with the sole purpose of enhancing collaboration. However, one thing that you should know is that this feature is not fully baked. They are facing some challenges when collaborating with Google's own productivity.

With Office 2016, all the applications can tell you and your users how to tackle a certain problem. The Office has the new feature ‘'Tell me'' which assists people to do what they want to do. When Office 2016 and Office 365 were released, they both had some similarities in terms of features and functions.

However, with Office 2019, there are several key features that are missing. Some of these features can only be available via office 365 subscription.

If you want the best in terms of features and functions, you should go and download Office 2016 or Office 365. However, office 2019 has also come with some features that are specifically targeting specific applications.

With Microsoft word, some features are available, such as:

  • Black Theme
  • Learning Tools
  • Text to Speech Feature
  • Accessibility Improvement
  • Improved Inking

It is the same case with Ms Excel where some of the features such as Funnel charts, timelines and 2D maps were among the new features. Some other features include, ability to publish excel to PowerBI, powerQuery enhancements and PowerPivot enhancements.

Several other features exist with other applications such as Publisher and PowerPoint. However, most of the people are not even willing to upgrade. The main reason why most of the people and businesses are not turning to Office 2019 is because the prior Office versions including Office 2016 and Office 365 have more features and hence they are usually a better deal.

How Does Microsoft Office 2019 Compare to Office 2016?

Although we have talked about the other side of Microsoft Office 2019, there are some of the new features it has incorporated.

Some of them include:

  • Improved inking in all the apps
  • New chart types in Excel
  • Focused inbox in Outlook
  • Focus mode in Word
  • Better integration with the newer Ms servers and services

Most of the businesses that are willing to upgrade are those that are specifically using those services.

Differences Office 2016 2019

However, for small businesses or individuals, I have to say that there's nothing appealing in that. What am trying to mean is that if you have already downloaded Office 2016 and its working well for you, there's little reasons to upgrade.

Powerpoint Download

Read Also!

You probably arrived at this page because you are a business professional who has to present regularly to management or executives on analysis you have done in Excel. You don't want to have to retype a table of numbers or recreate a graph in PowerPoint. Not only is that time you don't have, but it could lead to errors, which would be embarrassing. So you want to link the table or graph in Excel to your PowerPoint slide. Then when the numbers change next week or month, the PowerPoint slide can automatically update. (If your chart needs to use different data each month or quarter, consider creating a chart with dynamic ranges using the method in this article).

It sounds like a great plan. Except every great idea does have potential downsides you need to know about. Here's what you need to consider before deciding to link a table or graph from Excel to PowerPoint:

How To Update Powerpoint 2016 To 2019

  • Might the boss ask for a last minute update because new numbers are available? If so, your link may cause you problems. If you don't have access to the source Excel file, because you are off-site or don't have a secure connection back to the server, you can't update the numbers for the boss.
  • Will others need to make updates to the table or graph in PowerPoint? If so, they may get frustrated when they get an error message that the source file is not accessible. Linked data requires access to the source file to make changes and if they don't have security permission to the file location, they are out of luck.
  • Does your organization care about branding? Most do, and they have a specific standard for the look of slides, including colors, fonts, etc. If you link an Excel graph, it won't likely match that formatting, because it will use the default Microsoft Excel look. Now the presentation isn't consistent with brand standards. (Unless you brand your Excel file with the colors from the PowerPoint template as shown in this article and video)
  • Do you want the update of the table or graph to happen automatically? That is not possible. Linked tables or graphs need manual intervention to be updated. Some methods will pop up a Security warning message when the PowerPoint file is opened. If someone isn't scared that you have just given them a virus, they will read that clicking on the appropriate button in the dialog box will update the data. Other linking methods require a click on an update button for every table or graph. And if your file has a combination of these methods, you have to remember which is which for each slide.
  • Does the source Excel file change regularly? If many people can update the file, you may experience the data in your presentation changing unexpectedly when you update the links. If the file name changes each week or month, the data never gets updated since the links point to the original file name.

If you still want to link the graph from Excel to the slide in PowerPoint, scroll down to see how to do it.

If you don't use linking, how can you easily update the graph in a presentation each time without a lot of extra work? I suggest you consider creating the graph in PowerPoint with data copied from Excel. Set up the data required for the graph in a set of Excel cells. When you create the graph in PowerPoint, use Paste Special – Values to copy the data from Excel. You can format your graph in PowerPoint and it will be compliant with your organization's branding standards. Because the data is in the PowerPoint file, you (or others) can update it at the last minute if needed. Watch this video to see how easy it is.

When using this method, how can you make sure the latest data is used for the graph? By using a consistent procedure that includes documentation. Follow the same procedure each month for copying the cells from the current version of the Excel file to the data table for the graph on the appropriate slides. Then, update either a text box on the slide or the Slide Notes with the date and time of the update and the file name the data came from. That way, you, or anyone else, will know where the data came from and when it was last updated.

If you are presenting financial information, this page gives practical advice to make an effective visual presentation. If you are part of a team who presents financial or operational information to management and executives, my customized training delivers immediate ROI. If you have to communicate the results of analysis often, you can learn about many more ways to use Excel tables and graphs in PowerPoint with my ecourse After the Analysis: Communicating results from Excel in PowerPoint.

If you want to link a graph from Excel to the PowerPoint slide, here are two methods to do it. I will describe each method, and then show a table that summarizes the differences. I'll end with some recommendations of when each method should be used.

Each method starts with you creating the graph in Excel first, because we will be copying the graph created in Excel into the PowerPoint slide.

Method 1: Basic Paste

After you have created the graph in Excel, click on it and copy it (press Ctrl+C or click the copy button on the Home ribbon). Switch to your PowerPoint slide. Paste the graph on the slide by pressing Ctrl+V or clicking the Paste button on the Home ribbon. You can now edit the graph using the PowerPoint graph tools in the Graph ribbons (there are three ribbons on PowerPoint 2007 & 2010 and two ribbons in PowerPoint 2013 & 2016).

Method 2: Paste Link

When using this method, after you create the graph in Excel, you must format it exactly how you want it to appear on your slide since you cannot format it in PowerPoint. Set all legends, labels, axes, gridlines, and other settings for the graph. When it is formatted, copy the graph. Switch to your PowerPoint slide. Click on the arrow below the Paste button on the Home ribbon and click on Paste Special. In the Paste Special dialog box, click the Paste link radio button, select Excel Worksheet Object in the list and click the OK button. The graph is now a drawing object in PowerPoint that can be moved and proportionally size, but not edited.

Here is a video that demonstrates these two methods.

Comparing the two methods

Basic Paste methodPaste Link method
Graph must be fully formatted in Excel before copying to PowerPoint?NoYes
Graph is inserted on the PowerPoint slide asGraph objectDrawing object
Can format the graph in PowerPointYesNo
Can resize the graph in PowerPointYes, all directionsYes, only proportionally
Can animate the graph in PowerPointYesNo
Notified of the linked file when the PowerPoint file is openedNoYes, via a Security Warning dialog box
Method of data updateUser must click on Refresh Data button on Graph Design ribbonUser can click button in Security Warning dialog box displayed when PowerPoint file is opened
Access to full worksheet in Excel (all tabs and data)Via Edit Data button on the Graph Design ribbon in PowerPointDouble click on drawing object on PowerPoint slide
Access to data if source file not available (ie. if PowerPoint file emailed to others)NoNo

Recommendations

In most situations, the Basic Paste method will work well. It allows you to format and animate the graph in PowerPoint, giving you better control of how you present the graph. The disadvantage is that you must remember to manually click the Refresh Data button to get the latest updated data for the graph. If you need the updates to be more automatic and don't need the formatting or animation in PowerPoint, the Paste Link method would be a good choice because it allows for updating the data when the PowerPoint file is opened. The disadvantage is that the PowerPoint file opens with a Security Warning dialog box, which can be unsettling for others who receive the file by email. Video sound changer online.

With both methods, you must be careful of who has access to the source Excel file from the PowerPoint slide. Anyone who can access the Excel file can see all the tabs and data, including any confidential information. If this could be a concern, I suggest you create an Excel file that contains only the data for the graph and the graph itself, leaving the bulk of the data in another Excel file that isn't linked to the PowerPoint file. Alternatively, you can break the links to the source Excel file before you send the file to others. In PowerPoint 2010 and above, in the Info section of the File ribbon, there is a button to Edit Links to Files. You can select the links and click the button to break the links. This disables any future updating of the data, but protects your data from being seen by others.

Want an in-depth e-course on using Excel data in PowerPoint? Check out my After the Analysis: Communicating results from Excel in PowerPoint e-course

Dave Paradi has over twenty years of experience delivering customized training workshops to help business professionals improve their presentations. He has written nine books and over 100 articles on the topic of effective presentations and his ideas have appeared in publications around the world. His focus is on helping corporate professionals visually communicate the messages in their data so they don't overwhelm and confuse executives. Dave is one of less than ten people in North America recognized by Microsoft with the Most Valuable Professional Award for his contributions to the Excel and PowerPoint communities. Program to open rar and zip files. He regularly presents highly rated sessions at national and regional conferences of financial professionals.





broken image