Best Microsoft Excel help tips and tricks 2016 to work smarter


Microsoft Excel is a spreadsheet that can run on computer. Ms Excel can be used to organize all data into rows and columns. We can also use it to perform mathematical calculations quickly. Microsoft Excel features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. We spent a lot of time while working on excel. But to speed up data entry, change values worksheet-wide and to make the more powerful calculations all we need is best Microsoft excel help tips & tricks. So here we have listed some of very helpful Microsoft excel help tips will make your work more smarter.

Best Microsoft Excel help tips and tricks 2016

Add Automatic data

If you are make a spreadsheet but don’t yet know what’s going to go into it, you can feel its fields with random sample data before the fact to make sure your formulas are all working correctly. To-do just click in the top left cell of the area you’d like to fill and enter the formula =RANDBETWEEN(50,100) to generate a number between 50 and 100. Change the values to suit the kind of data you’ll be working with. Now just drag the fill handle of the cell over the area you want to fill with data – it’ll generate a new random number for each cell.

Own Formula

Writing your own formulas can be a difficult task for you, but modern versions of Excel make it far easier than it once was. Head to the Formulas tab to find the Function Library, a vast collection of all of Excel’s formulas. Click the cell in which you’d like to insert your formula, then dive in – they’re all categorised, each includes a description of its function if you hover over it, and a straightforward interface in which to enter the values you want calculated. The AutoSum function, in the same place, is a quick way to tot up figures without any typing.

Formatted Pasting

Some formulas in excel, like the random number generator (as described earlier), will tend to make your numbers jump around somewhat. If you’d rather keep them static, you can copy the data and, using the right click menu, paste only the generated values without the formulas. You can Explore the Paste Special menu to see what other kinds of paste operations are there: try using Paste Link to quickly create linked cells between sheets, or Transpose to paste a grid of data with the columns and rows swapped around.

Quick Formulas

Clicking through a sheet full of numbers to find out how they’ve come to be is not a task many would relish. It’s slow and laborious, and easy to lose track. Better, then, to use the shortcut [Ctrl]+[ ] (that’s the key at the top-left of your keyboard – just below the Escape key) to show all of the formulas on your sheet instead of their result. Hit the shortcut again to switch them back.

Quick Formatting

To do quick formatting in excel, drag to select a group of data, and look out for an icon appearing at the bottom-right hand corner of your selection area. It gives you instant access to a bunch of useful formatting features, all the way from coloring up your cells based on the range to implement sparklines, sums and charts. To see the preview just Hover over each option and click it to lock it down. Use the same tool to clear formatting if it gets too much – you’ll find the clear option listed under the Formatting heading. You can use same feature for pasting the data.

Define Constant (for repetitive task)

If you’re a regular Excel user & running same figures in all file, then defining constant is the best way to make work more smarter. Defining a constant – representing a complex number with a short word – can speed up formula creation greatly. Head to the Formulas tab and click Define Name. Pop the word or code you’d like to use in the uppermost box (‘speedlightvacuum’, for example) and the value you’d like it to represent in the bottom box (say ‘299792458’). Now you can just type the constant name in place of the number, preventing mistakes later on.

How to add comments in Excel?

A good work is what? Any reader’s can understand whole thing’s without asking. Right click a cell you’d like to explain and select Insert Comment to attach a note to that cell; you can resize and reposition the comment box if required. A cell with a comment is marked with a red flash in its top-right corner, and hovering over the cell will display that comment. It’s a good idea to add comments to column or row headers, and use the spacing tools to move them around so they’re not overlapping. The Show All Comments button in the Review tab will bring them all up at once.

Efficient loading on CPU

A worksheet full of formulas is a beautiful thing, but with a lots of data sets can have a big impact on the performance of your computer. To reduce the impact, you can ask Excel to use less of your processor – this will make complex formulas take longer to update, but leave the rest of your CPU open for other tasks. Navigate to File > Options > Advanced and scroll down to the Formulas section. You can either disable multi-threaded calculation altogether, or use the Manual radio button to select just how many threads you want to dedicate to running your calculations.

Handy Shortcuts

Here we have some handy shortcuts for excel which will make your work more smarter. [Ctrl]+[Shift]+[$], which will automatically convert a range of numbers into whatever your default currency is. [Ctrl]+[Shift]+[#], on the other hand, converts a range of numbers into your default date format. Holding [Ctrl] and hitting the arrow keys will jump to the end of the current row or column; hold [Shift] as well to select those cells. [Ctrl]+[Pg Up] or [Pg Down] jumps between the sheets in your current workbook.

Here we end our Microsoft excel help tips & tricks. Hope you liked.

Be the first to comment

Leave a Reply

Your email address will not be published.