Microsoft Excel Shortcuts
>>>MS EXCEL SHORTCUTS <<< Keys Function Ctrl + N Create a new workbook ...Read More
Showing posts with label EXCEL TRICKS & FORMULAS. Show all posts
Showing posts with label EXCEL TRICKS & FORMULAS. Show all posts
How to remove the encrypted password in excel workbook
* Go to file ==> Protect workbook ==> Encrypt the workbook with password * Delete the content (Previous password) in password b...Read More
How to highlights fail marks in Excel
* Select the marks and click the conditional formatting ==> Less than * Enter the mark which of below would be considered as fail * No...Read More
How to calculate monthly percentage in Excel
• Calculate the all daily production using Autosum option • We may get a huge value in overall percentage • Divide that overall percentage b...Read More
Top 10 interesting facts about Microsoft Excel
1. Every Excel sheet has 17,179,869,184 cells. If we spend 1 second to fill out 1 cell in manual it take us 545 years to complete whole sh...Read More
How to count days in MS Excel
• To check the number of days between two date period, use the below given formula • (=DAYS) Select the date • Now the number of dates has b...Read More
How to set password for Excel file
• Go to file==>info ==>Protect workbook • Click with protect workbook==> Encrypt with password • Now enter password and confirm it ...Read More
How to change all currency symbol
• Select the numerical which need to add currency symbol • Go to file==>HOME ==>NUMBER tab • Select the dollar sym...Read More
Subscribe to:
Posts
(
Atom
)