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.

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 ...

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 ...

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 ...

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? ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...