Microsoft Excel 2016

       Microsoft ExcelIt is an independent version launched by Microsoft and included in Microsoft office.officesoftware. Excel 2016 asMicrosoftIt is a member of its Office series of office software. Its best area is the processing of batch data. The software is generally based ontableIt operates in the form and contains many richfunctionFunction, it is a software that is easy to use, but after in-depth understanding, you will find hidden secrets. Huajun Software Park provides free full version download of Excel 2016! The Microsoft Excel 2016 installation package will be downloaded through the Microsoft official authorized product Office Assistant (software size: 4.62MB), please feel free to use it.

Excel 2016 Highlights

‌Operation interface‌:

The operating interface of Excel 2016 is roughly similar to the operating interface of other components of Office 2016. It consists of the quick access toolbar, title bar, "File" menu, function tabs, ribbon, edit bar, and worksheet editing area.

Users can easily find commands and functions that were previously hidden in complex menus and toolbars through various command buttons in the ribbon.

‌View Mode‌:

Excel 2016 provides three view modes: normal view, page layout view, and paging preview view. Users can switch between different views as needed to adapt to different work needs.

Excel 2016 usage tips

How to filter duplicates in Exceldata?

1. Double-click to open the Excel file you want to process. After opening, select the data area you want to process, then click the menu "Start", then select "Conditional Formatting", click "Highlight Cell Rules" in the pop-up drop-down menu, and next select the "Duplicate Values" option.

2. Then in the Repeat option box, confirm that the repeated values ​​are highlighted in Excel's default format, and then you can choose the color yourself. After selecting, click the [OK] button.

3. After clicking OK, the duplicate Excel cells will be displayed in pink.

4. Select the title row of the Excel data table, click "Start" on the menu bar after selecting it, then select "Sort and Filter" and select "Filter" in the pop-up drop-down menu. If there is no header row, please insert a row at the front and select the empty row as the filter row.

5. In the data column that needs to be filtered, click the downward triangle, select "Filter by color" in the filter box that appears, and then select "Pink".

How to easily wrap lines in cells in Excel?

Method one:

Find the cell with a new line, double-click the cell, make sure the mouse cursor is stopped in the cell, and hold down ALT+Enter (Enter key) to change the line.

Method two:

1. Find any blank cell, right-click the mouse and click "Format Cells" in the pop-up options.

2. Then in the settings page that pops up to set cell format, click the Alignment tab above, check "Automatically wrap" in the text control options, and click [OK] after completing the selection. Other options can be modified by yourself, and I will not introduce them again.

3. Then when we enter text in this blank cell, it will automatically wrap.

If you need more ways to use Excel, please follow the WeChat official account of "Little Doctor Office Software" to get more tips on using Excel.

Excel 2016 function introduction

‌Spreadsheet Processing‌:

Excel 2016 provides a large number of blank worksheets. Each worksheet is composed of rows and columns intersecting cells for storing and editing data.

Supports various formatting settings for cells, such as font, size, color, alignment, etc., as well as advanced functions such as data validation and conditional formatting.

‌Data Analysis‌:

It provides a wealth of built-in functions, covering finance, date and time, mathematics and trigonometric functions, statistics and other fields, to facilitate users to perform complex data calculations and analysis.

It supports data operations such as sorting, filtering, classification and summarization, as well as advanced analysis tools such as pivot tables and pivot charts to help users deeply explore the value of data.

‌Chart making‌:

A variety of chart types are provided, including column charts, pie charts, bar charts, area charts, line charts, etc., as well as new advanced charts such as tree charts, sunburst charts, and waterfall charts.

Users can create charts according to their needs, edit and interact with them to make the data more intuitive and understandable.

New chart type‌:

Excel 2016 adds a variety of new chart types, such as tree charts, sunburst charts, waterfall charts, etc. These charts can more intuitively display complex relationships between data.

‌Power Query Tools‌:

The Data tab adds Power Query tools, allowing users to find and connect data across multiple sources, import data from multiple log files, etc., improving the efficiency of data processing.

‌Prediction Function‌:

Excel 2016 has added prediction functions and prediction functions to predict future data development trends based on current data information to provide support for users' decision-making.

Excel 2016 installation method

1. Download the Excel 2016 installation package from Huajun Software Park. Since Excel is one of the Office series office software, we need to install Office before it can be used. We first run the downloaded Office Assistant program.

2. Here the user needs to purchase an Office activation code. After obtaining the activation code and inputting it, Office will start to install, and then wait for the Office 2016 installation to be completed. If an error is reported midway, it may be that the previous Office software on the computer has not been uninstalled cleanly. You need to uninstall it first and then reinstall it.

Excel 2016 shortcut keys

Ctrl+W closes the page under the current program, Alt+F4 directly closes the Excel program.

