Mastering Excel takes some experience and patience and complete knowledge of it, but it’s easy to make mistakes no matter how long you are using it. Sometimes, decisions seem like a brilliant idea—until they’re not, and the resulting problems are hard to troubleshoot and to find out the solution. In this article share almost 10 ways to avoid while working in excel.
I’m using Excel 2016 on a Windows 10 64-bit system. There’s no demonstration file because.
1: Dependent on multiple links
Making links between two workbooks are easy and common. But more links like multiple links and values in cells in workbook 1 depend on values in cells in workbook 2, which links to workbook3 under different cells, and so on, are hard to manage and unstable and people to forget from where they have picked that data. Users forget to close files, and sometimes they even move them. The only person, who is working with those linked workbooks, might aware of all these and only he/she cannot run into trouble, but if other users are reviewing and modifying them, you’re asking for trouble. If you truly need that much linking, you might consider something which is better than excel.
- Business Success and Microsoft 365 Implementation
- Fixing Microsoft Office Setup Installation Error 1401,xx02, xx06?
2: Damage data
Using the same spreadsheet for new data by overwriting the existing data which are written on the same spreadsheet may destroy the existing data. For example, you might enter this week’s pollution figures over last week’s—destroying last week’s data. In the short run, this process seems changing the existing data which is not good what needs to be done we should we the new workbook file or create another spreadsheet or we can use the new template as well to keep both the data safe this will help you in Keeping your data intact so you can refer to and compare it later.
3: Rely on common settings
Excel common setting might be sufficient for some or for most users, but if you are trying to reset things of your own every time when you open a new workbook file then you need to stop it as early as you can. Instead, you should open a new workbook, change the required settings, and save the file as a template. Then, the master template will open new workbook files on the template instead of Excel‘s built-in template. Or alter the common workbook.
4: Ignore Table objects
Top potential presented the Table disapproval in Excel 2007. Tables are proficient, and they’ll make your life somewhat simpler. Table articles accompany designing, equations, separating, subtotals, and more constructed right in. One of my top choices is the constantly obvious header push, appeared in Figure A. Table protests even help information approval; on the off chance that you add information approval to a cell, the Table broadens it as you include new columns. Diagrams are mysteriously powerful. Everything’s only more straightforward with a Table. To take in more about Excel Table items, read 10 motivations to utilize Excel’s Table protest.
5: Use Excel as a database or Word processor
I recently received a work in Excel. When I finally inquired why me—I didn’t know to use excel as a word processor—the client said, “Because no one knows how to use Word efficiently in excel.” They need me! They were trying to process the word with some familiar software, but doing so seriously put you in trouble. While utilizing Excel as an altering or resetting device probably won’t be the most noticeably awful thing you can do, utilizing Excel as a database could cause you to harm on the grounds that exceed expectations does not have every one of the things in his database as different databases have like SQL—the two concepts simply aren’t the same. Use the right tool for the job always for the better results and if you don’t know how then take the help of the someone who does or consider some affordable training.
6: Forget to password your work
After spending time and doing your best in developing a good spreadsheet, don’t give any copy or share it without applying for password protection. Failing to do so opens your work to misdeeds or someone may change the figures—even when users aren’t trying to be malicious activities. Password the entire sheet and unlock only those cells which other users need to work on and where ever the update is required that users need to update. Everyone will be happy after seeing this protection on it.
7: Leave spaces
Spaces aren’t always bad, but they can make built-in features difficult to understand, if not impossible, to use. When Excel counters a space, it can fail to sort and filter correctly and make it difficult for the other data to get sorted or filtered. Some functions count spaces differently than you might expect. For instance, the AVERAGE() function counts the value 0 and an empty cell differently, as shown in Figure B. (The values in both columns are identical except for the space cell and the 0 in the bottom row.) If a value truly doesn’t exist, we have to use a string such as Unknown rather than leaving a cell with space.
8: Use numeric as column headings
Using a numeric as a column heading might seem like a good idea—at least until you try to use some of Excel‘s features which are already built-in. Numeric headings can cause chaos on features you take for deciding. For example, what happens when using AutoSum. Excel interprets the column number 2017 as part of your data range instead of the header row. To the right of the column, 2017 is text, so AutoSum will not count it. unluckily, it’s very easy to stop thinking about such small actions but instead of this, we should have to use the table feature in it because Excel table won’t evaluate header content.
9: Allow error values
If you share Excel spreadsheets files with other users, include error-handling functions to avoid error values that others do not understand and to provide information which you need and that they will. Error values are not wrong. In fact, they’re great hints to problems, but they’re confusing for the person who does not need to know what is this all about. They’ll waste their time and yours as well of trying to fix something that’s not really broken.
Excel has several features and functions of error-handling.
- ISNA() , ISERR(), ISERROR(),ERROR.TYPE(),IFERROR().
10: Slough off backups
If you try to exit without saving the changes, Excel reminds you. Do you want to save it or not? However, Excel won’t remind you to create a backup. This is probably the most difficult decision users make. If you don’t have a systematical backup process, consider having one. In the meantime, save locally or to make a backup where ever it is easy to do like intranet destination as you normally do. Then, create a second copy on a thumb drive flash drive or in the cloud. If using a thumb drive, flash drive be sure to store in a safe zone. For office Setup Visit office.com/setup