Latest Posts

How to use Goal Seek to find an input value?

Goal seek is part of the What-If Analysis set of data analysis tools, in Excel. A user can evaluate the input value needed, to produce the desired ...

How to Find Correlation between Two Variables in Excel

Correlation is a statistical measure that indicates, whether there is a relationship between two variables. Correlation measures the strength of the ...

Text to Columns in Excel (Split Column, Text, Date, …)

Excel's Text to Columns Wizard is a very important feature with many uses. In this article, I will teach you some useful uses of Text to Columns in ...

Date & Time in Excel – How to Enter Them in Worksheet Cells Effectively?

Date System in Excel An Excel date is simply a serial number. The earliest date that Excel can understand is January 1, 1900. This date has ...

How to Use Excel Objects to Create an Art Portfolio

Inserting Objects Inserting objects in Excel means that Excel actually stores these objects (PDF files, Word documents, or images in bitmap format ...

What is the Difference Between Bar Graph and Histogram?

This is a question that is often asked. What is the difference between a bar graph and histogram and when one should use a bar graph versus a ...

How to Add or Remove Cell Borders in Excel

In the last edition of our posts, you read about aligning contents in the cells in all directions possible. Today we will be focusing on cell borders ...

Viewing and Scrolling Multiple Excel Workbooks at the Same Time

Sometimes we work with more than one Excel workbook at a time. In this short article, I will show how you can view and scroll multiple Excel ...

How to Use Solver in Excel (Solving Linear Programming Problems)!

The solver tool is used to find an optimum value (either a maximum or minimum depending on the example) for a formula in one cell, by changing ...

How to Make Negative Numbers Red in Excel (3 Ways)

Sometimes, it is important to mark cells that have some specific values. Most often, users need to differently mark negative and positive values. In ...

How to Create Pivot Tables for Meaningful Data Analysis!

Pivot Tables allow you to summarize and organize data quickly and efficiently, in order to identify patterns, trends, and other key insights. One can ...

Excel Pivot Table Calculated Field (How to Insert & Edit)

When you are using Pivot Tables, you can use calculated fields as a way of making your own custom calculations. In this article, we shall learn ...

Excel If Function with Multiple Conditions (Nested IF)

We have already seen, how to use the IF function in basic Excel formulas. Using the IF with other functions together, in a complex formula, allows ...

How to make Excel graphs look professional & cool (10 charting tips)

In this article, Taryn (Our seasoned blogger) has shown how to make Excel graphs/ charts look professional and cool. She has made her charts look far ...

How to Format an Excel Spreadsheet for Printing (10 Tips)

In this article, you will learn how to format an Excel spreadsheet for printing. I'm sure these tips will help print your data more professionally. ...

ExcelDemy
Logo