Some Excel:
1. try ALT, when you press ALT some you will see some numbers or characters, you can press those characters or numbers after alt to get into that menu.
2. CTRL + ALT + V will give you special paste menu, there you can choose to paste only values or formatting etc.
3. PEMDAS, - Parenthesis, Exponents, Multiply, Divide, Add, Subtract
4. Evaluate Formula in Formula tab - formula step by step.
5. Trace Dependents - Highlights all the cell the which are dependent on that cell, vice verse for Trace Precedents.
6.
Comments
Post a Comment