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 softwares and a grid of rows and columns where the data is entered and operations are done on it.

CREATE SUNBURST CHART IN EXCEL

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

CREATE XY SCATTER CHART IN EXCEL

Table of Contents INTRODUCTION WHEN TO USE XY SCATTER CHARTS BUTTON LOCATION FOR XY SCATTER CHARTS STEPS TO INSERT A ...

CREATE FUNNEL CHART IN EXCEL 2019

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

CREATE DOUGHNUT CHART IN EXCEL

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

CREATE GANTT CHART IN EXCEL

Table of Contents INTRODUCTION HISTORY OF GANTT CHARTS GANTT CHART IN EXCEL STEPS TO CREATE A GANTT CHART IN EXCEL ...

CREATE AND ANALYSE USING PARETO CHART IN EXCEL

Table of Contents INTRODUCTION WHAT IS A PARETO CHART IN EXCEL? WHEN TO USE PARETO CHARTS BUTTON LOCATION FOR PARETO ...

CREATE WATERFALL CHART TO SHOW A RUNNING PROCESS IN EXCEL

Table of Contents INTRODUCTION WHEN DO WE USE WATERFALL CHARTS ? BUTTON LOCATION FOR WATERFALL CHART STEPS TOCREATE A WATERFALL ...

CREATE 3D MAP CHART IN EXCEL

Table of Contents INTRODUCTION WHEN DO WE USE 3D MAP CHARTS BUTTON LOCATION FOR INSERTING COLUMN CHARTS STEPS TO INSERT ...

CREATE MAP CHART IN EXCEL

Table of Contents INTRODUCTION WHEN DO WE USE MAP CHARTS ? BUTTON LOCATION FOR INSERTING COLUMN CHARTS STEPS TO CREATE ...

CREATE PIE CHART IN EXCEL

Table of Contents INTRODUCTION WHAT IS A PIE CHART? WHEN DO WE USE PIE CHARTS ? BUTTON LOCATION FOR PIE ...

CREATE COLUMN CHART IN EXCEL

Table of Contents INTRODUCTION WHEN DO WE USE COLUMN CHARTS ? WHERE DO WE FIND COLUMN CHARTS OPTION IN EXCEL ...

HOW TO MAKE A CHART IN EXCEL 2007,2010,2013,2016,2019, 365 ?

Table of Contents INTRODUCTION BUTTON LOCATION TO CREATE CHARTS IN EXCEL BENEFITS OF USING CHARTS IN EXCEL STEPS TO INSERT ...

HOW TO SORT DATA IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION TO SORT DATA IN EXCEL HOW TO SIMPLE SORT IN EXCEL ? STEPS TO ...

FREQUENTLY OCCURRING PROBLEMS IN PIVOT TABLES

Table of Contents INTRODUCTION HOW TO CHANGE THE LAYOUT OF PIVOT TABLE IN EXCEL HOW TO ADD OR REMOVE FIELDS ...