Online Classroom

Ch - 10 Basic to Adv Formula Part - 1

Notes Downloading link

=NOW()
=WEEKDAY(A2)
=TODAY()
=WEEKNUM(A2)
=DATE(2021,6,9)
=MAX(C1:C8)
=YEAR(A3)
=MIN(C1:C8)
=MONTH(A3)
=COUNT(C1:C8)
=DAY(A3)
=COUNTIF(C1:C8,5)
=TIME(21,8,20) 
=LARGE(C1:C8,3)
=MINUTE(A7)
=SMALL(C1:C8,2)
=HOUR(A7)
=COUNTBLANK(G7:G13)
=SECOND(A7)
=AVERAGE(C1:C8)

adca 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 ?

Management of Files And Folders

How to Transfer Your File Phone to Computer

How to SET UPDATE and REMOVE Password in Windows 10

How to set Password in computer

How to Remove Password From Window 7

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 Part 1 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

How to Insert Rupee Symbol in Ms Word

Basic Computer Shortcut Keys

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

How to do Data Entry in Excel

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

How to Send Email from Mobile

How to Create Resume in Mobile

Learn Typing in Mobile

How To Use Your Smartphone as WEBCAM

How to Uninstall Software in Windows 10

This PC Icon on Desktop Windows 10

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 - 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 - 1 Introduction to Photoshop

Ch - 2 Shapes and Clipping Mask

Ch - 3 Image Selection using Marquee Tool

Ch - 4 Image Selection using Lasso and Magic Wand Tool

Ch - 5 How to Remove Background and Image Selection using Pen Tool

Ch - 6 Masking and Image Selection using Channels

Ch - 7 How To Create a Thumbnail For YouTube Videos

Ch - 8 How to Place a Banner Image on Bill Board

Ch - 9 How to Create a Visiting Card

Ch - 10 How To Use Patch Tool

Ch - 11 Face Smoothing and Skin Retouching

Ch - 12 How to Change Cloth Colour

Ch - 13 How to Use Clone Stamp Tool

Ch - 14 How to Remove Eyes Dark Circle

Ch - 15 How to Create a Social Media Post

Ch - 16 Crop Tool and Perspective Tool

Ch - 17 Blend If Option

Ch - 18 How to Remove Hair Background

Ch - 19 How to Create Digital Signature

Ch - 20 How to Resize and Compress Images

Ch - 21 Multiply and Screen Blend Mode in Photoshop

Ch - 22 Face Setting Using Liquify in Photoshop

Ch - 23 Convert Low Quality Photo To High Quality Photo

Ch - 24 What is Graphics

Ch - 25 How to Type Hindi in Photoshop

Ch - 26 RGB VS CMYK Full Detail in Photoshop

Ch - 27 How to Make Passport Size Photo in Photoshop

Ch - 1 Introduction To Corel Draw

Ch - 2 Type of Fills in Corel Draw

Ch - 3 Transparency Tool in Corel Draw

Ch - 4 All Draw Tools in Corel Draw

Ch - 5 Draw a Butterfly in Corel Draw

Ch - 6 Outline Customisation in Corel Draw

Ch - 7 Complete Text Tool in Corel Draw

Ch - 8 Draw The Taj Mahal in Corel Draw

Ch - 9 Create a Visiting Card in CorelDraw

Ch - 10 Visiting Card Design in CorelDraw

Ch - 11 Smart Fill Tool in CorelDraw

Ch - 12 Envelope Tool in CorelDraw

Ch - 13 Banner Design in CorelDraw

Ch - 14 3D Text Effect in CorelDraw

Ch - 15 Local Shop Banner Design in CorelDraw

Ch - 16 How to make Letterhead design in CorelDraw

Ch - 17 Types of Logo Design

Ch - 18 SBI Logo Design in CorelDraw

Ch - 19 AXIS Bank Logo Design in CorelDraw

Ch - 20 Name Logo Design in CorelDraw

Ch - 21 Distort Tool In CorelDraw

Ch - 22 Contour Tool In CorelDraw

Ch - 23 Extrude and Block Shadow Tool in CorelDraw

Ch - 24 Artistic Media Live Sketch and Smart Drawing Tool in CorelDraw

Ch - 25 How to Create Barcode in CorelDraw

Ch - 26 How to Create Photo Frame in CorelDraw

Ch - 27 How to Create Circular Logo in CorelDraw

Ch - 28 File Menu in CorelDraw

Ch - 1 Introduction to InDesign

Ch - 2 Type Tool in InDesign

Ch - 3 How to Manage Long Text in InDesign

Ch - 4 How to Design Book Chapters in InDesign

Ch - 5 How to Manage Images in InDesign

Ch - 6 How to Manage Pages in InDesign

Ch - 7 Paragraph and Character Style in InDesign

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-1 Introduction to CSS

Web Layout Design With Semantic Elements

Ch - 3 Web Layout Design With Inline Stylesheet

Ch - 4 CSS Internal Stylesheet

Ch - 5 CSS Text and Dimensional Properties

Ch - 6 CSS Selectors

Ch - 7 CSS First Live Project Part 1

Ch - 7 CSS First Live Project Part 2

Ch - 7 CSS First Live Project Part 3

Ch - 7 CSS First Live Project Part 4

Ch - 7 CSS First Live Project Part 5

Ch - 7 CSS First Live Project Part 6

Ch - 7 CSS First Live Project Part 7

Ch - 8 CSS External StyleSheet And Background Properties

Ch - 9 Metadata Installation with CSS Second Live Project

Ch - 10 CSS Second Live Project Part 1

Ch - 10 CSS Second Live Project Part 2

Ch - 10 CSS Second Live Project Part 3

Ch - 10 CSS Second Live Project Part 4

Ch - 11 CSS Properties List Part 1

Ch - 11 CSS Properties List Part 2

Ch - 12 CSS Pseudo Classes

Ch - 13 Complete CSS Pseudo Classes

Ch - 14 CSS Position Properties

Ch - 15 CSS Dropdown Introduction

Ch - 16 CSS Dropdown Menu

Ch - 17 CSS Miscellaneous selectors and properties

Ch - 18 CSS Opacity And Pseudo Element

Ch-1 Introduction to CSS3

Ch - 2 CSS3 Responsive Web Design Part 1

Ch - 2 CSS3 Responsive Web Design Part 2

Ch - 2 CSS3 Responsive Web Design Part 3

Ch - 2 CSS3 Responsive Web Design Part 4

Ch - 2 CSS3 Responsive Web Design Part 5

Ch - 3 Custom Scrollbar Designing in CSS3

Ch - 4 CSS3 Flex

Ch - 5 CSS3 Properties

Ch - 6 CSS3 Shorthand Properties Part 1

Ch - 6 CSS3 Shorthand Properties Part 2

Ch - 7 CSS3 Animation Part 1

Ch - 7 CSS3 Animation Part 2

Ch - 7 CSS3 Animation Part 3

Ch - 7 CSS3 Animation Part 4

Ch - 7 CSS3 Animation Part 5

Ch - 7 CSS3 Animation Part 6

Ch - 7 CSS3 Animation Part 7

Ch - 7 CSS3 Animation Part 8

Ch - 7 CSS3 Animation Part 9

Ch - 7 CSS3 Animation Part 10