This example illustrates the various Paste options in Excel.
For referencing the current sheet tab name in a cell in Excel, you can get it done with a formula or User Define Function.
Calculating percentages in Excel is easy. Percentage simply means ‘out of 100’, so 72% is ‘72 out of 100’ and 4% is ‘4 out of 100’, etc.
The square root of a number is a value that, when multiplied by itself, gives the number. The SQRT function in Excel returns the square root of a number.
Excel doesn’t have a divide function, so performing division in Excel requires you to create a formula.
Multiplying and dividing in Excel is easy, but you need to create a simple formula to do it.
How to Subtract Cells in Microsoft Excel. Microsoft Excel tutorial on how to subtract using Microsoft excel.
Use flash fill in Excel 2013 or later to automatically extract or to automatically combine data. Flash Fill in Excel only works when it recognizes a pattern.
This example illustrates how to use the union and intersect operator (borders below for illustration only) in Excel.
Use the ‘Paste Special Transpose’ option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.
Adjusting column widths and row heights in Excel can make for a much nicer looking spreadsheet.
It is a useful built in feature in excel that can save a lot of time. This feature is mostly used while we are importing data in excel workbook.
Normally, we hide or unhide rows and columns by using the Hide or Unhide features from the right-clicking menu. Besides this method, we can hide or unhide rows or columns easily with plus or minus sign in Excel.
When you’re collaborating with others on your spreadsheet, inserting comments can save you a lot of time.
If you create a custom list in Excel, you can easily fill a range with your own list of departments, clients, cities, credit card numbers, etc.