Prantick Bala

In the sample dataset we only want to print a portion of the content.     Method 1 - Set Print Area From Page Layout Tab Select the ...

You have sales data of different salesmen in the “Sales Data” sheet of the “Reference Workbook” workbook. To extract “Yearly Sales” from the Reference ...

We'll use the following dataset to try to insert a new column to add some additional data. We will show you why you can't insert a column in this dataset and ...

Method 1 - Shortcut to Add Hyperlink in Excel The easiest way to add hyperlinks in Excel is to use a shortcut keyboard command. First, ➤ Select the cell ...

We'll use the following sample dataset to highlight a row whenever we select a cell in that row. Method 1 - Highlighting the Active Row by Using ...

Panes allow you to freeze one portion of your Excel datasheet and scroll the other portion separately. Though it is a useful feature, you may need to remove ...

Consider you have the following dataset with a Header. The dataset also has a Footer. Let's remove the Header and Footer from this dataset. ...

Excel VBA LTrim function removes leading space from a string. This function is used to develop a Macro to remove leading spaces from a specific text. By the ...

VBA Randomize function is an inbuilt Math or Trigonometry function of Excel which allows you to change the seed value used by the random number generator of ...

The VBA Val function is an Excel Text function which converts a text string into a numeric value. You can use this function in a VBA code to get the starting ...

We'll use the following dataset to showcase possible errors with pivot table names and how to solve them. Reason 1 - Missing Data in Any Cell of the ...

Method 1 - Create Table with Keyboard Shortcut Key ➤ Select the Entire dataset and press the following keys, CTRL+T The Create Table window will ...

Depreciation describes how an asset's value decreases over time. A Depreciation Schedule is a table that displays the amount of depreciation for a fixed asset ...

Hotel Bill format is an invoice format that you can use to create hotel bills for clients in order to document information about hotel services as well as ...

We'll use this dataset to demonstrate what actions to take when the COUNTIFS function doesn’t work properly. Download the Practice Workbook Not ...