How to link a part of data in Excel Worksheet in Microsoft PowerPoint

To make a PowerPoint presentation look more realistic, Office users can link an Excel worksheet in it. It has many benefits. One, it serves a valuable skill since it allows data to be presented in a more lucid and easy […]

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

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

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

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

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

How to Insert, Move or Delete Page Breaks in an Excel Worksheet

Microsoft Excel worksheets are very helpful in keeping data organized and fluid. It’s very easy to move or shift things around in a worksheet especially if you know how to manipulate data using Excel. Page Breaks refer to the separators […]

How to convert Excel file to PDF online using Google Drive

If you regularly use Microsoft Office Excel to share your work with others then, chances are you might have run into a situation where you wanted to send an Excel file as PDF file to someone. The default method offered […]

Customize the Quick Access Toolbar in Excel to make it work for you

The Quick Access Toolbar provides the speed and precision that you need in creating accurate reports. Manipulating this app to work to your advantage is all in your hand. Without the proper customization, Microsoft Excel’s Quick Access Toolbar will only […]

How to Co-Author and Collaborate on Excel Workbooks at the same time

Online co-authoring is a service using which you and your colleagues can work on the same document. Usually, the document auto-saves and the changes made by other co-authors is visible in a few seconds. It makes it easier to work […]

Microsoft Excel is waiting for another application to complete an OLE action

Object Linking and Embedding (OLE) is a technology developed by Microsoft that allows Office applications to interact with other applications. It allows one editing application to send part of a document to other applications and then import or take it […]

How to select a Row or Column as the Print Title of a Microsoft Excel Report

Print Titles is a feature in Microsoft Excel that enables its users to print a row or a column heading on each page of a report. This makes your printed copy easier to read and spot vital details mentioned therein. […]

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

Microsoft Excel Online tips and tricks to help you get started

From students to businessmen – Microsoft Excel can be a very useful tool for all who want to create reports, charts, tables and so on. When someone needs to create a chart using a free tool, Microsoft Excel Online is […]

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

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

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

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

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

The Windows Club

The Windows Club covers Windows 10/8/7 tips, tutorials, how-to's, features, freeware. Created by Anand Khanse.

Posts under Excel tag.