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 SET PRINT AREA IN EXCEL?

Table of Contents INTRODUCTION WHAT IS PRINT AREA IN EXCEL? WHERE IS BUTTON LOCATION TO SET PRINT AREA IN EXCEL ...

Read More

HOW TO SET PAGE MARGIN, ORIENTATION, AND PAGE SIZE IN EXCEL?

Table of Contents INTRODUCTION WHAT IS PAGE MARGIN IN EXCEL? WHAT ARE LANDSCAPE AND PORTRAIT ORIENTATIONS IN EXCEL? WHAT IS ...

Read More

HOW TO CHANGE WORKBOOK THEME IN EXCEL?

Table of Contents INTRODUCTION WHY DO WE NEED TO CHANGE THE THEME OF THE EXCEL SHEET WHERE IS BUTTON LOCATION ...

Read More

HOW TO INSERT WORD ART,OBJECT OR SYMBOL ?

Table of Contents INTRODUCTION WHAT IS WORDART IN EXCEL? WHERE IS BUTTON LOCATION FOR INSERTION OF WORD ART IN EXCEL? ...

Read More

HOW TO INSERT HEADER AND FOOTER IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION FOR ADDING HEADER AND FOOTER IN EXCEL STEPS TO INSERT HEADER IN EXCEL STEPS ...

Read More

HOW TO INSERT TEXTBOX IN EXCEL?

Table of Contents INTRODUCTION WHAT IS A TEXT BOX IN EXCEL ? WHEN TO USE A TEXT BOX IN EXCEL ...

Read More

HOW TO INSERT HYPERLINK IN EXCEL?

Table of Contents INTRODUCTION WHAT IS HYPERLINKING? WHERE IS BUTTON LOCATION TO INSERT A HYPERLINK ? STEPS TO INSERT A ...

Read More

HOW TO INSERT PICTURES, CLIP ART , ICONS AND SMART SHAPES IN EXCEL?

Table of Contents INTRODUCTION WHERE TO USE PICTURES, CLIP ART, ICONS, SHAPES AND SMART ART LOCATION OF BUTTONS FOR ILLUSTRATIONS ...

Read More

HOW TO INSERT A TABLE IN EXCEL?

Table of Contents WHAT IS A TABLE IN EXCEL? BUTTON LOCATION OF TABLE IN EXCEL STEPS TO INSERT TABLE IN ...

Read More

HOW TO ADJUST COLUMN WIDTH IN EXCEL?

Rows and columns are the building blocks of any spreadsheet application which makes it mandatory to learn the ways to ...

Read More

HOW TO ADJUST ROW HEIGHT IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION FOR ADJUSTMENT OF ROW WIDTH IN EXCEL SET FIXED ROW HEIGHT IN YOUR SHEET ...

Read More

HOW TO DELETE SHEETS , COLUMNS AND ROWS IN EXCEL?

Table of Contents HOW TO DELETE SHEETS IN EXCEL ? BUTTON LOCATION FOR DELETION OF SHEETS, COLUMNS OR ROWS IN ...

Read More

HOW TO INSERT SHEETS, COLUMNS AND ROWS IN EXCEL?

Table of Contents HOW TO INSERT SHEETS IN EXCEL ? WHERE TO FIND BUTTON LOCATION FOR INSERTION OF SHEETS, COLUMNS ...

Read More

HOW TO DO CONDITIONAL FORMATTING IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION: CONDITIONAL FORMATTING EXAMPLE 1: DATA SAMPLE STEPS TO START CONDITIONAL FORMATTING: CONDITIONAL FORMATTING :DIFFERENT ...

Read More