Latest Blog Posts

How to Use Solver in Excel (with Detailed Steps)

The solver tool is used to find an optimum value for a formula in one cell, by changing decision variables. While solving linear programming problems ...

How to Make Negative Numbers Red in Excel (4 Easy Ways)

Let's use a dataset (B4:D8) in Excel that contains the Main Balance, Transaction and Present Balance. We can see 3 negative numbers in cells C5, C6, ...

Excel Pivot Table Calculated Field (How to Insert & Edit)

When you are using Pivot Tables, you can use calculated fields as a way of making your own custom calculations. In this article, we shall learn ...

How to Use IF Function with Multiple Conditions in Excel

We have already seen, how to use the IF function in basic Excel formulas. Using the IF with other functions together, in a complex formula, allows ...

How to Make Excel Graphs Look Professional (15 Useful Tips)

Creating charts and graphs is basically about ensuring effective visual communication and presentation of your data. Excel provides default graph ...

How to Format Excel to Print (13 Simple Tips)

In this article, you will learn how to format an Excel spreadsheet to print. I’m sure these tips will help print your data more professionally. You ...

What Is the Order of Operations in Excel (An Ultimate Guide)

Everything in this world run in order. In terms of working with Microsoft Excel, you also need to maintain the order of operations. Understanding the ...

How to Extract Data from Website to Excel Automatically

Extracting data (data collection and update) automatically from a web page to your Excel worksheet might be important for some jobs. Excel gives you ...

Excel Sparklines: Simplifying Data Trend Analysis in a Single Cell

Excel Sparklines are compact versions of line or column graphs in a single cell. In this Excel tutorial, you will learn about Excel sparklines. ...

How to Use Substring Functions in Excel (Types and Examples)

Usually, we need to work with substring functions in Excel. This is a guide that will let you how to separate, split, and remove substrings and ...

How to Import Data from Website to Excel with VBA Code

The key advantage of importing data from a website to Excel is the ability to routinely evaluate data in Microsoft Office Excel without having to ...

How to Create a Database in Excel

Step 1- Enter Data The fields in this database are StdID, StdName, State, Age, and Department.   Insert the data: StdID: 1510060, ...

How to Import Data from Word to Excel (3 Easy Methods)

Often while working with Excel, we need to import data from different sources. These sources may include Word files which is another commonly used ...

Sequencing problem using Johnson’s algorithm of scheduling n-jobs on 2-machines [Sol]

Almost two weeks ago, Jagadeesh asked me if I can explain how to solve the sequencing problem using Johnson’s algorithm of scheduling n-jobs on ...

22 Limitations of Excel 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 ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo