10 things you should never do in Excel
                     1 0  T H I N G S  YO U  S H O U L D  
N E V E R  D O  I N  E XC E L
ABSTRACT
• Microsoft Excel is a spreadsheet program. That implies it's utilized 
to make frameworks of content, numbers and equations indicating 
estimations. 
• That is very important for some organizations, which use it to 
record uses and pay, plan spending plans, outline information and 
concisely present financial outcomes.
NEVER RELY ON DEFAULT SETTINGS
• Exceed expectations defaults may be sufficient for a few or even most 
clients, yet in the event that you get yourself resetting things each time you 
start another exercise manual document, stop.
•  Rather, open a clear exercise manual, change those settings, and spare the 
record as a layout.
NEVER LEAVE BLANKS
• Spaces aren't intrinsically awful, yet they can make worked in 
highlights troublesome, if certainly feasible, to utilize. 
• When Excel experiences a clear, it can neglect to sort and channel 
accurately. A few capacities assess spaces uniquely in contrast to you 
may anticipate.
NEVER USE NUMBERS AS COLUMN 
HEADINGS
• Numeric headings can unleash devastation on highlights you 
underestimate.
• Excel interprets the number as part of your data range instead of the 
header row. 
DO NOT ALLOW ERROR VALUES
• Numeric headings can unleash devastation on highlights you 
underestimate.
• Excel interprets the number as part of your data range instead of the 
header row. 
NOT KEEPING BACKUPS
• On the off chance that you attempt to exit without sparing changes, 
Excel reminds you. 
• Nonetheless, Excel won't remind you to make a reinforcement. This 
is likely the most horrifying choice clients make.
DO NOT RELY ON MULTIPLE LINKS
• Connections between two workbooks are normal and valuable. Be that as it may, 
different connections where values in workbook1 rely upon values in workbook2, 
which connects to workbook3, etc., are difficult to oversee and unsteady. 
• Clients neglect to close documents, and once in a while they even move them. In 
case you're the main individual working with those connected workbooks, you 
probably won't run into inconvenience, however on the off chance that different 
clients are checking on and adjusting them, you're requesting inconvenience.
DESTROYING DATA
• Try to import data from the source but never try to copy and paste, 
because in this way you may end up with destroyed data.
S L I D E  T I T E
THANK YOU 
                                          
                
            
Comments