Online Classroom

Ch - 3 Adv IF Condition And Statement And Home Tab

Notes Downloading link

IF function is used for applying condition.

Syntax :- if(condition,true,false)

IF(2>3 , TRUE , FALSE )

Condition = Those who have more than 33 percent get a pass and those
who have come down from 33 get a fail.

If(percentage >= 33,”Pass”,”Fail”)

Adv. If Condition
Condition : -
80 > A
60 > B
50 > C
50 < D
IF( PER > 80 , ”A” , IF( PER > 60 , ”B” , IF( PER > 50 , ”C” , ”D” )))

ms office Course
All Videos List

Ch - 1 Format Painter And Change Case

Ch - 2 Types of Alignment And Line Spacing

Ch - 3 Insert Table And Create Ads with Table

Ch - 4 Insert Picture And Change Photo Background

Ch - 5 Insert Shapes And Customize Shape Fill

Ch - 6 Insert Text box And Create Cover Page

Ch - 7 Create Template in Ms Word

Ch - 8 Insert Smart Art Graphics And Chart And Hyperlink And Header Footer

Ch - 9 Page Layout Menu

Ch - 10 References tab And Footnote Endnote And Table of Contents

Ch - 11 References And Insert Caption

Ch - 12 Mailings Tab And Envelopes And Labels

Ch - 12 Part 2 Mailings Tab in Ms Word

Ch - 13 Review Tab And Spelling grammar And track Changes

Ch - 14 View Tab

Ch - 15 Practical Test

Ch - 1 Introduction to Ms Excel

Ch - 2 IF Condition And Statement

Ch - 3 Adv IF Condition And Statement And Home Tab

Ch - 4 Create Table Program In Excel

Ch - 5 Conditional Formatting in detail

Ch - 6 Conditional Formatting in detail Part 2

Ch - 7 Format option In Home tab

Ch - 8 Pivot Table And Insert Tab

Ch - 9 Page layout Tab And How to Setup Excel Sheets for Print

Ch - 10 Basic to Adv Formula Part - 1

Ch - 11 Basic to Adv Formula Part - 2

Ch - 12 Basic to Adv Formula Part - 3

Ch - 13 Lookup and Vlookup and Hlookup Function

Ch - 14 Create Invoice Bill Part - 1

Ch - 14 Create Invoice Bill Part - 2

Ch - 15 Picture Lookup

Ch -16 Define Name And Name Manager

Ch - 17 Create Age Calculator

Ch - 18 Formula Auditing

Ch - 19 Data Tab

Ch - 20 Data Tool And Consolidate And What if Analysis And Data Validation

Ch - 21 Review Tab

Ch - 22 Calculation of EMI Using PMT And IPMT And PPMT Functions

Ch - 23 View Tab

Ch - 1 Introduction to PowerPoint

Ch - 2 Create CountDown

Ch - 3 Rabbit Animation

Ch - 4 Create Maze Game

Ch - 5 Home Tab

Ch - 6 Insert And Design Tab

Ch - 7 Transition And Animation

Ch - 8 Slide Show Tab

Basic Computer Course Ke Baad Kon Sa Course Kre