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
MS Excel Articles
Page 115 of 119
How to hide or show chart axis in Excel?
What is an Axis? An Axis on a chart in excel or google sheets is a horizontal or vertical line containing units of measure. The axes border the plot vicinity of column charts, bar graphs, line graphs, and different charts. An axis shows devices of measure and offers a body of reference for the facts displayed in the chart. Most charts, such as column and line charts, would have two axes that are used to measure and categorize data. The vertical axis: The Y or value axis. The horizonal axis: The X or category axis. Hide or ...
Read MoreHow to grey out cells based on another column or drop down list choice in excel?
Excel's Conditional Formatting is a feature that is both one of the simplest straightforward and one of the most powerful features. When you want to highlight cells in Excel that meet a certain criterion, you can utilize a feature in Excel called conditional formatting, which gives the functionality as its name. It provides you with the capability to rapidly construct a visual analysis layer on top of your data set. Using the conditional formatting feature in Excel, you can generate heat maps, display increasing or decreasing icons, and do a number of other useful things. In this tutorial, you are ...
Read MoreHow to list all dates between two dates in Excel?
Imagine you are in a scenario where you need to construct a table that is organized by date. For instance, you are making a schedule and need to specify a list of activities arranged by date in the appropriate order. You would require a list of dates in the event that this occurs. There is no such thing as a limitless list, so it stands to reason that the one you would have a beginning and an end date. In certain circumstances, if you already know the date at which you want to begin and the date at which ...
Read MoreHow to quickly check if a file (workbook) is open or closed in Excel
If you operate on a team, there will inevitably be situations in which many people attempt to use the same file. It is possible that when your team member is reviewing certain information in a workbook at the same time as you are attempting to rename the file on your computer. If you try to do this with a macro, you will most likely receive a run time error. This is because when you run files manually, it typically produces an acceptable warning message; but, if you try to do this with a macro, you will most likely receive ...
Read MoreHow to quickly insert a line based on current date in Excel
You have a sheet that already has a row with dates, and you want to add a line that will automatically update to reflect the current date each time the workbook is opened. This line should be inserted directly to the right of the row holding the dates. Insert a Current Date Line Utilizing the Conditional Formatting method will allow you to populate a cell with a date line that is up to date. Step 1 Clicking the Home button comes after first selecting the range into which you wish to insert the line. Step 2 Now choose Conditional ...
Read MoreHow to quickly jump to the cell with current date in Excel
If you want to bounce to a particular cell or current date in Excel, you can apply go to Name box which is left to the formula bar, and type the cell reference which you want to jump to and then press Enter key. You can follow the Find and Replace utility to jump to the current date. Jump to the Current Date with Find and Replace You can use the following steps to quickly jump to the cell with current date in Excel. Step 1 Open the Excel sheet, which contains the date list as shown below. Step ...
Read MoreHow to repeat a sequence of numbers in Excel?
When dealing with a large dataset in Microsoft Excel, it is occasionally necessary to repeat the number pattern. The information of a number of different employees is included in today's dataset. Utilizing Excel's keyboard shortcuts, the Fill command, and the IF, MOD, and ROW functions, amongst others, enables us to quickly and simply replicate the numerical pattern. Repeat a Sequence using MOD Let's imagine that we have access to a dataset that includes information about a number of different teachers. We will determine the total number of working days and the corresponding remuneration for those teachers. Step 1 The following ...
Read MoreHow to zoom all tabs in one size in Excel?
It is handy to have the ability to make a worksheet appear larger on the screen of the computer, especially if the display of the computer is on the smaller side. You might also need to zoom out to get a better view of the worksheet in its entirety. Excel's zoom tool allows the user to alter the proportions of a worksheet. You can increase or decrease the magnification by using the Zoom tool if you wish to see more or less of a worksheet respectively. There are a few mouse and keyboard shortcuts that you may use to ...
Read MoreSimple 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 More