Excel Tips - Easy working with Excel Formulas

-
When editing formulas in excel, it sometimes becomes difficult to input the required parameters correctly for the formulas. 

Hence to help us we have an option to display the formula along with the input parameters in an input-friendly format.

Check out below !!

1) When inputting a new formula in an excel cell, type the formula and then press CNTRL+A, and below is what you get which helps in giving the correct input to the formula




2) The above shortcut will not when if you want to change an existing formula. So when changing the formula in a cell, select the cell and press SHIFT+F3



Now in the above case, we have multiple formulas in the same cell. You can see both the formulas in this format by just clicking on those formulas in the input bar at the top




This pop-up for editing the formula is very helpful as it shows the output also as we give the inputs to the parameters of the formula.





Comments

Post a Comment

Popular posts from this blog

SAP ABAP - Generating Excel file for downloading or sending over email

-
Creating excel content from data in an internal table?  Getting the following message when opening an excel created out of SAP - "The file you are trying to open, ‘filename.xls’ is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?" Below is the best solution. This solution is based on the approach used by standard SAP to created excel content from ALV. Once any ALV is displayed, you can get the data into excel using the menu bar option LIST -> EXPORT -> SPREADSHEET.  If there are any questions, put them in the comments.  Sample working code: *&---------------------------------------------------------------------* *& Report Y_EXCEL *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT  Y_EXCEL ...
Read more

Get your signature from a paper to word document

-
Image
Follow the below steps to your signature from a physical hard copy onto a word document. Also ensuring that the background matches. Step 1: Put your signature on a piece of paper and take a snap of it with your mobile camera. Below is what you will have    Step 2: Open a word document that would basically have contents of a letter that you are drafting needing your signature on it and paste the signature pic from step 1 in the appropriate location. Step 3:  The next step is to ensure that the background of the signature is changed so that it matches with the rest of the content on the word document. Right-click on the image and select 'Format Picture' Go to the option of 'Picture Corrections' and set the contrast as '100' The end result is the following:
Read more