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 TROUBLESHOOT A FORMULA IN EXCEL?

INTRODUCTION Sometimes when using the complex formula we might do some mistakes which will bring out wrong results. For such ...
Read More

HOW TO USE NAME MANAGER AND DEFINE NAMES IN EXCEL?

INTRODUCTION Name Manager keeps the track of all the defined names in Excel. The Names can be defined by selecting ...
Read More

HOW TO USE MACRO IN EXCEL?

INTRODUCTION How many times you repeated the same steps while creating some report in EXCEL? It is for sure that ...
Read More

HOW TO CREATE AND ARRANGE WINDOWS IN EXCEL?

INTRODUCTION Windows option is given in Excel for a particular case when the sheet has many columns which are not ...
Read More

HOW TO FREEZE PANES IN EXCEL?

Freezing panes (Certain Rows/Columns having headings etc.) in Excel is very important when we are working with big and lengthy ...
Read More

HOW TO SHOW OR HIDE FORMULA BAR, GRIDLINES OR HEADINGS IN EXCEL ?

INTRODUCTION The options to hide the gridlines, formula bar and headings (column name and row number) gives us a flexibility ...
Read More

HOW TO ZOOM IN EXCEL?

INTRODUCTION ZOOM options are standard functions available under the VIEW menu of every program. ZOOM FUNCTION IN EXCEL HELPS YOU ...
Read More

HOW TO SET CUSTOM VIEW AND FULL SCREEN IN EXCEL?

INTRODUCTION Custom view is a setting which can be saved for different margins and settings. It can be applied again ...
Read More

HOW TO USE PAGE BREAK PREVIEW IN EXCEL?

INTRODUCTION As the Name suggest, Page Break Preview lets us to check how the Page will be printed. It shows ...
Read More

HOW TO SET PAGE LAYOUT IN EXCEL?

INTRODUCTION The View tab of excel has many subgroups like workbook view, Show/hide, Zoom, windows and Macros, which specially deals ...
Read More

HOW TO PROTECT AND UNPROTECT SHEET WITH PASSWORD OR WITHOUT PASSWORD IN EXCEL?

INTRODUCTION In Excel Review Tab, we have many different functions like spell check, researching , thesaurus and translation function. These ...
Read More

HOW TO USE RESEARCH, THESAURUS AND TRANSLATION IN EXCEL?

INTRODUCTION We do have Textual portion in our reports and it is always a necessity to keep a check on ...
Read More

HOW TO APPLY SPELL CHECK IN EXCEL?

INTRODUCTION Although, the text is not extensively used in excel sheets but even then there are always chances for mistakes ...
Read More

HOW TO DO SUBTOTAL IN EXCEL?

INTRODUCTION Subtotal is required many times in our reports and we have to do this manually by inserting a row ...
Read More

Loading...