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

HOW TO ADD OR REMOVE BORDER IN EXCEL?

Table of Contents INTRODUCTION WHAT IS A BORDER IN EXCEL? HOW TO APPLY BORDER TO A TABLE IN EXCEL? HOW ...
Read More

HOW TO INSTALL EXCEL ADDIN IN EXCEL IN SIMPLE STEPS ?

Table of Contents INTRODUCTION WHAT IS AN ADDIN IN EXCEL? HOW TO CREATE AN EXCEL ADDIN ? FOLLOW THE STEPS ...
Read More

INTRODUCTION TO FORMULAS:REFERENCE OPERATORS

Table of Contents INTRODUCTION RANGE OPERATOR IN EXCEL(:) UNION OPERATOR IN EXCEL(,) INTERSECTION OPERATOR IN EXCEL( SPACE ) ANIMATED EXAMPLE ...
Read More

MICROSOFT EXCEL FUNCTIONS

“Microsoft excel or excel is the name given to the spreadsheet software provided by microsoft” which comes bundled with the ...
Read More

CREATE RADAR CHART IN EXCEL

INTRODUCTION CHARTS are the graphic representation of any data . EXCEL provide us a number of visualization options in the ...
Read More

CREATE SPARKLINE IN EXCEL

Table of Contents INTRODUCTION WHEN TO USE SPARKLINE CHARTS BUTTON LOCATION FOR SPARKLINES CHARTS WHAT ARE THE DIFFERENT TYPES OF ...
Read More

HOW TO CHANGE NUMBER FORMAT OR CELL FORMAT IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION OF DATA TYPE CHANGE IN EXCEL TYPES OF NUMBER FORMATS IN EXCEL DETAILED EXPLANATION ...
Read More

HOW TO USE FLASH FILL IN EXCEL?

Table of Contents INTRODUCTION WHAT IS FLASH FILL IN EXCEL? PREREQUISITES TO USE FLASHFILL IN EXCEL BUTTON LOCATION FOR FLASH ...
Read More

HOW TO USE SLICERS IN EXCEL?

Table of Contents INTRODUCTION PREREQUISITES TO USE SLICER IN EXCEL BUTTON LOCATION FOR SLICER STEPS TO CREATE A SLICER IN ...
Read More

HOW TO CREATE A PIVOT TABLE QUICKLY AND AUTOMATICALLY IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION OF AUTOMATICALLY CREATE PIVOT TABLE IN EXCEL BENEFITS OF QUICKLY CREATE A PIVOT TABLE ...
Read More

HOW TO CREATE AND USE PIVOT CHARTS IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION TO CREATE PIVOT CHART IN EXCEL STEPS TO USE PIVOT CHARTS IN EXCEL INTRODUCTION ...
Read More

CREATE HISTOGRAM CHART IN EXCEL

Table of Contents INTRODUCTION WHEN TO USE HISTOGRAM CHARTS BUTTON LOCATION FOR HISTOGRAM CHARTS STEPS TO INSERT A HISTOGRAM CHART ...
Read More

CREATE BOX AND WHISKER CHART IN EXCEL

Table of Contents INTRODUCTION WHEN TO USE BOX AND WHISKER CHARTS BUTTON LOCATION FOR BOX AND WHISKER CHARTS KNOW THE ...
Read More

CREATE TREEMAP CHART IN EXCEL

Table of Contents INTRODUCTION WHEN TO USE TREEMAP CHARTS ? BUTTON LOCATION FOR TREEMAP CHARTS STEPS TO INSERT A TREEMAP ...
Read More