Advanced Excel

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 ...

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 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. ...

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 article will make Dynamic Named Ranges closer to ...

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

This article will first introduce you to the scientific number system and number precision definition. Then you will know about the highest and ...

How DAX Works. DAX Data Types & Operator. Check & Handle Error.

Last time, I made an introduction on how to import data into PowerPivot, create PivotTable/PivotChart using PowerPivot. In that article, I also ...

How to pull/extract data from a website into Excel automatically?

In this article, I shall show you how to pull / extract or get data from a website into Excel automatically. This is one of the most used Excel ...

How to Import Data from a Website to Excel?

It is well known that World Wide Web contains huge useful data. However, we have to import the data into Microsoft Excel before doing any kind of ...

How to create a database in Excel (make in 8 easy steps)

Don't know how to create a simple database in Excel? In this article, I will show how you can make a database in Excel in just simple 8 steps. Do ...

Import Data (Sentence, Paragraphs, Tables, Comments) from Word to Excel

In our daily working life, we may need to import data from a Word file into an Excel file. In most cases, we would like to copy the text from a Word ...

Top Excel Functions and Features for Management Consultants

Microsoft products are truly amazing tools for management consultants who need to do data analysis and make a presentation before clients. And ...

Top 20 Excel Limitations that might Frustrate You!

Excel is obviously one of the most important products in the world. It is very helpful in managing, analyzing data. But there is also something that ...

How to Make an Excel Add-in [Narrated with an Example]

So, you mastered VBA (or not) and automated that extremely complicated operation that consumes all your time. Let’s call your invention ...

Use of Offset Function in Excel [Offset – Match Combo, Dynamic Range]

Today I’d like to introduce you to Excel's OFFSET Function with 3 real-life examples. At first, I will describe the formula syntax and then I'm ...

ExcelDemy
Logo