MS Excel

“Microsoft excel or excel is the name given to the spreadsheet software provided by microsoft” which comes bundled with the microsoft office suite. Excel is one of the most important component of the office suite.

Spreadsheet or excel is a software which provides calculation tools to make our report making easier. It provides many functions, formulas, tables, charts etc. to analyze the data within minutes.

MS excel have great features such as what if analysis, pivot tables, pivot charts, graphs, visual basic for application programming for excel etc. which helps people to solve calculation problems.

Microsoft excel has all the functions of a standard spreadsheet software and a grid of rows and columns where the data is entered and operations are done on it.

CLICK HERE TO LEARN FUNCTIONS IN MS EXCEL

CHOOSE THE TOPIC OF YOUR CHOICE

FIND SUBTOTAL IN EXCEL

Table of Contents INTRODUCTION WHERE IS SUBTOTAL BUTTON IN EXCEL? BUTTON LOCATION OF SUBTOTAL IN EXCEL 2016 AND LATER: EXAMPLES: ...

Read More

HOW TO GROUP AND UNGROUP IN EXCEL?

Table of Contents INTRODUCTION WHAT IS THE NEED OF GROUP AND UNGROUP IN EXCEL? WHERE IS BUTTON LOCATION FOR GROUP ...

Read More

HOW TO DO WHAT-IF ANALYSIS IN EXCEL?

Table of Contents INTRODUCTION WHERE IS BUTTON LOCATION FOR WHAT-IF ANALYSIS IN EXCEL DIFFERENT WAYS TO DO WHAT-IF ANALYSIS IN ...

Read More

HOW TO CONSOLIDATE DATA IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION FOR CONSOLIDATION OF DATA IN EXCEL TYPES OF CONSOLIDATIONS IN EXCEL CONSOLIDATE BY POSITION ...

Read More

HOW TO USE DATA VALIDATION IN EXCEL?

Table of Contents INTRODUCTION WHAT IS DATA VALIDATION IN EXCEL? WHEN DO WE USE DATA VALIDATION IN EXCEL? WHERE IS ...

Read More

HOW TO REMOVE DUPLICATES IN EXCEL?

Table of Contents INTRODUCTION WHERE IS REMOVE DUPLICATES PRESENT IN EXCEL? PURPOSE OF REMOVE DUPLICATES IN EXCEL? WAY TO USE ...

Read More

HOW TO CONVERT TEXT TO COLUMN IN EXCEL?

Table of Contents INTRODUCTION WHERE IS TEXT TO COLUMN IN EXCEL ? EXAMPLE : DIVIDE THE GIVEN TEXT AND PUT ...

Read More

HOW TO USE ADVANCED FILTER IN EXCEL?

Table of Contents INTRODUCTION WHAT IS ADVANCED FILTER IN EXCEL? EXAMPLE: USE ADVANCED FILTER TO FILTER THE GIVEN DATA HOW ...

Read More

HOW TO FILTER DATA IN EXCEL?

Table of Contents INTRODUCTION WHERE IS FILTER DATA BUTTON IN EXCEL ? STEPS TO APPLY FILTER ON DATA IN EXCEL ...

Read More

HOW TO GET EXTERNAL DATA IN EXCEL?

Table of Contents INTRODUCTION WHERE IS OPTION FOR GETTING EXTERNAL DATA IN EXCEL? STEPS TO INSERT DATA FROM EXTERNAL SOURCES ...

Read More

HOW TO ARRANGE, ALIGN AND ROTATE SHAPE OBJECTS IN EXCEL?

Table of Contents INTRODUCTION WHERE IS THE BUTTON LOCATION TO ARRANGE SHAPE OBJECTS IN EXCEL ? HOW TO ARRANGE SHAPE ...

Read More

HOW TO SHOW OR REMOVE GRIDLINES, ROW NUMBERS, AND COLUMN NAMES IN EXCEL?

Table of Contents INTRODUCTION WHERE IS BUTTON LOCATION FOR SHOWING OR HIDING THE GRIDLINES AND HEADINGS ? STEPS TO REMOVE ...

Read More

HOW TO PRINT TITLES IN EXCEL ?

Table of Contents INTRODUCTION WHAT DO WE MEAN BY PRINTING TITLES IN EXCEL? WHERE IS BUTTON LOCATION FOR PRINTING TITLES ...

Read More

HOW TO INSERT PAGE BREAK AND BACKGROUND IN EXCEL ?

Table of Contents INTRODUCTION WHAT IS A PAGE BREAK IN EXCEL? WHERE IS BUTTON LOCATION TO INSERT PAGE BREAK AND ...

Read More