7 Excel Tips to Impress your BOSS
Excel is a standout amongst the most prevalent software programs for organizations. It’s used extensively by representatives and managers in a variety of commercial enterprises. But, in the event that you work in a business organization, you ought to know certain Excel tricks that will make your job less demanding and make you shine as an important staff member in front of your boss.
In the event that you need to copy a bunch of formulas to another range of cells – this will be extremely helpful. Simply copy the cells containing the formulas (Ctrl+C), then press ALT+E S F (One key after the other). You can accomplish the same impact by dragging the formula cell to new range if the new range is adjacent.
Utilize a Pivot Table to Summarize Data
A pivot table in Excel essentially gives you a chance to sort and categorize tabular information. A pivot table is imperative on the grounds that your information will truly just be valuable in case you’re ready to extrapolate implications from it. Pivot tables will help you with summarizing your information and recognizing patterns. This in turn will help you do business more viably. In the event that you don’t know how to make a pivot table in Excel, you can view this video. This instructional tutorial will permit you to add this important expertise to your resume and inspire your bosses.
Program a Macro
As an Excel user, you should also be familiar with macros. A macro is a program that records and executes a progression of commands automatically with only a single direction, for example, the click of a mouse. Macros are essential to utilize on the grounds that they can make any long and repetitive manual process super easy with the assistance of automation. So why invest energy buckling down when you can let the project do the diligent work for you?
Change the color of various sheet name tabs
Right click on sheet tab and select “Tab color” option to change the worksheet tab colors. Group them with similar colors if you have lot of sheets, it looks nice. You’ll find this video helpful.
Use VLOOKUP and HLOOKUP
Excel is a complete package of useful functions; however you may not require acquaintance with most of them. However, you ought to know how to utilize the VLOOKUP and HLOOKUP functions. This will give you a chance to scan all through any table for a specific value. You can then automatically fetch the associated value.
VLOOKUP, which is also known as “Vertical Look-Up” will search sections vertically down the data that you require. In the event that you use HLOOKUP, you can likewise hunt horizontally for the necessary information. Eventually, you’ll have the capability to search vast databases rapidly. Doing it manually would take up a considerable amount of your time and result in blunders.
Instantly calculate loan instalments using spreadsheet formula
Lets say, your boss has set his eyes on a beautiful car or a beach property. But before visiting the seller / banker wants to find out the monthly payment details, i.e. how much his monthly / bi-weekly loan payments would be. Thankfully Excel has the right formula to divide an amount to equal payment instalments over a given time period, the PMT function.
With such a large number of Excel functions, how to handle errors
When you get to the proficient space of excel functions to streamline your work, you are sure to have mistaken information, missing cells and so forth that can ruin your formulae. If there is an approach to discover when formulae contain mistakes, you can handle it easily. Well, there is an approach to see whether a cell has an error or a correct value. ISERROR function lets you know when a cell has errors.
With these Excel tips, you can automate a lot of long manual processes, save a lot of time, and surely impress your boss.