## How to show the Developer Tab on the Ribbon

When you're planning to work with VBA macros, you've to make sure that the Developer tab is present on the Excel Ribbon. The Developer tab does not appear by default. Developer tab contains useful ...

## What You Can Do with VBA

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. VBA is a very rich programming language. It has thousands of uses. A few things are listed below that you ...

## Introduction to VBA Macros

Here I am starting introducing you with the Visual Basic for Applications (VBA) macro language. VBA is a key component. Excel users use VBA macros to customize and automate Excel. This chapter will ...

## Optimizing an investment portfolio using Excel Solver

This article is part of my series: Excel Solver Guide (Easy and Step by Step). In our this example, we're going to demonstrate how to use Solver to get maximum return from an investment portfolio. A ...

## Resource Allocation Model in Excel Using Solver

In this article, you will learn how to build a resource allocation model in Excel using the solver. Our motto is always making the best uses of available resources with the highest output. This ...

## SUMPRODUCT() function in Excel

SUMPRODUCT function: Syntax  SUMPRODUCT (array1, , , ...) SUMPRODUCT function: Example Example: =SUMPRODUCT(A2:B4, C2:D4). This example say that components (A2, A3, A4, B2, B3, and B4) of Array1 ...

## If Excel doesn’t show the Solver command

This article is part of my series: Excel Solver Guide (Easy and Step by Step). You can access Solver by choosing Data ➪ Analysis ➪ Solver. Sometimes it may happen that this command isn't available, ...

## Minimizing shipping costs in Excel using Solver

This article is part of my series: Excel Solver – A Step by Step Complete How-to-use Guide. In our this example, we're going to find alternative options for shipping materials keeping total shipping ...

## How to solve simultaneous linear equations in Excel using Solver

In this blog post, I will show you how to solve simultaneous linear equations in Excel using solver add-in. You can also use Excel Matrix functions (MMULT, MINVERSE) to solve linear equations. That ...

## Excel Solver with a Simple Example (Step by Step)

In this article, we're going to use a simple example to introduce you to Solver technique and then in next article, we'll present some complex examples to explain what this feature can do for you. ...

## Goal Seek in Excel 2013 – How to Use Guide

In this tutorial, you will learn single cell goal seek in Excel 2013. I have used a "mortgage loan" example to demonstrate the whole process. Goal Seek feature is one way to do Reverse What If ...

## Reverse What-If Analysis in Excel

In our this series of articles: What-If Analysis in Excel, we have discussed what-if analysis— the process of changing values of input cells to observe the results on other dependent cells. This ...

## How to Do Scenario Analysis in Excel (with Scenario Summary Report)

How to do scenario analysis in Excel? How to generate scenario summary report using Excel scenario manager feature? You will learn all these crucial data analysis topics in this article. So, let's ...