Latest Posts

How to create VBA Macros in Excel using Macro Recorder

This is a long article on how to create VBA macros in Excel. So, study this tutorial part by part at your own pace. In two ways you can create ...

Two types of VBA Macros: VBA Sub procedures & VBA functions

Before we digging into how to create macros, we need to understand the types of VBA macros. This article is part of my series: Excel VBA & ...

How to save workbooks that contain Macros

If your workbook contains one or more VBA Macros, you must save the file with an XLSM extension. This article is part of my series: Excel VBA & ...

About Macro Security in Excel

Macros can cause serious damage to your computer. It can erase files or install malware. Microsoft has added macro-security features to help prevent ...

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

What You Can Do with VBA

VBA is a very rich programming language. It has thousands of uses. A few things are listed below that you can do with VBA macros. Insert ...

Introduction to VBA Macros

Here I am starting to introduce you to the Visual Basic for Applications (VBA) macro language. VBA is a key component. Excel users use VBA macros to ...

Optimizing an investment portfolio using Excel Solver

This article is part of my series: Excel Solver Guide (Easy and Step by Step). In this example, we're going to demonstrate how to use Solver to get ...

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

SUMPRODUCT() function in Excel

SUMPRODUCT function: Syntax  SUMPRODUCT (array1, , , ...) SUMPRODUCT function: Example Example: =SUMPRODUCT(A2:B4, C2:D4). This example says ...

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

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 this example, we're going to find alternative options ...

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

Excel Solver with a Simple Example (Step by Step)

In this article, we're going to use a simple example to introduce you to the Solver technique, and then in the next article, we'll present some ...

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

ExcelDemy
Logo