# Microsoft Excel Tips
**URL:** https://forumautomation.com/c/microsoft-excel-tips/12.md
[Latest](https://forumautomation.com/latest.md) · [Categories](https://forumautomation.com/categories.md) · [Tags](https://forumautomation.com/tags.md)
---
## [About the Microsoft Excel Tips category](https://forumautomation.com/t/about-the-microsoft-excel-tips-category/17)
**Author:** [@jacobmani](https://forumautomation.com/u/jacobmani)\
**Replies:** 0
Tips in Microsoft Excel to make you excel In Excel and get work done quickly using short cuts and other hacks which would be very much useful in your MS Office experience
---
## [How to unlock password protected xls and xlsx file if password is unknown?](https://forumautomation.com/t/how-to-unlock-password-protected-xls-and-xlsx-file-if-password-is-unknown/851)
**Author:** [@automate](https://forumautomation.com/u/automate)\
**Replies:** 1\
**Last updated:** [July 11, 2017, 7:37pm UTC](https://forumautomation.com/t/how-to-unlock-password-protected-xls-and-xlsx-file-if-password-is-unknown/851 "2017-07-11T19:37:55Z")
The easiest way to use VBA a code and run the macro. Step 1. Press Alt + F11 It will open a new pop up window. Step 2. Paste the following script Sub PasswordBreaker() 'Breaks worksheet password protection. Dim …
---
## [Free Unit Conversion tool - Microsoft Excel](https://forumautomation.com/t/free-unit-conversion-tool-microsoft-excel/258)
**Author:** [@automate](https://forumautomation.com/u/automate)\
**Replies:** 1\
**Last updated:** [July 12, 2017, 10:35am UTC](https://forumautomation.com/t/free-unit-conversion-tool-microsoft-excel/258 "2017-07-12T10:35:13Z")
Free Unit Conversion Microsoft Excel Tool Length Power Volume Energy Mass Molar Flowrate Energy Dynamic Viscosity Pressure Area Density Thermal Conductivity Heat transfer Coefficient Mass Florwrate Kinematic Viscosit…
---
## [Using excel and opc for process reports](https://forumautomation.com/t/using-excel-and-opc-for-process-reports/553)
**Author:** [@hkelly](https://forumautomation.com/u/hkelly)\
**Replies:** 0\
**Last updated:** [November 5, 2015, 10:00pm UTC](https://forumautomation.com/t/using-excel-and-opc-for-process-reports/553 "2015-11-05T22:00:35Z")
Follow this link HERE to learn more about this topic. Cheers.
---
## [Microsoft Excel Tips - Calculate age based on their Birthday and Today date](https://forumautomation.com/t/microsoft-excel-tips-calculate-age-based-on-their-birthday-and-today-date/358)
**Author:** [@denizen](https://forumautomation.com/u/denizen)\
**Replies:** 0\
**Last updated:** [March 25, 2015, 4:40am UTC](https://forumautomation.com/t/microsoft-excel-tips-calculate-age-based-on-their-birthday-and-today-date/358 "2015-03-25T04:40:17Z")
You can calculate a persons age based on their birthday and todays date. The calculation uses the DATEDIF() function. Birth date : 29-Apr-73 Years lived : 41 =DATEDIF(C8,TODAY(),"y") and the month…
---
## [Microsoft Excel Tips - Function extract the year number from a date](https://forumautomation.com/t/microsoft-excel-tips-function-extract-the-year-number-from-a-date/357)
**Author:** [@denizen](https://forumautomation.com/u/denizen)\
**Replies:** 0\
**Last updated:** [March 25, 2015, 4:33am UTC](https://forumautomation.com/t/microsoft-excel-tips-function-extract-the-year-number-from-a-date/357 "2015-03-25T04:33:55Z")
Date Year 25-Dec-98 1998 =YEAR(C4) What Does It Do? This function extracts the year number from a date. Syntax =YEAR(Date) Formatting The result is shown as a number.
---
## [Microsoft Excel Tips - Function shows the day of the week from a date](https://forumautomation.com/t/microsoft-excel-tips-function-shows-the-day-of-the-week-from-a-date/356)
**Author:** [@denizen](https://forumautomation.com/u/denizen)\
**Replies:** 0\
**Last updated:** [March 25, 2015, 4:31am UTC](https://forumautomation.com/t/microsoft-excel-tips-function-shows-the-day-of-the-week-from-a-date/356 "2015-03-25T04:31:06Z")
Date Weekday Thu 01-Jan-98 5 =WEEKDAY(C4) Thu 01-Jan-98 5 =WEEKDAY(C5) Thu 01-Jan-98 5 =WEEKDAY(C6,1) Thu 01-Jan-98 4 =WEEKDAY(C7,2) Thu 01-Jan-98 3 =WEEKDAY(C8,3) What Does It…