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
Advanced Excel Function Articles
Page 59 of 59
Excel cell conversion tutorial – Convert units, text and number, currencies, time zones, etc
When dealing with data in Excel, there are instances when you may find that you need to do certain data conversions on cells, such as converting units, converting currencies, converting time zones, and so on. Convert Units In most cases, when we need to convert a number from one unit of measure to another, we will utilize the CONVERT function. However, the CONVERT function will not operate properly for some of the unit conversions that you attempt. Step 1 You may use the CONVERT function to convert the inches specified in the range to the corresponding values in feet, centimeters, ...
Read MoreHow to Convert Date Stored as Text to Date in Excel?
When we need to conduct trend analysis, dates act as essential elements. Dates play an important role and you need to make sure that they are conveyed in the best possible way. There are times when dates might end up being formatted as text and saved in the cells.You may have, for instance, placed a date into a cell in text format, or the date may have been imported or pasted from an external data source as text.Convert Text Dates with Two-Digit Years by Using Error CheckingIn this tutorial, we will discuss two methods to convert text formatted dates to ...
Read MoreHow to Combine Data from Multiple Excel Worksheets into One?
There are situations when the data that you require is scattered across numerous sheets in Microsoft Excel, or even multiple files. How wonderful it would be if you could collect all this data in a single document?When you are in a hurry, you can save time by simply copying and pasting the necessary cells onto the same sheet. However, the amount of time and effort required to complete this task may be quite substantial, depending on the data that you are analyzing. Instead, you could think about some of the more intelligent approaches to complete the same task.In this tutorial, ...
Read MoreHow to Calculate Age in Excel from Birthday?
Suppose you have compiled a list of the student’s dates of birth in an Excel spreadsheet, and at this point, you need to figure out how old each one of them is. Excel has a number of useful functions, like DATEDIF and YEARFRAC, that can make it easy to figure out a student’s age based on their birth date.Using the DATEDIF FunctionThe DATEDIF function can convert the birth date to the current age. The general syntax for this is as follows −=DATEDIF(birthdate, TODAY(), "y")Where, Birthdate − The date that corresponds to the student's actual birthday.TODAY() − The current date is ...
Read MoreHow to Add and Subtract Dates and Times in Excel?
Changing the dates on a spreadsheet can be a time-consuming process. You can change the dates without having to get out your calendar to count the days or months because you can do so directly in Microsoft Excel by using basic addition or subtraction.Adjusting the dates does not have to be a burden, regardless of whether this is a project schedule with due dates, a budget with dates when bills are due, or an order sheet with shipment dates. You can enter the addition or subtraction, and the new dates will be automatically calculated for you after a few straightforward ...
Read MoreHow to Convert Multiple Rows to Columns in Excel?
Let's assume you already have a list of data with many rows that only has one column in an excel sheet, but you want to convert these data to multiple rows and columns, you can achieve this using an Excel formula.Step 1Let’s consider the following list of multiple rows data and try to convert those data into multiple columns and rows using excel formula.Step 2Let’s choose an empty cell (C1) in which we will store the first data of the list of data and type the following formula in cell C1 and press Enter.=OFFSET($A$1, (ROW()-1)*3+INT((COLUMN()-3)), MOD(COLUMN()-3, 1))Step 3Now we get ...
Read MoreHow Java objects are stored in memory?
A stack and a heap are used for memory allocation in Java. However, the stack is used for primitive data types, temporary variables, object addresses etc. The heap is used for storing objects in memory.Stacks and heaps in Java are explained in more detail as follows −Stack in JavaStacks are used to store temporary variables, primitive data types etc. A block in the stack exists for a variable only as long as the variable exists. After that, the block data is erased and it can be used for storing another variable.
Read MoreHow to be a Champion Scrum Master!
Do you like to be at the center stage when the management showers the praises and appreciates with thundering applause? Of course, those are the golden moments that everyone is dreaming about. But, is it easy to be a champion without adequate knowledge and skills? No, not at all. You should have all the required skills to excel.And when we talk about a role like Scrum Master, which is widely misunderstood and misinterpreted in many organizations, how come, a person effectively play the role and it’s responsibilities and becomes a champion scrum master, isn’t it challenging?Let’s discuss how you can ...
Read More