Latest Blog Posts

How to Use Do Until Loop in Excel VBA (with 2 Examples)

In this article, we will explain how to use the Do Until Loop in Excel VBA with two simple examples. What Is a Loop? A Loop is a programming ...

Changing Case using Worksheet Functions and Excel VBA

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function, and the Proper Function, which can change the case of a ...

How to Use For Next Loop in Excel VBA (10 Suitable Examples)

A loop is used when we need to run an operation repeatedly. Without performing the same operation manually every time in Excel, we can apply the VBA ...

Exchange (Copy, Import, Export) Data Between Excel and Access

Excel usage is widespread and Excel is often the go-to Office application for data entry, analysis, and manipulation. Microsoft Access provides ...

Comparison Among MAX vs MAXA vs LARGE and MIN vs MINA vs SMALL Functions in Excel

Introduction of MAX, MAXA, LARGE, MIN, MINA, and SMALL Functions 1. MAX Function The MAX function in Excel is used to return the maximum value from ...

IF & AND Functions in Excel VBA to Test Multiple Conditions

We have already seen how to use the IF & AND worksheet Functions to test multiple conditions, in a previous tutorial. We are now going to see how ...

How to Use Select Case Statement in Excel VBA (2 Examples)

Download Practice Workbook Select Case Statement.xlsm Using the sample dataset below, we will illustrate two examples to use the Select ...

Difference Between Protect Sheet and Protect Workbook in MS Excel

  What Are Protect Sheet and Protect Workbook in Excel? In Microsoft Excel, the feature that prevents other users from accidentally or ...

How to Use CEILING.MATH and FLOOR.MATH Functions in Excel

Excel CEILING.MATH Function: Syntax and Arguments Summary: The CEILING.MATH function rounds a specified number up to the nearest integer or ...

All Types of Round Functions in Excel (15 Functions)

Excel provides multiple functions for rounding numbers in one’s worksheet. The most often utilized are the ROUND function, the ROUNDUP function, the ...

3D Referencing & External Reference in Excel

What Is 3D Referencing in Excel? In Excel, you can use the 3D reference feature to select the same cell from multiple worksheets. By simply ...

NOW vs TODAY Functions in Excel (3 Practical Examples)

We have a spreadsheet showing some data of an employee working for a company. Details such as the employee’s name, department, and total sales are ...

How to Print Excel Spreadsheet with Lines and Change Its Color

Download the Practice workbook Printing Spreadsheet with Lines.xlsx 2 Ways to Print Excel Spreadsheet with Lines and Change Its Color We ...

How to Reference Excel Tables Using VBA (20 Examples)

Reference a Table with ListObject Property When writing VBA code, ListObjects are essential for referring to Excel tables. These tables can be ...

How to Create A Doughnut, Bubble and Pie of Pie Chart in Excel

Most of us are familiar with standard Excel chart types such as a pie chart, a column chart, and a line chart, as well as the types of data they are ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo