## 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 in the actual spreadsheet itself). This can be useful, if you want...

## The Main Differences between a Bar Graph and a Histogram

This is a question that is often asked. What is the difference between a column chart and a histogram and when should one use a histogram versus a column chart. Both the column chart...

## 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 in the worksheet. They are quite handy...

## 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 workbooks at the same time. At any...

## How to Use Solver in Excel [Explained with a Real Life Example]

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 decision variables. In order to deliver a...

## How to Make Negative Numbers Red in Excel

Excel is a tool that has huge quantities of data. Sometimes, it is important to mark cells that have some specific value. Most often, users need to differently mark negative and positive values. There...

## How to Create Pivot Tables that Provide Meaningful Data Analysis & Insights

Pivot Tables allow you to summarize and organize data quickly and efficiently, in order to identify patterns, trends, and other key insights. One can quickly structure and re-structure the Pivot Table, by dragging and...

## How to Insert, Edit & Delete Calculated Fields From Excel Pivot Table!

When you are using Pivot Tables, you can use calculated fields as a way of making your own custom calculations. Pivot Table Reports already provide a set of summary calculations and function options, but...

## Best PDF to Excel Converter Software Review [Able2Extract Professional 11]

There are not many PDF tools that have successfully stood the test of time. There are even fewer who were able to stay at the top of their game for over ten years and...

## How to Use the IF & AND Functions to Test Multiple Conditions!

We have already seen, how to use the IF and AND functions separately in basic Excel formulas. Using the IF and AND functions together, in a complex formula, allows you to test multiple conditions...

## How to Make Excel Graphs Look Cool & Professional [10 Ways]

Creating charts and graphs is basically about ensuring effective visual communication and presentation of your data. Excel provides default graph settings, upon creation. However, for business purposes, it’s often necessary to spruce up a...

## 10 Amazing Tips to Print Data in Excel Without a Headache

[Editor’s Note: This is a guest post by Puneet Gogia, the founder of Excel blog Excel Champs. I went through the article and enjoyed his top 10 printing tips with Excel. I’m sure these tips will...

## Excel Dynamic Named Range [4 Ways]

Excel Dynamic Named Range is one of the Excel features that not so many Excel users know about. This text will make Dynamic Named Ranges closer to you. In the further lines, hints and...

## What is the Order & Precedence of Operations in Excel?

Understanding the order and precedence of operations in mathematical formulas or in an Excel Formula is very important. Excel has total 17 operators that you can use them to build complex Excel formulas. Here...

## Exponential Notation in Excel & How to Turn Off Auto Scientific Notation!

This article will at first introduce you with the scientific number system and number precision definition. Then you will know about the highest and lowest number limitations in Excel. At the end of the article,...