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” )))

dca Course
All Videos List

Ch - 1 What is Computer ?

Ch - 2 What is Input and output ?

Ch - 3 What is Hardware ?

Ch - 4 What is Software ?

Ch - 1 Create flag

Ch - 2 Create Lotus Flower

Ch - 3 Resize And Crop Image And Paint Menu

Ch - 4 Create SBI And HDFC Logo

Ch - 1 Introduction to Wordpad

Ch - 2 Subscript Superscript And Bullets And Number

Ch - 3 Create Calendar in WordPad

Ch - 4 Find Replace Save and Save As

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

Ch - 1 Overview of Tally Prime Course

Ch - 2 What is Accounting and Accountancy ?

Ch - 3 Basic Accounting Terms Part 1

Ch - 3 Basic Accounting Terms Part 2

Ch - 4 What is Account

Ch - 5 Journal Entry Part 1

Ch - 5 Journal Entry Part 2

Ch - 6 Journal Entry With Discount

Ch - 7 How to Download and Install Tally Prime

Ch - 8 Company Creation

Ch - 9 Company Creation with Password

Ch -10 How to Manage Multiple Companies

Ch -11 What is Ledger and How to Create Ledger in Tally Prime

Ch - 12 How to Create Voucher Entry in Tally Prime

Ch - 13 Cash Book Entry In Tally Prime

Ch -14 Cash Book Entry with Discount

Ch-15 Stock Item Creation in Tally Prime

Ch-16 Cash and Credit Sale Entry With Invoice Bill

Ch-17 Cash and Credit Purchase Entry in Tally Prime

Ch - 18 Cash and Trade Discount Entry in Tally Prime

Ch -19 Maintain Balance Bill by Bill in Tally Prime

Ch - 20 Sale Return and Purchase Return Entry

Ch - 21 Sale and Purchase Entry With GST

Ch - 22 Sale and Purchase Services With GST

Ch - 23 Create Voucher Type In Tally Prime and Know GSTR 1 GSTR 2 GSTR 3 Return File

Ch-24 Create Invoice Bill In Multiple Currency in Tally Prime

Ch - 25 Buy 1 Get 1 Free Entry in Tally Prime

Ch - 26 Set Company logo on Invoice Bill in Tally Prime

Ch - 27 Maintain Multiple Locations and Stock Transfer in Tally Prime

Ch - 28 Create Salary Slip Using Payroll in Tally Prime

Ch - 4 Tally Software Downloading And Installing

Ch - 5 Company Setup

Ch - 6 Groups And Ledgers

Ch - 7 Voucher Entry

Ch - 8 Cash Book Entry

Ch - 9 Cash Book Entry With Discount

Ch - 10 Create Stock Item

Ch - 11 Create Stock Item With Voucher Entry

Ch - 12 Cash And Trade Discount Entry

Ch - 13 Sales Entry

Ch - 14 Sales Entry Task

Ch - 15 Purchase Entry

Ch - 16 Purchase Entry Task

Ch - 17 Maintain Balance Bill By Bill

Ch - 18 Sale Return And Purchase Return

Ch - 19 Sale Entry With GST Group Wise

Ch - 20 Purchase Entry With GST Group Wise

Ch - 21 Sales Entry With GST Item Wise

Ch - 22 Purchase Entry With GST Item Wise

Ch - 23 Purchase Services With GST

Ch - 24 Sale Services With GST

Ch - 25 Sale And Purchase Return with GST

Ch - 1 HTML Overview

Ch - 3 HTML Versions And Element

Ch - 4 HTML Doctype Declarations and Typography Tags

Ch-5 HTML Document Formatting and Preformatting

Ch-6 HTML Formatting Tags

Ch - 7 HTML Attributes

Ch-8 HTML graphics coding and editing with Photoshop

Ch - 9 HTML Live Project Part 1

Ch - 9 HTML Live Project Part 2

Ch - 9 HTML Live Project Part 3

Ch - 9 HTML Live Project Part 4

Ch - 10 HTML Sub page Creation

Ch - 11 HTML with Photoshop Animation

Ch - 12 HTML Web App Task

Ch-13 HTML Advanced multimedia with plugin tags

Ch-14 HTML Lists Tag

Ch - 15 HTML Table Tag

Ch-16 HTML Table Live Project Part 1

Ch-16 HTML Table Live Project Part 2

Ch-16 HTML Table Live Project Part 3

Ch-16 HTML Table Live Project Part 4

Ch - 17 HTML Form

Ch - 18 HTML Form Design

Ch - 19 HTML Form Methods and Actions

Ch - 20 HTML Complete Form

Ch - 21 HTML Entity

Ch - 22 HTML Important Video