I’m Shavani, I Have Done B.Tech (IT) From SUSCET,Mohali(PB). I Have 3 Year Experienced In IT.
Now I Am Working With Akal University, Punjab.

Shavani Rani

In this course, Shivani shall be discussing how to Learning about MS-Excel conditional formulas

Courses that would help you introspect and harness your innate potential. Watch them and garner skills that would take you a notch higher.

Personal Development

Hindi

(Hindi) How to Use Conditional Formulas in MS Excel

Tips & Tricks

Knowledge & Learning

Knowledge, Learning & Leadership

Personal and Skill Development

Develop your coding skills, learn a new language or prepare for campus placements and job interviews, you can do it all with these awesome courses.

Microsoft Excel is an electronic spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.

What do you mean by Microsoft Excel with its features.

Vlookup looks at a value in one column and find its corresponding value on the same row in another column. For more details watch my video.

How to Use Vlookup Formula in MS Excel 2007 (in Hindi)

GST is a consumption based tax on sale , manufacture and consumption on goods and services at national level. SGST means State Goods Service Tax and CGST means Centeral Goods Service Tax...For more details , watch video..

How to Make GST Billing with Vlookup Formula in MS Excel 2007 (in Hindi)

This Excel Tutorial explains how to use the Excel count counta countblank function with Syntax and examples if you wish to apply these formulas so please watch this video.

Different Types of Count Formulas (in Hindi)

In this video I wanted to just explain a difference between count-if and count-ifs functions. Both functions will count items for you based on criteria you set however count-if only takes one criteria whereas count-ifs check multiple criteria.

How to use Countif/ Count ifs function in MS Excel (in Hindi)

In this video audience can understand the concept of how and why to use SUM and IF Formula in MS-Excel With example..

How to use sum and if formula in Excel

A quick way to find and search the data within one or multiple sheets in one workbook.This is a very effective and effecient way of identifying the range of cells used in one worksheet

How to Use go to Function in MS Excel 2017 (in HIndi)

Sorting allows you to organise data based on some criteria usually alphabetically(A to Z or Z to A) or numerically(lowest to highest or highest to lowest)

Tutorial on custom sort order in Microsoft Excel

In this lesson you will learn how to sort by colour and how to apply custom list in excel. You can sort by days of the week or month of the year through bicolor and with list. So watch this video how to do

Tutorial on sort by colour and custom list

Filter easy method that is used to show the selected data item in MS Excel.filter can be used on both type of data like number and text

Introduction of filter through example

The advanced filter is used to filter a dataset depending on user defined criteria means condition that can be applied to several columns of data simultaneously

Introduction of Advanced filter through example

Pivot table is a program that allows you to recognise and summarise selected column and rows of data in a spreadsheet or database table to obtain a desired report. A pivot table does not actually change the spreadsheet or database itself.

How to create pivot table in MS Excel

Tushar Mehra

This course helps in Learning to play guitar And high level musical theory in Just within 3 months.

(Hindi) Complete Guide to Guitar Extension

A mentor to 50k+ students- Anmol Sir's contribution to NEET UG is immense. Check out his classes to watch Biology unfold like never before!

Anmol Sharma

In this Session we will deal with how Unacademy helping students to achieve success in entrance exam.

(Hindi) How Unacademy Help in Learning

chemistry educator || M.Sc.-Chemistry , B.ed || 9 years teaching experince || referral code- "VISHWAUP10"|| Youtuber || JEE NEET 

Vishwa Vivek Sharma

In this course, the educator discusses a brief introduction about our famous Hindi poet Dr Kumar Vishwas. He will also present his best creation in Hindi literature.

(Hindi) Indian Poet: Dr Kumar Vishwas

Unacademy Top Educator 2017,Asst Prof-National Level Talent Search for Biotechonology(Silver Medal)

Priyanka Verma

In this course, Priyanka has discussed the strategy to choose the stream or subject after the Class 10 Examination. It's about solving biggest puzzle of students " what to choose after class 10" so that they don't regret in their later life.

(Hindi) Teachathon July 2017 - Choosing Streamline after Class 10 Examination

Pursued MS Information Management from Syracuse University, New York. Currently a Technology Consultant in a Big Four, NY. Loves to Travel.

Rhea Khanna

Sometimes it can be really intimidating to shift to another country. Rhea Khanna, a graduate from Syracuse University New York is helping out all the aspirants who want to visit U.S.A. either to study, tourism or work there. In this course, she talks about the structure and regional division of the country: the population, states and the flag of US. She thereby discusses the various facts and statistics associated with its Leaders, Land Area, Dollar as a Global Currency, Anatomy of Currency and much more. Further ahead in the course she throws light on the various languages spoken in the US and discusses the most common jargons used there and what they actually mean. Also, learn about the Dance, Music Theatre, Museums and Theatre of the country. Rhea also shares a lot of Fun facts with respect to U.S.A. which will leave you astonished. 

USA: Language, Culture, Customs, Etiquettes And More

Writer, Educator, Ex-IRS Officer, Author of books on 'Ethics, Integrity and Aptitude' & 'Essay and Answer Writing'  for UPSC Civil Services

Awdhesh Singh

This course provides the practical wisdom contained in Bhagavad Gita. Gita is the pride of India and it is also a part of Ethics paper in Civil Services. The course explains the complex philosophy of Gita in simple words that can be understood by anyone. Everyone would find the course useful to lead a better life.

Lessons

12 lessons • 1h 25m

Invalid Date

NaN

What do you mean by Microsoft Excel with its features.

Invalid Date

NaN

How to Use Vlookup Formula in MS Excel 2007 (in Hindi)

Invalid Date

NaN

How to Make GST Billing with Vlookup Formula in MS Excel 2007 (in Hindi)

Invalid Date

NaN

Different Types of Count Formulas (in Hindi)

Invalid Date

NaN

How to use Countif/ Count ifs function in MS Excel (in Hindi)

Invalid Date

NaN

How to use sum and if formula in Excel

Invalid Date

NaN

How to Use go to Function in MS Excel 2017 (in HIndi)

Invalid Date

NaN

Tutorial on custom sort order in Microsoft Excel

Invalid Date

NaN

Tutorial on sort by colour and custom list

Invalid Date

NaN

Introduction of filter through example

+ See all lessons