Conditional Formatting – How to generate chess board on excel
Create Chess board on excel Using Conditional Formatting. Here is easy guide to prepare chessboard on cells in excel.
#Excel
189 postsConditional Formatting : Only Numeric Values in Excel
an important command which allows you to apply different kind of formats to selected cell. like only numeric values in excel
Vlookup Function with a Spreadsheet – MS Excel
Vlookup Function: a function in Excel that allows you to type the value of one cell to look up the value of…
Excel RANK Function: Tips To Get Ranking Position
This is tutorial of formula rank function in excel. Rank means position and it is very important for us how to check…
Using PPMT Function Creating a Mortgage Calculator in Excel
PPMT stands for Principal Payment of Monthly Installment. PPMT Function calculate how much the amount of principal will be paid with interest…
How to use Advanced Filter in Microsoft Excel
If you need to apply complex criteria on any worksheet than you have to use Advanced filter in Microsoft Excel. It is…
Important Shortcut keys of Microsoft Excel
During working on the Microsoft Excel if you need to improve your performance then you must have to use shortcut keys of…
Lock or Unlock particular areas of a protect worksheet in Excel
Protection of your data is an important task for us. This guide helps you to lock or unlock particular areas of a…
How to find duplicates using conditional formatting in Excel
If you want to identify and highlight all duplicate values then read this guide which helps you to find duplicates using conditional…
How to apply password protection on non continuous cells in Excel
It is very difficult to apply password on non-continuous cells. This guide helps you to apply password protection on non continuous cells.