Excel Tutorial | Learn Cybers

Excel Tutorial

Excel Logical Test Using Multiple If Statements [OR/AND]

ByNick AnonymousDecember 11, 2019

To test certain conditions, people use If statement. The If() function is used to perform logical tests and to evaluate conditions that will show two outcomes. This excel if statement is used to analyze a condition that will show two outcomes. Basically, excel logical test

Excel Tutorial

How to Compare Two Columns in Excel using If, Conditional Formatting, Vlookup

ByNick AnonymousDecember 11, 2019

Recently, one of my students raise the query “How to compare two columns in excel?” There are many ways to perform compare two columns in excel including Vlookup function in excel, Conditional formatting, If Statement, and other simple methods. Depending on your

Excel Tutorial

How to Use SumIfs Function in Excel [Multiple Criteria]

ByArslan ud Din ShafiqDecember 11, 2019

The SumIf function returns the summation of all the numbers who met the particular criteria. You have to use this SUMIF function in Excel which is also known as worksheet function. The function is used to add the value of all the cells depending on date, text, and numbers.

Excel Tutorial

Excel Functions List: You Must Know

ByArslan ud Din ShafiqDecember 11, 2019

Microsoft Excel has many in-built Excel functions list that let you perform calculations and return information about the spreadsheet. These in-built functions are used for performing complex calculations. Here you can see in-built functions for MS Excel that you can use for

Excel Tutorial

Excel Formulas Basic Functions like Sum, Average

ByArslan ud Din ShafiqDecember 11, 2019

Excel Formulas Basic Function: The formula is a unique code which you can enter into the cell. The formulas will let you perform calculations and will give you an exact outcome. In formulas, you will find various operators and functions that you can use on values and text.

Excel Tutorial

How to use Excel If statement multiple conditions range [OR/AND]

ByArslan ud Din ShafiqDecember 11, 2019

To perform complicated and powerful data analysis, you need to test various conditions at a single point in time. The data analysis might require logical tests also within these multiple conditions. For this, you need to perform Excel if statement multiple conditions range

Excel Tutorial

Create Dropdown List in Excel Cell [Best 1]

ByArslan ud Din ShafiqDecember 11, 2019

With the drop-down list, you can help people work efficiently. He or she can pick items from the list easily. So if you want to create dropdown list in excel, then do follow the step-by-step process and create the drop-down list easily. In fact, you can add and remove items

Excel Tutorial

Excel Tables Tutorial for beginners – How to create table?

ByArslan ud Din ShafiqDecember 10, 2019

The table converts your data list into Excel tables that consist of many features by which you can sort or filter data set according to your preference. You can organize your data efficiently as well as view your data whenever you want to see. This is an excellent source to

Excel Tutorial

How to Lock Cells in Excel in Mac and Windows

ByArslan ud Din ShafiqDecember 10, 2019

If you are protecting a worksheet, then that means you are locking all the cells. You cannot perform any editing on those cells. To perform the editing of the cells, you need to unlock those cells. Now you must be in a hurry to know how to lock cells in Excel so they don’t