ASM Arman

The Excel file contains information about students from different countries in a university. The Country is color-coded. The image below shows the count of ...

Let’s assume a scenario where we have an Excel file that contains information about the employees of a company, including the Name, Age, Gender, Date of Birth, ...

After filtering data using the auto filter in Excel, we need to copy visible cells only without a header. We can do this very easily using the VBA macro in ...

While concatenating two or more pieces of text in Excel, different number formats like currency, decimal format, and percentage format are removed and displays ...

Download Practice Workbook Download the practice workbook to exercise. Convert Column to List.xlsm The dataset contains information about ...

The Excel file contains information on the time 6 cyclists took to complete a cycling contest. They are ranked in ascending order. Method 1 - Use ...

Theoretically and even practically, it is not possible to find the percentage change for negative numbers. There are different formulas that can be used, but ...

To calculate the interest on a credit card you need to know the Current Balance, Minimum Payment Percentage, and Annual Interest Rate. This is the credit ...

Method 1 - Calculate Average Percentage Change Using Formula We can use the formula for average percent change to calculate the change in sales between two ...

Sometimes in Excel, we like to use the 4 arrow keys to move between cells if we are working with a large worksheet with a lot of columns and rows. Activating ...

Consider the worksheet below, which contains the results of a sporting contest. We have the Names of the participants, their Scores, their Times, and their ...

By default gridlines of a worksheet do not appear when we print it. But gridlines, rows, and column headings could be very useful to go through the data in a ...

Formula 1 - Merging Multiple Cells Using the Merge & Center Feature in Excel The dataset has a text “Merge and Center in Excel” in cell B2. We will merge ...

While working with dates, months, or years in Excel you might need to sort the rows of the worksheet in chronological order based on this information. You ...

The image below shows the worksheet that we are going to work with. Method 1 - Add Blank Spaces Trailing Text Values in Excel We'll use the ...