1._ can be very useful in attaining
results and saving time.
Answers
Answer:
Explanation:
All of us want to work more efficiently. Fortunately, there are dozens of ways to save time when working in Excel. In this article, I'll share 10 time-saving Excel tips that share two traits: They work with common tasks you preform all the time and they're 10 of my favorites.
More about Office
30 Excel tips you need to know (TechRepublic Premium)
How to delete chats and messages in Microsoft Teams
Microsoft Word: How the new transcription feature works and how it compares to other services
How to use PowerPoint's morph feature to move bullet points
I'm using Excel 2016 on a Windows 10 64-bit system, but most of these are valid in older versions.
Note: This article is also available in the free PDF 50 time-saving tips to speed your work in Microsoft Office.
1: Use Table objects
Table objects treat data as a unit and consequently, take care of a lot of things automatically--reducing the amount of time you need to interact with the data. When you convert a data set to a Table, you get automatic filters and formatting. Excel knows you're working in a Table, so pressing Tab cycles through the Table for effortless data entry. With a quick click, you can add a totaling row to the bottom of the Table. Headers are always visible, regardless of how many records you have. When you extend the Table by adding a column or a row, the Table extends formulas and formatting. Charts based on Table objects update automatically when you change the source data. You can accomplish all this manually without a Table, but a Table eliminates these tasks.
To convert a data set into a Table, click anywhere inside the data. Then, click the Insert tab and click Table in the Tables group. In the resulting dialog, specify whether your data has a header row, then click OK.
Note: Table objects aren't available in Excel's menu versions.
hidakoistock-584508172.jpg
Image: iStock/hidako
For a more detailed look at Excel's Table objects, read 10 reasons to use Excel's table object and How to vamp Excel Table objects for better readability and function.
2: Open several files at the same time
If you work with lots of workbooks open, you can save a bit of time by opening them simultaneously. Open Windows Explorer and use the Ctrl or Shift key to create a multi-file selection. When you've selected all the files you need, press Enter. That's it! The only limitation is that your workbooks need to be in the same folder. This isn't strictly an Excel tip; you can open all kinds of files this way.
3: Add multiple rows and columns at once
You probably know how to add a row or a column, but do you know you can use the same technique to enter multiple rows and columns? Simply select the same number of rows or columns you want to insert. For instance, to insert three columns between columns C and D, you'd select columns D, E, and F--three columns to the right of column C. Then, right-click the selection and choose Insert. (Or choose Insert Sheet Columns from the Insert dropdown in the Cells group on the Home tab.)
This trick works similarly for inserting multiple rows. For example, to insert three rows between rows 10 and 11, you'd select rows 11, 12, and 13--three rows below row 10--before right-clicking the selection.
SEE: Microsoft Excel 2016 for Beginners: Master the Essentials (TechRepublic Academy)
4: Quickly move or copy rows and columns
You can move a row or multiple rows by selecting the row(s) and then hovering over the top or bottom border until Excel displays the four-arrow cursor. At this point, you can drag and drop the selection--it couldn't be easier. To move column(s), use the left or right borders. If you want to copy the selection instead of moving it, hold down the Ctrl key while you drag and drop.
5: Generate a unique set of values
It's common to see values repeated in the same column of a data set. If you need a unique set of those values, you can use Excel's Advanced Filter feature as follows:
Make sure the column has a header cell--it's required. Add header text if necessary.
Click any cell in the column.
Click the Data tab.
Click Advanced in the Sort & Filter group.
In the resulting dialog, click the Copy To Another Location option.
Make sure the List range is correct; it doesn't always represent your clicked column.
Click inside the Copy To control and enter the first cell of the copy range or click a cell in the sheet.
Check the Unique Records Only option (Figure A).
Click OK to create a unique list of values in the Copy To range
Answer:
use table object open servel files at the same time