How to open TSV files on Windows 10 PC
In this post, we will show you how to open & view exported .TSV […]
Tag: Excel
How to write, build, and use VLOOKUP function in Excel
The VLOOKUP function in Microsoft Excel literally means vertical lookup. It’s a search function for […]
How to add Header and Footer in Excel spreadsheet
If you want to add a header and footer in Excel spreadsheet, then this […]
How to apply color in alternate rows or columns in Excel
If you want to apply color in alternate rows and columns in an Excel […]
How to import Microsoft Access data into Microsoft Excel
Microsoft Access is the primary tool for those who want to create and manage […]
How to change Data Series name in Microsoft Excel graph or chart
If you want to rename or edit the data series name in Microsoft Excel […]
How to show or hide the Scroll bar in Excel spreadsheet
Microsoft Excel by default shows a horizontal and vertical scroll bar in an Excel […]
How to change default File Format for saving in Word, Excel, PowerPoint
If you do not want to save files in the default format, you can […]
How to show or hide List of Formulas while typing in Excel
When you start typing a formula in Excel, it displays a massive list from […]
Merge and Center button is missing, grayed out or not working in Excel
The Center Across Columns toolbar button is no longer visible in Microsoft Excel. It […]
How to copy Column Width from source to another spreadsheet in Excel
Manually adjusting the column widths in Microsoft Excel can not only be time-consuming but […]
How to calculate Grade Point Average or GPA in Excel
GPA or Grade Point Average is an important parameter used to judge the average […]
How to format Text as Superscript or Subscript in Word, Excel, and PowerPoint
Subscript and Superscript are important while formatting text in Word, Excel, and PowerPoint. However, […]
How to locate and reset the last cell on an Excel worksheet to remove formatting
Whenever you close a Microsoft Excel file and re-open it, the file, by default, […]
How to find the Cube and Cube Root of a number using Excel
Finding cubes and cube roots have plenty of real-life applications. They are essential as […]
How to calculate the area of a Rectangle, Triangle or Circle in Excel
Geometry is known to make mathematics and calculations easy. The area of basic shapes […]
How to calculate Simple Interest in Excel
Calculating Simple Interest is an excellent method to judge your savings in advance. However, […]
How to create a Line Chart and Scatter Plot Graph in Excel
Charts make working with Excel sheets easier. However, it is important to know what […]
How to create a Pie Chart in Excel
While you are provided with a lot of options for creating charts in Excel, […]
How to calculate Consumer Price Index or CPI in Excel and create its graph
Consumer Price Index is one of the most important indices for measuring inflation. In […]
