This tutorial shows a couple ways to make dynamic charts in Excel 2016 for Mac and for all Windows and Mac versions of Excel. Bottom line: There are several ways to make dynamic charts in Excel, and there seems to be no difference other than cosmetic in how they work between different versions.

In this video we show you How to Create a Web Query in Excel 2016 to Get Current Data To make an online web page question in Excel 2016, you click on the From web command button on the data tab of the Ribbon or press Alt+AFW. Excel then opens the brand new net query dialog box containing the home web page for your pc's default internet browser (internet Explorer 10 normally). To select the online page containing the information you want to import into Excel, that you may: form the URL internet deal with in the deal with text box on the prime of the dwelling page in the New internet question dialog box. Use the search feature offered on the residence web page or its hyperlinks to search out the net web page containing the info you desire to import. When you have the online web page containing the data you want to import displayed within the New net query dialog box, Excel shows which tables of expertise you could import from the web page into the worksheet by using adding a yellow box with an arrowhead pointing proper. To import these tables, you conveniently click on this box to add a examine mark to it.

Choosing the table of information to import on the Yahoo! Finance internet page. After you conclude checking the entire tables you want to import on the web page, click on the Import button to close the new internet query dialog box.

Want to get more out of Excel? At Microsoft's inaugural last month, several experts offered a slew of suggestions for getting the most out of Excel 2016. Here are 10 of the best. (Note: Keyboard shortcuts will work for the 2016 versions of Excel, including Mac; those were the versions tested.

And many of the query options in Excel 2016's data tab come from the Power Query add-in for Excel 2010 and 2013. So if you've got Power Query on an earlier version of Excel on Windows, a lot of these tips will work for you as well, although they may not work on Excel for Mac.) 1. Use a shortcut to create a table Tables are among the most useful features in Excel for data that is in contiguous columns and rows. Tables make it easier to sort, filter and visualize, as well as add new rows that maintain the same formatting as the rows above them. In addition, if you make charts from your data, using a table means the chart will automatically update if you add new rows. If you've been creating tables from your data by going to the Excel ribbon, clicking Insert and then Table, there's an easy keyboard shortcut: After first selecting all your data with Ctrl-A (command-shift-spacebar for Mac), turn it into a table with Ctrl-T (command-T on Mac). Bonus tip: Make sure to rename your table to something related to your specific data, instead of leaving the default titles Table1 or Table2.

Chrisgust, Good length of battery The battery lasts for a long time and it tells you when the battery is getting low on a MacBook Pro in the top right hand corner of your screen. This app makes my life a lot easier and I would definetly support the battery health because it has many great features. App battery check for mac.