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 8 of 175
How to list all comments to a new worksheet or workbook in Excel?
Microsoft Excel is a powerful tool used by millions of individuals and professionals for data analysis, calculations, organization and more. Navigating through large spreadsheets efficiently can save precious time and effort. In the article, we may go to list or visualize all the comments to a new sheet or worksheet that the users must list the comments with Ku-tools tab to new worksheet in Microsoft Excel. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Ku-tools tab to list all comments to a worksheet. Example 1: By using Ku-tools Step 1 In the Excel ...
Read MoreHow to use the Vstack function to combine Multiple Sheets in Excel?
Introduction When working with extensive datasets, manually stacking data row-wise through copy paste option wastes lots of users' time. Sometimes, large data resides in multiple sheets and users intend to stack all the compiled data on one another. Microsoft 365 is full of bundled features that provide flexibility and scalability to the users to become proficient in their analytics work. The primary objective of the vstack() function which is exclusive to Office 365, is to quickly stack two datasets from distinct worksheets on top of each other. Example 1: To stack the two arrays in a single array by using ...
Read MoreHow to Create Barcode in Excel?
Introduction Microsoft Excel is undoubtedly one of the most powerful tools for organizing and analyzing data. The tool is enriched with extensive features that improve the user's data analytics skills. In this article, we will learn how to generate barcodes in MS Excel. Manually creating barcodes and QR codes consumes lots of users' time. By default, the barcode font is not presented in Excel 2016, or Excel 2019. One of the simplest ways to use the barcode is to download the "3 of 9 Barcode" Font from the external website Dafont. Example 1: To generate a Barcode in Excel ...
Read MoreMerging two lists and Extracting Contact Numbers with a Known First and Last Name using VLOOKUP formula in Excel
Problem Statement Suppose we have two lists that are defined in two distinct worksheets. One worksheet contains the basic details of the employee like the Employee ID, Employee First Name, and Employee Last Name whereas the other worksheet contains only two columns named Employee First Name and Contact Number. By using the VLOOKUP formula, we intend to get the contact numbers of the employees and append them to the first list. VLOOKUP is one of the most powerful functions to search for a specific value in a row. To combine two lists using the VLOOKUP formula Step 1 Users need ...
Read MoreHow to add country/area code to a phone number list in Excel?
In this tutorial, you will learn how to format phone numbers with country code using three simple methods. Method 1: Using Format for Phone Number with Country Code You need to take the following actions to be able to add a country code to the Formatted Number column. Step 1 Select the phone number from the range of cells C1:C7. Step 2 Press ctrl+1. When Format cells dialog box opens, choose Custom and type +1 (000) 000-0000, then click OK. Result Finally, the outcome with country codes in the Formatted Number cells are shown in ...
Read MoreHow to get the System uptime with PowerShell?
To get the Windows System uptime with PowerShell, we can use the CIM Instance method with class name Win32_OperatingSystem. Once you use the mentioned class there is a property called LastBootupTime which shows the date when the computer is last rebooted.ExampleGet-CimInstance -ClassName Win32_OperatingSystem | Select LastBootUpTimeOutputLastBootUpTime -------------- 9/29/2020 8:12:08 AMIf we check the datatype of the above output, it should be DateTime because of the output format.(Get-CimInstance -ClassName Win32_OperatingSystem).LastBootUpTime.Gettype()OutputIsPublic IsSerial Name BaseType -------- -------- ---- -------- True True DateTime System.ValueTypeWe need now the uptime of the system in Days-Hours-Minutes format. So we will compare ...
Read MoreHow to get the path of the currently executing script in PowerShell?
To get the full path of the script we need to use the $myInvocation command. This is an automatic variable and it is only invoked when the script or the function is executed.$MyInvocation.MyCommand.Path command is useful to get the full path of the script where it resides while $MyInvocation.MyCommand.Name is useful to get the name of the script. Example$mypath = $MyInvocation.MyCommand.Path Write-Output "Path of the script : $mypath"OutputPS C:\WINDOWS\system32> C:\Temp\TestPS.ps1 Path of the script : C:\Temp\TestPS.ps1Please note that we are running the above script from the System32 directory and the output path is C:\temp. To get the script directory, we can ...
Read MoreHow to get the local Administrators group members using PowerShell?
To get the local Administrators group members using PowerShell, you need to use the GetLocalGroupMember command. This command is available in PowerShell version 5.1 onwards and the module for it is Microsoft.PowerShell.LocalAccounts. This module is not available in the 32-bit PowerShell version but on a 64-bit system.In the below example, we need to retrieve the Local Administrators group members, ExampleGet-LocalGroupMember -Group "Administrators"OutputObjectClass Name PrincipalSource ----------- ---- --------------- User LABDOMAIN\delta Group LABDOMAIN\Domain Admins User TEST1-WIN2K12\Administrator User ...
Read MoreHow to Convert Time to Decimal Hours /Minutes/ Seconds in Excel?
A decimal hour is a time that is represented as a number. In Excel, you may have needed to convert the given time to decimal values at times. If we try to do this task manually, then it can be a time-consuming process. We can use the faster approach mentioned in this article. We can solve this task using the formulas supported in Excel. Read this tutorial to learn how you can convert time to decimal time in Excel. Converting Time to Decimal Hours in Excel Here we will use the formula to get any one of the values, then ...
Read MoreHow to Convert Numbers to Words in Indian Rupees in Excel?
When we need to convert numbers to words in Indian rupees in Excel, it can be a time‑consuming process if we do it manually as we need to type the large numbers. We can complete this time-consuming process much more quickly by using the VBA application. Even though the VBA code will be lengthy, we can use this process if there are many values to convert. Read this tutorial to learn how to convert numbers to words in Indian rupees in Excel. Converting Numbers to Words in Indian Rupees in Excel Here we will create a new VBA module, then ...
Read More