- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Navneet Mishra has Published 28 Articles
Navneet Mishra
153 Views
Introduction When interacting with Excel files, it is often necessary to convert an XLSX file to either the XLS or PDF formats. In order to share files with others who do not have Excel installed, to be compatible with previous versions of Excel, or to create non−editable copies of ... Read More
Navneet Mishra
641 Views
Introduction Working with global time data or organizing operations across time zones sometimes calls for converting Coordinated Universal Time (UTC) or Greenwich Mean Time (GMT) to local time. In order to easily convert UTC/GMT time to local time, Excel offers a number of functions and methods, which makes time ... Read More
Navneet Mishra
3K+ Views
Introduction A useful tool in Excel is the speedy conversion of time to text or the ability to rapidly extract the number of hours, minutes, or seconds from a time value. This capability is useful for many tasks, including calculating durations, carrying out time−based computations, and formatting time data for ... Read More
Navneet Mishra
453 Views
Introduction For many purposes, such as converting measures for recipes, keeping track of weight, or managing inventory, Excel's ability to convert measurements from pounds to ounces, grams, or kilograms may be a useful tool. Excel doesn't have a function built−in expressly for this purpose, but you may still convert ... Read More
Navneet Mishra
324 Views
Introduction You may often find yourself in Excel circumstances where you need to copy or convert a column of email addresses into an Outlook email list. When you need to rapidly construct a distribution list or send emails to a number of people, this procedure might be helpful. You may ... Read More
Navneet Mishra
1K+ Views
Introduction When you need to portray numerical data as words in a more legible and appealing style in Excel, converting numbers to English words might be helpful. Financial reports, bills, and other situations where numbers are best comprehended in written form sometimes call for this conversion. Although there isn't a ... Read More
Navneet Mishra
2K+ Views
Introduction Excel's features for calculating dates and times are quite comprehensive, enabling users to do tasks as diverse as parsing out individual components of a date and determining local time in many time zones. Excel's in−built Date/Time function is able to make more sense of timestamp data down to the ... Read More
Navneet Mishra
3K+ Views
By using text functions and date functions in Excel, you can rapidly change dates from the mm/dd/yyyy format to the yyyymmdd format. This conversion might come in handy if you want to standardize your date formats or if you need to interact with certain systems that need the yyyymmdd format. ... Read More
To Continue Learning Please Login
Login with Google