Excel beginners Course
Excel Beginners Course
January 6, 2018
Excel advance Course
Excel Advanced Course
January 6, 2018
1
Excel intermediate Course

Netrut excel Course for intermediate

These Excel training videos are made for you in Hindi and English language so that you can learn in the language of your chose. You can watch these videos at your convenience and on any type of device, be it desktop, laptop or mobile. The aim of these videos is to help you learn the topic of your choice in a fun manner and at your own pace.

Course Information

Estimated Time: 3 Days

Difficulty: Intermediate

Categories:

Course Instructor

admin admin Author
 

Excel Intermediate Course

₹99.00
 
Enroll

Excel Logical Values

TRUE and FALSE

Back to: Excel Intermediate Course Back to Course Excel Intermediate Course Next Lesson Logical operators in Excel

What will you learn in this Lesson ? […]
Logical operators in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? Use of logical operators and functions in Excel excel formula greater than or […]
Logical functions in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? How to use the IF function in Excel What is not a comparison operator […]
AND Function in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? What is use of AND( ) Function in Excel MS Excel: How to […]
OR and NOT Functions in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? Use the Excel OR( ) Function Correctly How to use the Excel NOT […]
NOT Function in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? EXCEL logical functions : the NOT function Using A “Does Not Equal” Operator […]
If with Logical Functions in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? excel logical operators excel logical operators in conditional formatting excel logical operators between […]
Formatting a Cell as Text in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? What is cell format How to format a cell in Excel How to make number […]
Excel using an Apostrophe (‘)

Back to: Excel Intermediate Course

What will you learn in this Lesson ? Adding Appostrophe in every field in particular column for excel How to remove […]
Ignoring Numbers in Calculations

Back to: Excel Intermediate Course

What will you learn in this Lesson ? How to sum / average ignore negative values in Excel Formula to ignore […]
Other Logical Functions: ISBLANK in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? MS Excel: How to use the ISBLANK Functions Excel “ISBLANK” function With “IF” […]

Errors in Formulas

Common Excel Errors Values

Back to: Excel Intermediate Course

What will you learn in this Lesson ? How to find duplicate values in excel What does value mean in Excel […]
Excel Using the IFERROR Function

Back to: Excel Intermediate Course

What will you learn in this Lesson ? What is if error in Excel What is the ISNA function in Excel […]
Auditing for Excel Formula Errors

Back to: Excel Intermediate Course

What will you learn in this Lesson ? how to learn ms excel formulas and functions What is the meaning of […]

Excel Formulas

Sum function in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? Entering Simple Functions and Use AUTOSUM in an Excel Worksheet how to […]
Sum Formula Terminology in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? How to total a column in Excel How to add in Excel How to use […]
Max & Min Functions in Excel

Back to: Excel Intermediate Course

What you will learn in this Lesson The minimum value using Excel MIN( ) Function Use Excel MAX( ) Function to […]
MS Excel: How to use the VLOOKUP Function

Back to: Excel Intermediate Course

How to use the Excel VLOOKUP function Syntex ‘=VLOOKUP (value, table, col_index, [range_lookup])

Previous Lesson Max & Min Functions in Excel […]
Looking Up Values Using the HLOOKUP Function in Excel

Back to: Excel Intermediate Course

MS Excel: How to use the HLOOKUP Function Major difference between HLOOKUP and VLOOKUP functions is the way lookup tables are […]
Excel Index

Back to: Excel Intermediate Course

How to use the Excel INDEX function Definition The IF function will ……) Tips: Until ..

Previous Lesson Looking Up […]
Excel IF Function

Back to: Excel Intermediate Course

How to use the Excel IF function The IF function will check the logical condition of a statement and return one […]
Parameters for IF function in Excel

Back to: Excel Intermediate Course

How to use the Excel IF function IF function IF with a numeric result

Previous Lesson Excel IF Function
How […]
Working with Logical Functions in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? Microsoft Excel Logical Functions Excel OR: How to use logical functions in Excel […]
How to Use COUNTIF Function in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? Using COUNTIF( ) Function in Excel MS Excel: How to use the COUNTIF […]
How to use the SUMIF function in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? What is Sumif Learn Using SUMIF to add up cells in Excel that […]
How to use the AVERAGEIF function in Excel

Back to: Excel Intermediate Course

What will you learn in this Lesson ? The AVERAGE( ) Function is used to Calculate… AVERAGEIF Function in Excel Formulas […]