Ctrl+F5 restores the size of the selected workbook window.

F6 switches to the next pane in the worksheet that is split (Split command on the Window menu).

Shift+F6 switches to the previous pane in the split worksheet.

Ctrl+F6 switches to the next workbook window when multiple workbook windows are open.

Ctrl+Shift+F6 or Ctrl+W switches to the previous workbook window.

Ctrl+F9 minimizes the workbook window to an icon.

Ctrl+F10 restores the selected workbook window.

F6 moves from other panes of the program window to the task pane. You may need to press F6 multiple times.

(Note: If pressing F6 does not display the task pane you want, press Alt to activate the menu bar, and then press Ctrl+Tab to move to the task pane.)

Ctrl+Tab Move to the task pane when a menu or toolbar is active. You may need to press Ctrl+Tab multiple times.

Tab or Shift+Tab Select the previous or next option from a task pane when it is active

The difference between Excel 2016 and Excel 2013

2. Several new graphics have been added to Excel 2016.

3. The VBE object model loaded in Excel 2016 has been updated and no installation is required.

The above is the summary of Huajun editor. If you like Excel 2013, Huajun Software Park also provides downloads! !

To download Excel 2013 please click:http://softwaredownload4.com/soft/588069.htm

Excel 2016 FAQ

1. Merge multiple tables

Method 1: Data menu merge query

Open a blank table → click Data → New Query → From Workbook → Select the first table.

After the query editor has preprocessed the data, click Close and Load.

Repeat steps 1-2 to add additional tables.

Click Data again → Merge Query → Select the base table and the table to be merged, and confirm after matching the columns.

Method 2: VLOOKUP function

If the tables have common columns (such as ID), enter the formula in the target table:

=VLOOKUP(A2, Sheet2!$A$2:$B$100, 2, FALSE), drop-down filling.

2. Embed pictures into cells

Click the target cell → Insert → Picture → select the picture to insert.

Right-click the image → Size and Properties → Adjust dimensions to fit cells.

Optional: Set image as background (Format → Fill → Image Fill).

3. Cancel the super table

Select any cell in the super table → automatically display the Table Tools - Design tab.

Click Convert to Area → Confirm to convert to a normal table.

4. Convert image to table

Excel 2016 does not have built-in OCR, you need to use tools:

Online conversion: Upload the image to Zhuanzhuan Master online tool and download it after conversion.

OCR software: such as Zhuanzhuan Master, batch recognition of pictures and transfer to Excel.

5. Bring up the data menu bar

If the ribbon is hidden:

Click on any menu (such as Start) → Pin Ribbon button on the right.

If it is still missing, check File → Options → Customize Ribbon and check the Data tab.

6. Set comment format

Right-click the cell → Insert comment → Enter text.

Right-click the annotation border → Format annotation → Color and Line → Fill Effect → Select the picture to insert.

7. Set cross cursor

Click View → Reading Mode → Choose Color.

After enabling, the row and column where the cursor is located will be highlighted. Click Reading Mode again to close.

8. Cross-trace rows and columns (freeze panes)

Select the cells below the row to be frozen (for example, to freeze the first two rows, select row 3).

Click View → Freeze Panes → Freeze Panes to fix rows and columns while scrolling.

9. Save as

Click File → Save As → Browse.

Select the save path → Save as type drop-down menu and select the desired format (e.g. .xlsx, .pdf).

10. Freeze specified rows and columns

Freeze a row: Select the cell below the row → View → Freeze Panes → Freeze the top row.

Freeze column: Select the cell on the right side of the column → Freeze the first column.

Freeze rows and columns simultaneously: Select crossing cells → Freeze Panes.

Excel 2016 update log

1. Added color and medium gray to the theme color.

2. The touch mode of Excel 2016 has larger font spacing, which is more convenient for direct operation with fingers.

3. The Clippy assistant returns. There is a text box that displays [Tell me what you want to do] on the ribbon. It is the [Tell Me] search bar.

4. The [Open] and [Save As] interfaces in the Excel 2016 file menu have been improved.          

5. Excel 2016 integrates the sharing function with OneDrive, greatly simplifying file sharing.             

6. Save the workbook in OneDrive for Once in Business or SharePoint, in the [History] interface of the [File] menu, you can view a complete list of changes made to the workbook and access earlier versions.

7. Add ink formulas in Excel 2016. Users can use their fingers or touch pen to manually write mathematical formulas in the editing area.

8. Newly added tree charts, sunburst charts, histograms, Pareto charts, box plots and waterfall charts in Excel 2016.

9. There is a built-in 3D map in Excel 2016. Users can easily insert a 3D map and play it synchronously with the 2D map. At the same time, the Power Map plug-in improves this function.