Posts under Excel tag.

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

How to share Excel Insights with Power BI Publisher for Excel

Power BI is a cloud service that lets users access and share their Microsoft Excel reports anywhere on any device. The service works with Excel in tandem to offer a complete self-service analytics solution. Thus, every person can benefit from […]

How to Unpivot Static Tables in Excel 2016

If you are a regular Microsoft Excel 2016 user, but not quite familiar with Power Query Add-in for Excel, then this post will acquaint and help you get started with it. Any advanced Excel user faces challenge of analyzing or […]

How to customize the Calendar Insights template in Excel 2016

Calendar Insights template in Excel 2016 is professionally designed and easy-to-use template that can help you plan and schedule your meetings. Originally designed for accounting purposes, the Excel App has come a long way and has turned into one of […]