Latest Blog Posts

How to Randomly Select from a List in Excel (5 Methods)

Our sample dataset represents participants in a lottery. We'll randomly select a winner. Method 1 - Using the INDEX and RANDBETWEEN ...

Excel VBA: Zoom to Fit Screen (4 Suitable Examples)

If you are looking for ways to zoom in to fit a screen using VBA in Excel, then you will find this article helpful. By using the VBA codes of this ...

How to Unhide Very Hidden Sheets in Excel (2 Effective Methods)

Sometimes your worksheet may contain confidential information and in that case, hiding your worksheet may be one of the best options. Excel also ...

How to Convert Decimal to Time in Excel Using Formula

Excel by default stores time in decimal format. This tutorial will demonstrate how to convert decimal format to time format in Excel using formulas. ...

How to Create a Monthly Staff Attendance Sheet in Excel (With Easy Steps)

This dataset contains information about employees. Using this dataset, we will create a monthly staff attendance sheet in Excel in 7 easy steps. ...

How to Tab to Certain Cells in Excel (2 Easy Ways)

Sometimes, when filling out a form in Excel, the data entry cells may be scattered across the worksheet. Therefore, we want an easy way to go through ...

How to Add Header in Excel (5 Quick Methods)

In this article, we will discuss some methods to add a header in Excel. We can insert a header on each page of our Excel worksheet, which typically ...

How to Repeat Rows in Excel at Bottom: 5 Easy Methods

Method 1 - Use of Fill Handle Icon to Repeat Rows in Excel at Bottom Steps: Select the row up to which cell you want to repeat the values. We ...

What is an Unqualified Structured Reference in Excel?

The image below differentiates a Structured Reference from an Explicit Reference. Structured Reference and Its Types Structured ...

How to Write 00 in Excel (11 Easy Ways)

Users can't automatically input numbers with 00 at the front in Excel, but there are ways to go around that restriction. We will consider the ...

How to Open XML File in Excel (2 Easy Ways)

The Extensible Mark-up Language is known as XML. This dialect is comparable to HTML.  A mark-up language really employs tags to define text and is a ...

How to Calculate the Present Value with Different Payments in Excel – 5 Examples

Example 1 - Calculate the Present Value for a Single Payment The sample dataset (B4:C8) showcases the annual interest rate, No. of years and the ...

How to Exit Full Screen in Excel – 3 Methods

Method 1 - Using the Context Menu to Exit Full Screen Steps: Right-click anywhere in the workbook. Select Close Full Screen. ...

Excel VBA: Add Sheet After Last (3 Ideal Examples)

Sometimes, you might add an Excel sheet after the last for the convenience of your work. Adding an Excel sheet after the last is an easy task. This ...

How to Do One Way ANOVA in Excel (2 Suitable Examples)

ANOVA provides a perfect opportunity to evaluate which factor has the most significant effect on a given set of data. It stands for analysis of ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo