Buzz
In Excel, there are countless tricks that one could spend a lifetime learning, especially when it comes to Excel functions, a vital aspect for users. Particularly in using Excel for calculating salaries, grades, employing common calculation functions like SUMIF or SUM is essential knowledge for everyone.
7 tips to excel in using Excel 2016
Utilizing Conditional Formatting
In Excel, highlighting important cells becomes effortless with Conditional Formatting. This feature eliminates manual formatting errors and confusion, making crucial cells stand out distinctly.
Step 1: Highlight the data cells. Navigate to Home, then select Conditional Formatting.
Step 2: Choose the condition you wish to emphasize. For instance, suppose Mytour intends to highlight cells with values greater than a specific value. Simply select Highlight Cells Rules > Greater than.
Then input the comparison value and click OK.
Here are the results: cells with values greater than 2 will be highlighted.
Utilizing Quick Analysis
This feature facilitates rapid analysis and execution of various tasks on selected data. Simply select the data and then click on the Quick Analysis icon located at the bottom right corner of the selection area. The dialog box that appears includes tabs such as FORMATTING (data formatting), CHARTS (creating charts), TOTALS (statistical calculations), TABLES (creating Pivot Tables)...
If you can't find the Quick Analysis icon. To bring it back, press the File tab, select Options from the left pane; choose General on the left pane (by default); in the User Interface Options section, check the option Show Quick Analysis Options On Selection. Press OK.
Create AUTOFILL String
This method to create a string according to a certain rule, instead of entering each cell, you only need a few simple drag operations to complete. For example, Mytour wants to create a column with increasing order numbers.
Step 1: First, enter the first 2 cells as samples with numbers 1 and 2.
Step 2: Then, highlight those 2 cells and click on the bottom right corner and drag down.
Step 3: The result will be cells with sequentially increasing numbers.
Power View (Overview and Exploration)
Power View is an intuitive data visualization technology that allows you to create charts, graphs, maps, and other highly interactive visualizations, making your data come alive. Power View is available in Excel, SharePoint, SQL Server, and Power BI. Here's how to do it:
Step 1: Enter your data and click the Insert tab.
Step 2: In the Reports section, select Power View and choose how you want to display it.
Pivot Table (Data Analysis Spreadsheet)
This feature helps you analyze all the data in the spreadsheet to make better decisions.
Step 1: Enter your data, select the Insert tab, and click the PivotTable option. The confirmation window will appear, click OK.
Step 2: Choose your preferred options from the right-hand panel.
Vlookup (Search)
This function aids in finding and retrieving data from a specific field in a spreadsheet. Readers can refer to detailed instructions on how to use the Vlookup function in Excel through a guide on using the Vlookup function in Excel.
Mytour has introduced you to 7 Excel 2016 tricks to help you calculate better, master Excel more proficiently. With these 7 Excel tricks, hopefully, you will use Excel more professionally, saving time and effort in calculations. In Excel, there's an interesting trick of converting numbers to words, unique but you may not know it. Refer to how to convert numbers to words in Excel and follow the instructions. And if you're new to Excel, why not learn Excel shortcuts first? Mastering Excel shortcuts will greatly assist you in using this software efficiently.
In Office 2016, particularly Excel 2016, there are some functions that do not appear in previous versions such as: CONCAT, TEXTJOIN, IFS... and many more other functions. To know what those functions are, refer to the Excel functions in Office 2016 here.
