Menu
×
Tutorials Ms Word Tutorial Ms Excel Tutorial Ms PowerPoint Tutorial C Language Tutorial C++ Tutorial C Sharp Tutorial Visual Basic Tutorial HTML Tutorial CSS Tutorial JavaScript Tutorial WordPress Tutorial
     ❯   

How to use Logical Or comparison operators In Excel | Understand Operators

Ms Excel / By / 1 minute of reading

Note: If video does not play,just refresh page and then Play video or Just Click on this text. Comparison operators You can compare two values with the following operators. When two values are compared by using these operators, the result is a logical value—either TRUE or FALSE. Comparison operator Meaning Example = (equal sign) Equal …

How to use Logical Or comparison operators In Excel | Understand Operators Read More »

How to use Arithmetic Operators in Excel | Understanding Operators

Ms Excel / By / 1 minute of reading

Note: If video does not play,just refresh page and then Play video or Just Click on this text. Arithmetic operators To perform basic mathematical operations, such as addition, subtraction, multiplication, or division; combine numbers; and produce numeric results, use the following arithmetic operators. + (plus sign) Addition =3+3 – (minus sign) SubtractionNegation =3–3=-3 * (asterisk) …

How to use Arithmetic Operators in Excel | Understanding Operators Read More »

How to Protect work Book with Password in Excel | Set Password on workbook | Protect Workbook

Ms Excel / By / 1 minute of reading

Note: If video does not play,just refresh page and then Play video or Just Click on this text. For optimal protection, files can be encrypted with a password. When someone tries to open the document, Excel first prompts for the password. To configure, open an Excel file and go to the File menu. By default, the About category is displayed. Click the Protect Workbook button and select Encrypt with Password from the dropdown menu.

How to copy sheet with data to new workbook in excel | Copy Worksheet

Ms Excel / By / 2 minutes of reading

Note: If video does not play,just refresh page and then Play video or Just Click on this text. There are many occasions when you need to create a new spreadsheet based on an existing spreadsheet or move tabs from one Excel file to another. For example, you can back up important worksheets or make multiple copies of the same sheet for testing purposes. Luckily, there are some easy and quick ways …

How to copy sheet with data to new workbook in excel | Copy Worksheet Read More »

How to Generate Random Numbers In Excel | Dummy Records

Ms Excel / By / 1 minute of reading

Note: If video does not play,just refresh page and then Play video or Just Click on this text. There are two functions designed to generate random numbers in Excel: RAND and RANDBETWEEN.The RANDBETWEEN function provides random numbers, but results are more likely to be repeated.The RAND function is more likely to produce non-repeating results. However, there are only random numbers between 0 and 1. You can use this with RANK …

How to Generate Random Numbers In Excel | Dummy Records Read More »

How to Add Same Data into multiple cells in excel | Same Data in different Cells

Ms Excel / By / 1 minute of reading

Note: If the video does not play,just refresh the page and then Play the video or Just Click on this text. This quick tip shows you how to quickly enter the same formula or text in multiple Excel cells at the same time. This is very useful when you need to paste a formula into all cells of a column, or fill all empty cells in a table with the same value (e.g. “N/A” ). Both tricks work in Microsoft Excel 365, 2019, …

How to Add Same Data into multiple cells in excel | Same Data in different Cells Read More »

How to use Conditional Formatting in excel | Format | Conditions

Ms Excel / By / 2 minutes of reading

Note: If video does not play,just refresh page and then Play video or Just Click on this text. Why Conditional Formatting is Important In Ms Excel? Conditional formatting helps make patterns and trends in your data more apparent. To use it, create a rule to format cells based on their value, like monthly temperature data with cell colors associated with cell values. 1. …

How to use Conditional Formatting in excel | Format | Conditions Read More »

Scroll to Top
Scroll to Top