Posts under Excel tag.

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 […]

apply conditional formatting in excel

How to create a Checklist in Excel

Most of us use To-Do apps to list down the tasks which we want to do on a particular day. This keeps us to complete our tasks without any procrastination. But, if you are an Excel lover like me then […]

paste excel chart in word document

How to easily export Excel Charts as Images

Microsoft Excel is the widely used spreadsheet application because of it’s amazing features. It allows us to use attractive charts to give the complete information in an easy way. Sharing an Excel file is what we generally do, but sometimes […]

remove macro virus

How to remove Macro Virus from Word or Excel

A Macro Virus is a malware that can infect any software written with a macro language notable among which are the Microsoft Office programs like Word and Excel. Macro Virus takes advantage of Macros that run in Microsoft Office applications. […]

Get & Transform in Excel 2016: New features

Get & Transform in Excel 2016 can help you search for data sources, make connections, and then shape that data in ways you deem fit. For instance, you can remove a column, change a data type, or merge tables. once […]