Excel Basics

Excel Timesheet Formula with Lunch Break (3 Examples)

In this article, we will apply timesheet formulas in different time formats that take different kinds of lunch breaks into account. Example 1 ...

How to Delete Unused Rows in Excel (8 Methods)

Dataset Overview We have a dataset where users input Product Sale data. Somehow users leave unused or blank rows while entering data in the dataset ...

How to Format a Cell in Excel with VBA (12 Ways)

Method 1 - Format Cell Horizontally or Vertically with VBA Excel’s CellFormat. The AddIndent property sets a Variable type value that indicates ...

Dealing with Time Format in Excel (5 Suitable Ways)

In Excel time and date is stored as a regular number which is known as date serial number. But we can use the formatting features of Excel to display ...

How to Adjust Column Width in Excel (7 Ways)

The column width in Excel does not automatically change if the data you enter in the cell is too large to fit in the column. Either it will overlap ...

How to Use Phone Number Format in Excel (8 Examples)

If you are looking for some of the easiest ways for Excel phone number format, then you are in the right place. By following this article, you will ...

Applications of Excel Fill Series: 12 Easy Methods

Method 1 - Fill a Linear Series in Excel in a Column Select cell D5. Drag the Fill Handle tool to cell D10. From the dropdown of the ...

How to Fix If Break Links Aren’t Working in Excel (7 Solutions)

  To see if the Break Links aren't working, go to the Data tab. From the Queries & Connections group, click on Edit Links. You will ...

Shortcut for Merge and Center in Excel (3 Examples)

To illustrate, we have a data table with two columns and the title of the table in a single cell. Example 1 - Shortcut for Merge & ...

Create GST Invoice Format in Excel: 4 Methods

Method 01 - Making an Outline of GST Invoice Format 1. We need to have the basic inputs such as the Product Details in the product sheet and the ...

How to Use COUNTIF for Unique Text (8 Easiest Ways)

We'll use a sample dataset of sales information. The dataset contains two columns: Sales Person and Sales. Let's extract the unique values. ...

How to Apply Custom Format Cells in Excel (17 Examples)

To apply a custom format in Excel: Select the cell or range you want to format. Press Ctrl + 1 to open the Format Cells dialog box. In the ...

How to Delete Excel Sheet Using VBA (10 VBA Codes)

Microsoft Excel VBA (Visual Basic for Applications) is such a tool that you can do any operation in Excel using it. We can simply delete sheets ...

How to Use Cell References in Excel Formula (All Possible Ways)

Method 1 - Use of Relative Cell Reference in Formila in Excel  Steps: In cell F5, write the following formula to calculate the Price as a ...

How to Use AutoFit Shortcut in Excel (3 Suitable Methods)

Method 1 - Apply the Keyboard Shortcuts to AutoFit in Excel In our dataset, we can apply AutoFit by using the keyboard shortcuts in two ways. The ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo