понедельник, 16 января 2017 г.

About Microsoft Excel 2016



Microsoft Excel 2016 is definitely the latest version of the spreadsheet a part of Microsoft Office 2016, a whole new productivity software suite released by Microsoft.

Microsoft includes advance features and tools like power query integration, read-only mode for Excel, keyboard access for pivot tables and slicers in Excel, new chart types, quick data linking in Visio, Excel forecasting functions, support for multi-selection of slicer items using touch, time grouping and pivot chart drill down and also Excel data cards.

You can now also import data online basic and fast, unlike before a user want to do it manually (by copying and pasting all data and reformat everything around the file).

Here tips will assist you on

How you can import web data into Microsoft Excel 2016:

Copy the link of your internet browser containing the information you intend to import.

Open the MS Excel and click on your data tab.

Select the New Query button and select off their Source.

Click From Web

Paste the cause link on the "Access Web content" window.

Select the OK button and select how you intend to access your data.

office 2016 key pas cher

Click connect

The "Navigator" window can look just after. It can load the details from the web page.

Go through the table you wish to import.

Click Edit. MS Excel will automatically fetch the details.

Go through the Close & Load button when you are delighted by the information.

After importing the data obtained online, MS Excel will automatically save the original source link into the file. You can right-click the table and then click Refresh. When the data on-line is different, the table on Excel will probably be updating also.

Microsoft Excel Shortcut Keys:

SHIFT F11

If you need to enter a new Excel worksheet, simply contain the SHIFT key F11. You will recognize that a new worksheet continues to be added left. Then you can begin working in the new sheet you created.

CTRL Grave accent key (`)

To demonstrate all the formulas you designed to automatically perform computation on selected cells, hold down CTRL and click the grave accent key (`), which you may find about the left of the leading key and also over the TAB key.

CTRL and CTRL 9

when you simply must put certain column(s) out from the sight of your associates. Rather than intending to "Format" then "Hide Columns," just press along the CTRL key and strike (zero). To cover rows, retain the CTRL key thus hitting 9.

ALT =

To provide up cells automatically, there is no need to attend where the "AutoSum" key is positioned. Find the cells that you have to compute then press ALT followed by the equal sign (=) and the next cell will show the overall.

Комментариев нет:

Отправить комментарий