Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
There are many special features in Excel that are only available in tables and can't be applied to normal ranges of data. Operations like sorting and inserting are some of the simplest processes in case of tables. Sometimes, we need to convert a range of data to a table to access those features. Read this tutorial to learn how you can convert a range of data to a table and a table to a range of data in Excel. It is a very simple process. A table will also help us understand our data in a more precise and faster ... Read More
The slider is an important feature for any application to improve the UX of the application. For example, if you want to allow users to choose any value between 1 to 100, it would be better to use the slider than the custom number input field. The Material UI provides the pre-designed Slider component. Also, it contains the different variants of the Slider component. We can pass the props to the Slider component to custom it Execute the below command in the project directory to install the Material UI in the React application. npm i @mui/material @emotion/react @emotion/style ... Read More
A pivot table is a table of grouped values that aggregates the individual items of a more extensive table with multiple distinct categories. The operations that we can perform include sum, max, min, average, and many other mathematical operations. Have you ever tried to convert a pivot table to a list in Excel? If you try to solve this problem manually, it can be a time-consuming and complex process. Read this tutorial to learn a simple trick that you can use to convert a Pivot table to a list in a faster and more accurate way. Converting a PivotTable to ... Read More
Have you faced a problem where all the data is present in a single cell and you are unable to perform any operations and need to divide the data into multiple cells? If you try to divide the data manually, then it can be a time-consuming process. Instead, you can use a simple trick mentioned in this tutorial to save time and get more accurate results. Read this tutorial to learn how you can convert one cell to multiple cells or rows in Excel. Converting One Cell to Multiple Cells/Rows in Excel Here, we will first use the Text to ... Read More
Have you ever tried to convert the number of days to years, months, and days in Excel? If we try to do this by hand, it can be a time-consuming process because we need to divide to get the year, age it to get the months, and then repeat the process to get the days. We can solve this process in a more straightforward and time-efficient manner. Read this tutorial to learn how you can convert numbers to years, months, and days in Excel. Converting Numbers to Year/Month/Day in Excel Here we will use the DATEDIF formula to get any ... Read More
We can create a regular expression so it can find all the substrings between the curly braces. After that, we can use the exec() or match() method to extract the matching substring. In this tutorial, we will learn to use a regular expression to get the string between curly braces using JavaScript. For example, if we have given a string like ‘This is a {string} with {curly} braces, we need to extract all substrings that reside between the curly braces. Using the exec() method with a regular expression to get the string between curly braces The exec() ... Read More
Sometimes in Excel, you may have observed that the date and time are represented as strings without any separators. This could create a huge problem if we perform any operations on the data and analyse them. If we try to do this conversion manually, then it will be a time‑consuming process. However, you can speed up this process by using the tricks mentioned in this tutorial. Read this tutorial to learn how you can convert a number string to a date and time in Excel. Converting a Number String to Date and Time in Excel Here we will use the ... Read More
Generally, in Excel, when using the US format, the numbers will be like 3432.12, but in the European format, the same number will be typed as 3432.12. This can occasionally lead to misunderstanding. So, we need to convert US format to European format for more accurate analysis and simplicity. Read this tutorial to learn how you can convert number formats in Excel between European and American. Converting Number Format from European to US in Excel Here we will use the NUMBERVALUE formula to get any one of the results, then use the autofill handle to get all the results. Let's ... Read More
The default format for Excel files between Excel 97 and Excel 2003 is Xls, and the above versions have the default format of Xlsx. Both are Excel file extensions. If there are any old files in our system and we need to use the new features on them, then it is very necessary to convert them to a new extension. If there is only one file, we can use the "save as" function to complete the task, but it can be time-consuming for multiple files. We can complete the task using the VBA application in a faster way. Read this ... Read More
Sometimes, while working in Excel, you have needed to convert an Excel workbook to PDF. It can be a time-consuming process if you try to do this manually. We can complete the task using the VBA application as it can’t be completed directly in excel. Read this article to learn how you can convert multiple workbooks or worksheets to PDF files at once in Excel. Let us see the procedure in a briefer way. Converting Multiple Workbooks to PDF Files at Once in Excel Here we will first create a VBA module, then run it to select folders that contain ... Read More