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
Microsoft Technologies Articles
Page 131 of 175
Simple ways to insert delta symbol in Excel
Excel provides a variety of options for users who wish to insert symbols into their work. Utilizing the keyboard and the buttons on the Ribbon, creating a formula, and formatting cells are some examples of these. The Delta symbol is an example of a symbol that is frequently utilized in Excel. When presenting a change in numbers, you'll frequently find this on dashboards and scorecards created in Excel. The symbol ∆, known as the Delta, is the fourth letter of the Greek alphabet. In mathematics, it refers to change. In Excel, this symbol allows users to see how values change ...
Read MoreExcel COUNTIF Function – Count cells that are not blank, greater/less than, or contain a specific value
Excel is equipped with a number of functions that are designed to count various types of cells, including those that are blank, those that are not blank, those that contain numbers, dates, or text values, those that include certain words or characters, and so on. Excel's COUNTIF function is used to determine the number of cells inside a given range that fulfil the requirements of a certain condition. In the criteria, logical operators such as ">, value") In our example, we have selected the cell D2 and adding the following formula to it. =COUNTIF(C2:C10, ">20000") After pressing ...
Read MoreHow to add a horizontal average line to chart in Excel?
There are some circumstances in which you might want to create a horizontal line on another chart so that you can evaluate the current values in relation to the goal that you have set for yourself. It is possible to finish the challenge by plotting two distinct kinds of data points on the same graph. In earlier versions of Excel, combining two different chart types into a single chart was a laborious process that required multiple steps. The special Combo chart type that is included in Microsoft Excel 2013, Excel 2016, and Excel 2019 makes the process so astonishingly ...
Read MoreBatch rename multiple hyperlinks at once in Excel
Excel provides a wide variety of options for generating a hyperlink. If you want to create a link to a certain website, all you have to do is write the URL of the page into a cell, press Enter, and Microsoft Excel will immediately transform your entry into a hyperlink that can be clicked on. You can use the Hyperlink context menu or the Ctrl + K shortcut to link to another worksheet in an Excel file, or you can link to a specific location in another Excel file. Utilizing a Hyperlink formula, which makes it simpler to generate, copy, ...
Read MoreHow to enlarge or shrink a picture with one click in Excel?
Excel 2019 enables users to incorporate not just numerical data but also images and graphics. Including pictures and other images is a terrific way to make your spreadsheets look more appealing. You can generate your own photos to add to a workbook or copy and paste images into a spreadsheet, much like you can in Microsoft Word. You can even create your own images to add. Excel gives you the ability to import graphics, shapes, symbols, and even 3D images and photos available on the web. Let's say that there are several pictures on a sheet, and they range in ...
Read MoreHow to send worksheet only through Outlook from Excel
It is common for us to create and work on multiple Excel worksheets at the same time. The workbook could have separate worksheets for different years, products, and departments, or even the same workbook could have separate worksheets for multiple years, products, and departments. If you would like to share a part of a sheet or a single worksheet from the workbook with a colleague or boss or any other person, sometime you may need to email a part of the sheet. Although there may be alternatives to this way of doing things, in this tutorial, I am going to ...
Read MoreCalculate the difference between two dates in days, weeks, months and years in Excel
When working with dates in a worksheet, it may be necessary to determine the number of days, weeks, months, or years between two provided dates. Calculate the difference between two given dates in Days You can use the following formulas to calculate the number of days that exist between two specific dates. Step 1 At first, you must create a sample data as shown in following screenshot. Step 2 Any one of the following formulas should be entered into a blank cell to generate the correct result. Formulas =DATEDIF(B3, C3, "D") Or, =C3-B3 Here, B3 is Start ...
Read MoreClick hyperlink in Excel to go to a specific page in Word document
If you have a spreadsheet created in Microsoft Office Excel, creating a hyperlink to a Word document and inserting it anywhere in the spreadsheet is quite simple and straightforward to accomplish. When you click on the hyperlink, the Word document opens up to the first page automatically. You will need to make use of a method that involves bookmarks in Word in order to be able to generate a hyperlink that will go to a certain page. Step 1 You may open the Word document you wish to access at a specified page by clicking a hyperlink in Excel. Keep ...
Read MoreCreate 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 More