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

Table of Contents INTRODUCTION DIFFERENT WAY TO TROUBLESHOOT FORMULAS IN EXCEL WHERE DO WE FIND TRACE PRECEDENTS, TRACE DEPENDENTS, SHOW ...
Read More

HOW TO USE NAME MANAGER AND DEFINE NAMES IN EXCEL?

Table of Contents INTRODUCTION PURPOSE OF NAME MANAGER IN EXCEL BUTTON LOCATION OF NAME MANAGER AND DEFINE NAME IN EXCEL ...
Read More

HOW TO USE MACRO IN EXCEL?

Table of Contents INTRODUCTION WHERE TO FIND BUTTON LOCATION OF MACRO IN EXCEL ? STEPS TO CREATE A MACRO IN ...
Read More

HOW TO CREATE AND ARRANGE WINDOWS IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION FOR CREATING AND ARRANGING WINDOWS IN EXCEL WHEN DO WE NEED TO CREATE MULTIPLE ...
Read More

HOW TO FREEZE PANES IN EXCEL?

Table of Contents INTRODUCTION WHERE DO WE FIND BUTTON LOCATION TO FREEZE PANES IN EXCEL ? WHAT IS FREEZING ROWS/ ...
Read More

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

Table of Contents INTRODUCTION WHERE TO FIND THE BUTTON LOCATION FOR SHOW/HIDE IN EXCEL WHAT ARE GRIDLINES IN EXCEL? WHAT ...
Read More

HOW TO ZOOM IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION FOR ZOOM OPTION IN EXCEL STEPS TO ZOOM IN EXCEL KEYBOARD AND MOUSE SHORTCUT ...
Read More

HOW TO SET CUSTOM VIEW AND FULL SCREEN IN EXCEL?

Table of Contents INTRODUCTION WHERE CAN BE MAKE USE OF CUSTOM VIEW IN EXCEL? BUTTON LOCATION FOR ADJUST CUSTOM VIEW ...
Read More

HOW TO USE PAGE BREAK PREVIEW IN EXCEL?

Table of Contents INTRODUCTION WHAT IS PAGE BREAK PREVIEW? BUTTON LOCATION FOR PAGE BREAK PREVIEW IN EXCEL STEPS TO USE ...
Read More

HOW TO SET PAGE LAYOUT IN EXCEL?

Table of Contents INTRODUCTION WHAT IS PAGE LAYOUT OPTION IN EXCEL? WHAT CAN WE DO IN THE PAGE LAYOUT STATE ...
Read More

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

Table of Contents INTRODUCTION BUTTON LOCATION FOR PASSWORD PROTECT AND UNPROTECT SHEET IN EXCEL STEPS TO PASSWORD PROTECT EXCEL SHEET ...
Read More

HOW TO USE RESEARCH, THESAURUS AND TRANSLATION IN EXCEL?

Table of Contents INTRODUCTION WHERE TO FIND LOCATION FOR RESEARCH, THESAURUS AND TRANSLATION OPTIONS IN EXCEL ? WHAT IS RESEARCH ...
Read More

HOW TO APPLY SPELL CHECK IN EXCEL?

Table of Contents INTRODUCTION WHERE TO FIND BUTTON LOCATION FOR APPLYING SPELL CHECK IN EXCEL ? STEPS TO SPELL CHECK ...
Read More

FIND SUBTOTAL IN EXCEL

Table of Contents INTRODUCTION WHERE IS SUBTOTAL BUTTON IN EXCEL? BUTTON LOCATION OF SUBTOTAL IN EXCEL 2016 AND LATER: EXAMPLES: ...
Read More