Posts under Excel tag.

How to track multiple projects in Microsoft Excel on Windows

Microsoft Excel is a popular spreadsheet program used to store, format and organize the data. It is an integral part of the most business organization that is used to perform budgeting, create financial statements, create balance sheets and other accounting […]

10 useful free Project Management Templates for Excel

Microsoft Excel is a commonly used spreadsheet software for organizing and managing data. Like all other spreadsheets, Excel allows you to calculate data with formulas, use graphing tools, build charts, create macros and design pivot tables. Whether you have a […]

Excel is crashing or not responding on Windows 10

Recently we came across several complaints from Microsoft Excel users who are having problems with the software. Apparently, the program is crashing whenever they attempt to open a new file, or at least 50 percent of the time. The question […]

find square root of a number in excel using exponent function

3 different ways to find the Square Root of a Number in Excel

Microsoft Excel is a powerful tool to carry out complex calculations. If you work on Excel, then you might come across performing mathematical operations almost every day. Sometimes, we face problems to do simple calculations in Excel and to find […]

calculate sporadic totals in excel

How to calculate Sporadic Totals in Microsoft Excel

Microsoft Excel helps us to do simple and complex calculations easily. If there are a list of numbers, then it is very simple to find the SUM of them. But sometimes, we come across a situation where the numbers in […]

insert multiple blank rows in excel at once

How to insert Multiple Blank Rows in Excel at once

Microsoft Excel always fascinates me with its awesome features which help us do lots of stuff easily. If you are dealing with a lot of data and as it keeps on changing, you might come across a situation where you […]

Excel-not-opening-blank

Fix Microsoft Excel opening a Blank document

It is quite irritating when a software malfunctions and doesn’t open the files on the very first go. Microsoft’s datasheet managing app the Microsoft Excel which is one of the most sought-after data tabulation tool could face such issues at […]

How to delete duplicate rows in Excel and Google Sheets

How to delete duplicate rows in Excel and Google Sheets

Microsoft Excel is probably the most used spreadsheet software and among the alternatives available is Google Sheets. Whether you need to create a 5-column spreadsheet or a 50 column one, you can make use of Excel as well as Google […]

change default number of worksheet in Excel workbook

How to change default number of Worksheets in Excel workbook

Microsoft Excel is probably the best tool if you want to create an invoice, report card or almost anything which involves numbers. Everybody uses Excel either offline or online. This Microsoft tool has been helping different types of people – […]

find-and-remove-hyperlinks-in-excel-with-text

How to easily Find and Remove Hyperlinks in Excel

If you have an Excel spreadsheet with a lot of hyperlinks and if you want to remove few of them, then it would be a tedious task to find and remove each hyperlink manually.  You could do it manually if […]

PDF File with the new name

How to Insert a PDF File in an Excel Sheet

Microsoft Excel allows us to represent data in a uniform way. We can show complex data in the form of charts or tabular format. Suppose, you have a list of products that you want to share along with the product […]