Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Advanced Excel Function Articles
Page 57 of 59
Create an interactive chart with series-selection checkbox in Excel
Most of the time, we will insert a chart in order to better present the data, and sometimes, we will use a chart that allows for more than one series option. In this particular scenario, you could wish to display the series by ticking the corresponding checkboxes. Interactive Chart with Series-Selection Suppose you have access to the financial data for a corporation called My Company Ltd., and you are interested in determining how the company's revenue has changed over the course of the last several quarters. At the same time, you should also evaluate the development in relation to the ...
Read MoreCreating an actual vs budget chart in Excel step by step
You may create a chart in Excel that compares the actual value of each project to the target value for that project. This article will show you how to produce an actual vs. budget chart in Excel in a step-by-step manner as well as how to make use of a powerful chart tool in order to complete this task in a timely manner. An Actual vs Budget Chart in Excel Let’s understand step by step with an example. Step 1 At first, we must create a sample data for chart in an Excel sheet in columnar format as shown in ...
Read MoreDynamic highlight data point on Excel chart
When there is a large amount of data plotted on a chart, it might be difficult to interpret. Although it is generally considered best practise to plot just the data that is relevant to the problem at hand, there are times when it is necessary to display a large number of data points on a single chart. If you find yourself in such a predicament, it is a smart idea to have a dynamic chart on hand that emphasises the chosen series in order to make it simpler to understand and evaluate the data. Actual vs Budget Chart If you ...
Read MoreExcel batch find and replace specific text in hyperlinks
In certain circumstances, you may have to find and replace a particular text within hyperlinks while excluding all other content forms. In such cases, you would almost exclusively use the Find and Replace function, which is completely functional when applied to single values. However, if there are dozens or even hundreds of products that need to be replaced, no one would want to manually make all of those replacements one at a time, and then do it all over again if the data were to change. To our relief, Excel provides a number of more powerful strategies for doing mass ...
Read MoreExcel comments: Add, Show/hide, modify, delete, and more advanced operations
Excel comments are available to users during the creation process of an Excel workbook and can be used for a variety of purposes. One of the applications for this function is to provide an explanation of a formula that is now being used in a cell, which is especially helpful when other people will be using the Excel file. In addition, comments in Excel can be used to add reminders or notes for other users, as well as to cross-reference with other Excel workbooks. This functionality is already available in Excel. Excel gives users the option to resize comments, alter ...
Read MoreExcel data validation: Add, use, copy and remove data validation in Excel
You may restrict what users are able to type into a cell by using a handy function called Data Validation. This feature allows you to restrict what users can input into a cell. For instance, the data validation tool may assist you in limiting the length of text strings, or text starting / ending with certain characters, or the number of unique values that must be input, and so on. Add Data Validation Step 1 − Choose the cells in which you wish to set the data validation and add them to the list. Step 2 − Click Data ...
Read MoreExcel drop down list: create, edit, remove and more advanced operations
The drop-down list is a kind of list box that displays a selection list and enables users to choose a single item from the list. This article is going to teach the fundamental procedures for working with drop-down lists, including how to create, modify, and delete drop-down lists in Excel. In addition to that, this article explains advanced procedures for drop-down lists, which improve their usefulness and enable them to resolve other Excel problems. Create drop down list Step 1 There are a lot of various approaches to making a drop-down list, and consequently, there are a lot of different ...
Read MoreExcel hyperlink tutorial: create, change, use and remove in Excel
To the best of our knowledge, hyperlinks may be utilised to browse between different websites on the internet. You may access a web page by using a hyperlink that you make in Excel. You can also construct a hyperlink that links to a cell, worksheet, or workbook, among other things. To assist you in rapidly acquiring proficiency with hyperlinks in Excel, this lesson will progressively walk you through the processes of creating, changing, using, and removing hyperlinks. Create hyperlink In addition to using the Insert Hyperlink command, the HYPERLINK function is another option for you to consider when creating a ...
Read MoreExcel images: Insert, change, delete multiple images or pictures in Excel
We are going to go over how to insert multiple photos into cells and scale them to match the size of the cell, as well as how to put an image into a comment, header, or footer, as well as how to insert images from URLs, and other related topics. In addition to that, it describes how to save, rename, and remove numerous photos simultaneously in Excel. Insert image The majority of us will find that inserting photographs that are saved on the computer into the spreadsheet is a simple process. Kindly follow these guidelines. Step 1 select the Pictures ...
Read MoreExcel random data: generate random numbers, texts, dates, times in Excel
When faced with a frequent scenario, the majority of us may be required to input arbitrary numbers, dates, or text strings according to our preferences. However, at times, have you ever attempted to insert times into a range of cells in a random range? This function's name is RAND(). Excel will return a number that is either higher than or equal to 0 (zero), but it will never return 1. It is possible to generate random integers, text, date and time values, and even dates and times by combining the RAND() function with a few additional functions. Random numbers shows ...
Read More