Posts under Excel tag.

insert excel spreadsheet in word editable

How to insert Excel Spreadsheet in Word Document

Sometimes we need to insert Excel Spreadsheet in Word Document. It can be done is such a way that, whenever you update the Excel Spreadsheet, it automatically needs to be updated in the Word Document, so that we can avoid […]

error messages in excel error alert

How to add Error Messages in Microsoft Excel

As we all know Microsoft Excel is used to collect data in rows and columns. Sometimes, we want to restrict to only certain data to be in the sheet. We want to throw an error, when someone is trying to […]

Use Advance Filter in Excel added condition 2 in criteria region

How to use Advance Filter in Excel

We know that we can set filters on columns and filter the data with just a click in Microsoft Excel. It can be done by clicking on the ‘Filter’ under “Data” tab. Apart from just filtering the data based on […]

find wildcard characters in excel using tilde

How to Find and Replace Wildcard Characters in Excel

Finding and replacing required text and numbers is very easy with the use of Wildcard Characters in Microsoft Excel. It might be single occurrence or multiple occurrences – everything can be found and replaced easily using Wildcards. There will be […]

How to create a Forecast in Excel 2016 for Windows 10

Analysis of time-based series data can help us understand the prevailing trend in the market. One-click Forecast in Excel 2016 does this pretty well. As such, it can help you understand the current as well as future trends. Let us […]

How to stop or turn off Workbook Sharing in Excel 2016

Once the final version of your Excel 2016 workbook is complete you might want to stop or turn off the workbook sharing in Excel 2016 to avert any unwanted changes. However, before stopping the sharing of a workbook, ensure all the […]

final time difference in excel

How to calculate Time Difference in Excel

Microsoft Excel can be used for budget calculations, Tax calculations and for many other purposes. You can use it as another form of calculator due to the features it provides us. You can even make use of Excel to calculate […]

How to insert a picture into a comment in Excel

Suppose you receive an Excel document from a friend and would want to leave your feedback about the description. While adding a comment to a particular cell in the worksheet would suffice, posting a picture can be more insightful, especially, […]

add table format to excel data

Advanced Excel Tips and Tricks for Windows users

Many of us are aware of some Microsoft Excel tips but there are many more which we do not know. These lesser known advanced Excel tricks will help us to complete complex tasks in an easy way. It might be […]

save chart as template

Microsoft Excel Tips to Save Time and Work Faster

Microsoft Excel is a great tool which does your tedious job in an easy way. Whether it might be repeated tasks or managing the data in a clean way, Excel does it well. There are many Excel features which most […]

Final Values

How to solve Equations in Excel using Solver Add-in

Microsoft Excel is a great Office application from Microsoft and it does not need any introduction. It helps every one of us, in many ways by making our tasks simpler. In this post we will see how to solve Equations […]

Import details of files 1

How to get a list of files in a folder into Excel

In this post we will see how to get a list of files in a folder into Excel. We will show you how to use Excel to view Files and Folders details in Windows, by importing all files and folders […]

pull stock quotes in to excel easily

How to get Stock Quotes in Excel

Most of us use Microsoft Excel in our daily life in many ways. We use it to keep track of tasks to be completed using color coding and people dealing with business, use it to keep track of products brought and […]

Enable the developer tab

How to create Custom Excel Functions

Microsoft Excel Pack comes with the many pre defined functions which does the maximum job for us. We never need any more functions other than those built-in functions in most of the cases. But, what if you are in need […]

Excel Name Box

Make the best use of Name Box in Excel

Many of us make use of Microsoft Excel to calculate budget or to do some additions and subtractions. We also know that it supports Macros which helps us to automate our tasks. An Excel sheet is no stranger to us […]