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 use NESTED IF in Excel ? – with Examples

Table of Contents INTRODUCTION Normal IF Function in Excel WHAT IS NESTING A FUNCTION? How to nest IF FUNCTION in ...

Read More

What is the use of new AUTOMATE TAB in Excel?

Table of Contents Inroduction What are the different options available in AUTOMATE TAB in Excel? How to record actions in ...

Read More

How to create a BORDER in Excel?

Table of Contents Introduction What is a border in Excel ? What are the steps to create a border in ...

Read More

HOW TO INSTALL 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

WHAT ARE REFERENCE OPERATORS IN EXCEL?

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

HOW TO CREATE RADAR CHART IN EXCEL

Table of Contents INTRODUCTION WHAT IS A RADAR CHART IN EXCEL? WHEN DO WE NEED RADAR CHARTS ? BUTTON LOCATION ...

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