Posts under Excel tag.

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

How to remove Blank Cells from Excel 2016

Sometimes while filling up the large list, empty rows remain at the end of the process. To make your work look like a flawless job you need to clean up the list. Removing blank cells in rows or columns from […]

How to create a Funnel Chart in Excel, PowerPoint and Word 2016

Most business establishments readily accept business reports from Business Intelligence software, that displays them in Funnel chart type which is widely used for sales data presenting. Apart from showing the sales reports, a Funnel Chart represents stages of sales progress […]