Customise Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorised as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyse the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customised advertisements based on the pages you visited previously and to analyse the effectiveness of the ad campaigns.

No cookies to display.

Cell Reference

A worksheet also known as the spreadsheet is composed of a box-like structure called a cell. Every cell has an address location called cell reference. A cell reference consists of a column letter and row … Read more

Logical Functions

One of the best thing in Excel is to compare data in different cells, using logical functions you can easily compare each cell that you want to compare and get the output that you need. … Read more

Count and Sum Functions

Count and Sum are one of the most used functions in Excel. You can easily count or sum the content of the worksheet based on one or multiple criteria. There are 6 functions included in … Read more

Adding Password to Workbook and Worksheet

Adding password can prevent from unauthorized opening or modifying your Excel Workbook. But keep in mind that if you lose or forget your password it cannot be recovered and your workbook will be useless, so keep … Read more

Printing Sheets

Now you have a workbook full of data and you want to have a hard copy of it. You’ve printed it and it looks like a mess. Excel worksheet doesn’t look exactly the same on what … Read more