## 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 you find MS Access as a complex tool to use as a ...

## 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 Word file and then paste them into Excel file. But is ...

## 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 Microsoft Excel is no doubt one the most important tools ...

## 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 may get us frustrated when using Excel. Today I’d ...

## 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 SuperFunction. But what would you do if your boss tells you ...

## Excel Array Formula Basic 2 – Breakdown of Array Formula

If you’re a regular follower of my blog, you know that I have started writing a series of articles on Excel Array Formula. In the first article, I have demonstrated what are arrays in Excel and how ...

## 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 going to talk about how the OFFSET function can be ...

## How to Make FOR LOOP in Excel Using Formulas?

Don't you want to use Excel VBA and want to make a FOR LOOP in Excel using Formulas? In this article, I've shown how you can make one using functions: OFFSET(), MAX() and MIN()! If you know ...

## Top 20 Advanced Essential Excel Skills You Need to Know

Whether you’re just starting out on your Excel journey or have been using it for a while, there are a few skills that you should know about Excel: the best ways of doing things, certain pitfalls to ...

## How to Make a Gantt Chart in Excel [Video Tutorial]

You cannot create a Gantt chart in Excel in direct way. But don't worry, you can make advanced level Gantt chart in Excel modifying the Stacked Bar chart. This quick tutorial will guide you to create ...