![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
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
Pradeep Kumar has Published 1236 Articles
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
501 Views
Excel is a powerful tool. You can use VBA code in Excel to extract actual addresses from hyperlinks. By looping through the range of cells containing hyperlinks, the code checks if each cell has a hyperlink, extracts the address, removes any prefixes like "mailto:" or "tel:", and updates the adjacent ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
2K+ Views
CSV (Comma−Separated Values) is a plain text file format used to store tabular data. It is a widely supported and commonly used format for exchanging data between different applications, particularly in spreadsheet software like Microsoft Excel, Google Sheets, and others. When working with CSV files, it's essential to be mindful ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
134 Views
Exporting charts to graphics in Excel allows you to save your visual representations as standalone image files that can be easily shared, inserted into documents, or used in presentations. Whether you need to include charts in reports, share them with colleagues, or utilize them in other applications, exporting charts as ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
150 Views
Pivot tables are a useful tool in Microsoft Excel that lets you easily analyse and summarise massive amounts of data. However, there may be times when you need to delete a pivot table from your worksheet, either to make room or to begin a new study. In this tutorial, we ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
3K+ Views
Excel is a powerful spreadsheet program developed by Microsoft. It is widely used for organizing, analysing, and manipulating data in various industries and professions. To export multiple columns into individual text files in Excel, you can use VBA (Visual Basic for Applications) macros. Steps to Export or Save Each ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
2K+ Views
Excel, developed by Microsoft, is a widely used spreadsheet program that allows users to organize, analyze, and visualize data in a structured and efficient manner. One of the powerful features of Excel is its ability to create charts and graphs, which help to present data in a visually appealing and ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
881 Views
CSV (Comma−Separated Values) is a plain text file format used to store tabular data. It is a widely supported and commonly used format for exchanging data between different applications, particularly in spreadsheet software like Microsoft Excel, Google Sheets, and others. When working with CSV files, it's essential to be mindful ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
4K+ Views
Excel is a powerful tool that offers a variety of functions for data manipulation and analysis. Supposing you have a lot of pictures in your workbook and want to save them to a specific folder at a time, usually, you can copy and paste the pictures one by one manually ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
11K+ Views
Excel is a powerful tool that offers a variety of functions for data manipulation and analysis. Here we will first create a formula for excluding values in one list from another list in the Excel. Let us see the process that how we can achieve it. These are the steps ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
324 Views
Excel is a powerful tool that offers a variety of functions for data manipulation and analysis. Here we will first create a formula using the VBA application and then use it to complete the task. So, let us see a simple process to exclude certain cell or area from printing ... Read More