Computers Articles - Page 62 of 100

Generally, in Excel, we can always apply a filter to a list just by using a slicer, and we can click on the cell value you want to filter internally. But if you want to apply the filter based on a cell that is not inside the table, we cannot do it with the help of Slicer. We can complete this process with the help of the VBA application. We can apply the filter using an external value. This tutorial will help you understand how you can auto-filter rows based on a cell value in Excel. Step 1 Here we ... Read More

When you want to create a list of dates that only include weekdays in Excel, you can do it by default by using the formulas supported by Excel. For example, if we want to create a list of working dates in an office, we can use this process. Leaving out the weekends means ignoring the dates of both Sunday and Saturday in the list. This tutorial will help you understand how you can autofill weekdays and exclude weekends in a list of Google Sheets. We can complete this process just by using a single formula. We can complete this process ... Read More

When we insert a new row in the table of data where we have the formula in any of the columns, you can see that the formula will not be applied to the new row even though we entered the data in the cell. We need to reapply the formula with the auto-fill handle to all the cells manually. If you are dealing with frequently changing data, you may end up wasting a lot of time applying the formula. You can solve this problem by enabling the formula to auto-fill when inserting new rows in Excel. This process can be ... Read More

Have you ever tried to create a list of dates in Excel? It is a simple process, but have you ever tried to create a list of only weekdays in Excel? It is possible by using this process. Read this tutorial to learn how you can autofill dates or only weekdays in Excel. We will complete the task using the "format" function. AutoFill Date Sequence in Excel To finish our task, we will select a range of cells, then open the format pop-up and select date. Let us see a simple process to auto-fill data sequences in Excel in a ... Read More

What is MPEG? MPEG (Motion Pictures Experts Group) is a family of standards for audio and video compression and transmission. It is developed and maintained by the Motion Pictures Experts Group, a working group of the International Organization for Standardization (ISO) and the International Electrotechnical Commission (IEC). There are several different types of MPEG standards, including − MPEG-1 −This standard is primarily used for audio and video compression for CD-ROMs and low-quality video on the internet. MPEG-2 −This standard is used for digital television and DVD video, as well as high-definition television (HDTV). MPEG-4 −This standard is used for ... Read More

What is JPEG? JPEG (Joint Photographic Experts Group) is a standardized image compression technique that is commonly used for digital photographs. It is designed to reduce the file size of digital images while maintaining reasonable image quality. JPEG is named after the Joint Photographic Experts Group, which developed the standard in the early 1990s. JPEG uses a lossy form of compression, which means that some data is lost when the image is compressed. The degree of compression can be adjusted, with higher levels of compression resulting in smaller file sizes but lower image quality, and lower levels of compression resulting ... Read More

Generally, when we need to edit multiple cells very frequently, we will be selecting the cells using the ctrl command and clicking on delete, but sometimes it can be a problem when we select different cells or when we miss selecting some cells. We can solve this problem by following the process mentioned in this article. This article will help you understand how we can apply a button to clear specific cells in Excel. This process has two parts: creating a button and assigning a macro to the button. Applying a Button to Clear Specific Cells in Excel Here we ... Read More

Consider the following scenario: we want to combine the text of multiple cells into a single cell. This is a very simple and commonly used method in Excel in order to perform activities in our day-to-day life usage of the program. This can be accomplished in two ways: by using the concatenation function or by inserting the "&" symbol between the cells. Read this tutorial to learn a simple process to add text from one cell to another in Excel. Appending Text from One Cell to Another using Concat Here we will use the CONCAT formula to get any one ... Read More

When we conduct any surveys and collect the information and store it in Excel, it can be a very complex problem to analyse it manually, but by following this simple process, we can analyse the data present in the Excel sheet. This process mainly contains three steps: first, count the number of different opinions, then calculate the percentage of each result, and finally, create the survey report. This tutorial will help you understand how we can analyze the survey data in Excel. Analyzing Survey Data in Excel Here we will first find the number of blank cells and then calculate ... Read More

When we are working with multiple sheets in Excel, we can see that when we open the workbook, it will always start from the sheet where we last saved. This can lead to some privacy issues in Excel. Sometimes you don’t want that to happen, and you want to open a specific worksheet in the workbook. This tutorial will help you understand how we can always start the same worksheet when opening the same workbook. Always Start the Same Worksheet When Opening a Workbook Here we will insert VBA code and then save the code to complete the task. Let ... Read More