Most candidates in an interview say that they have proficiency in MS Excel and can handle whatever Excel tasks they are given with. But then the scenario changes when that actually happens and they end up researching about that very task and how to do it on Google or watch online MS Excel tutorials, thus, wasting valuable time of the company as well as of themselves. To save you from such an embarrassing situation, we have a list of the most helpful Excel tools and tricks which have proved to be extra useful for many.
A few nifty Excel tricks to keep up your sleeve:
- How to send a read-only PDF file?
Often you may need to send a read-only PDF Excel spreadsheet for sharing important information that cannot be edited or manipulated. In such instances a PDF document comes in handy. Now you may be thinking that sending an Excel sheet PDF is simple using Adobe Acrobat. But what if you do not have Adobe Acrobat? You can still send a PDF using Excel itself. Simply follow the below mentioned steps: click on File > Send > and email the file as a PDF Attachment. You can also avail the option to save the file as a PDF instead of emailing; it helps you save files in forms that cannot be edited thereafter. In case your present Excel version downloads the updated add-on from the official website of Microsoft. - How to import data from a website?
If you come across a website with data that you need to work on a project with but want it in the spreadsheet form, how do you convert it? Click on File > Open > then change the format of the file to All Web Pages. With this all the file formats like .html, .htm, .mhtml etc. will be covered. Then simply go to the web pages and click on Open. When you are done with these steps the webpage content will open but the formatting might still require some tinkering. But still this is way easier than building a new workbook from scratch. - How to fine-tune specific search results using filter?
When using a huge spreadsheet with numerous data on it but you have to find out a specific one from thousands of entries, you may find yourself lapsing into a mini-coma. But thankfully Excel has a function called Autofilter that can be used to search for something that you specifically want to find and exclude what is irrelevant to your search needs at the moment. To use this function, click on the cell at the lower left-hand corner go to Data > Filter > AutoFilter, then you will find narrow boxes in your spreadsheet that will further help you narrow your search. Then use the custom filter and simply type in the type of data you are looking for in the sheet.
While these are a few simple tricks and techniques in Ms Excel, there are plenty of other smart Excel features that can help you be an asset to your firm. To learn more advanced MS Excel techniques we recommend you find a suitable advanced Excel institute in Gurgaon.
Related posts :
0 comments:
Post a Comment