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 134 of 175
How 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 MoreWhat are the differences between Jumpshare and ShareFile?
Let us understand the concepts of Jumpshare and ShareFile before learning the differences between them.JumpshareJumpshare was developed by Jumpshare Inc in the year 2012. It is a visual communication platform. By Using Jumpshare we can share our work and ideas instantly using shareable links. It combines the features like file sharing, screenshot capture, and video recording all in a single platform. It is available in MacOS, iOS, and Microsoft windows.Jumpshare offers free accounts with limited storage, and paid subscriptions with expanded storage and sharing options.FeaturesThe features of Jumpshare are as follows −Share the work visually in seconds.Delivering the work at ...
Read MoreWhat are differences between OneDrive and ZumoDrive?
Let us understand the concepts of OneDrive and ZumoDrive before learning the differences between them.OneDriveOneDrive is a Microsoft cloud service which connects all your files. It helps us to store and protect our files, share them with others and we can access them from anywhere. It is a file hosting service available in 107 languages.It was launched in 2007 by Microsoft as a web version of office. It offers 5GB of storage space for free and a paid version if it offers a space of 100 GB, 1 TB, and 6 TB available either separately or with Office 365 subscriptions.FeaturesThe ...
Read MoreWhat are the differences between Microsoft Excel and Microsoft Access?
Let us understand the concepts of Microsoft Excel and Microsoft Access before learning the differences between them.Microsoft AccessIt is a database management system offered by Microsoft which puts together the relational Microsoft Jet Database Engine with a graphical user interface and software development tools.AdvantagesThe advantages of Microsoft Access are as follows −Table structure and normalization through multiple tables − In a database you can store more information in one place and you use the address as a reference in many places.Records are free − The major difference between Microsoft excels and Microsoft access is that in a database records are ...
Read MoreWhat are the differences between Microsoft Teams and Skype?
Microsoft Team is a business communication platform which is developed by Microsoft team as a part of the Microsoft 365 family of products. It offers workspace chat, video conferencing, file storage and application integration.Skype is a Microsoft product which offers free video and audio calling which also has the ability to call landlines and smartphones with paid services anywhere in the world. It has a first mover advantage. It came into existence before the Facebook messenger.DifferencesThe major differences between Microsoft Team and Skype are as follows −Microsoft TeamsSkypeThis is a video conferencing and collaboration tool which exists in 2017, Now ...
Read MoreOut-GridView in PowerShell
DescriptionOut-GridView in a PowerShell is the output format in the GUI format. Generally, we get the output on the console using the Format-Table or Format-List command. Similarly, Out-GridView is also the output format but we can interact with it because of the GUI format.Moreover, it provides us options to select single or multiple rows and we can store the selected output and can utilize them in the script.Out-Gridview with PipelineYou can pipeline output to the Gridview in a similar way as Format-Table or Format-List commands.Example1 − With Pipeline outputGet-Service | where{$_.StartType -eq 'Disabled'} | Out-GridViewOutputThe above command will get all ...
Read More