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 7 of 175
How to use WRAPROWS and WRAPCOLS Functions in Excel?
Introduction When working with large datasets spread across multiple ranges and sheets, it becomes crucial to quickly convert the unstructured data into a 2D form. WRAPROWS and WRAPCOLS functions are exclusive in Excel 365 that transform the 1-D array into a 2-D array. These functions aid users to organize the data quickly and present the data in a more structured way. Manually combining data from multiple sheets is not only tedious but also prone to errors. In this article, we will explore various methods that empower users to efficiently deploy these functions in Excel. Implementation of WRAPROWS Function in Excel 365 Step 1 Open ...
Read MoreHow to use TOCOL and TOROW functions in Excel?
Microsoft Excel 365 comprises a wide range of new functions to improve users' productivity and efficiency in manipulating data. With big datasets, it takes a lot of time for users to manually transform a 2-D array into a single array. TOCOL and TOROW functions are new inbuilt functions introduced in Excel 365 that are used to rebuild a two-dimensional array into a one-dimensional array. These functions are opposite to WRAPROWS and WRAPCOLS functions. TOCOL streamlines the data values vertically whereas TOROW visualizes the cell’s values only in a single row. Implementation of TOCOL Function in Excel Step 1 Open a ...
Read MoreHow to hide filter arrows/buttons while filtering in Excel?
In the area of spreadsheet wizardry, mastering Microsoft Excel’s features can streamline data management and enhance productivity. One commonly sought-after skill is quickly to hide filter arrows/buttons while filtering in excel process crucial for various tasks like invoicing, inventory control, employee identification codes, and more. In this article, the users are going to hide the filter arrows or buttons where filter the data in Microsoft Excel. There are the numerous types of structures within the excel sheet including conditional formatting, Ku-tools tab, super filter that the users must filter the data from Ku-tools in different way. They utilize Advanced to ...
Read MoreHow to hide button when printing worksheet in Excel?
In the article, the users are going to hide the button once printing the worksheet in Microsoft Excel. There are the several features in the excel sheet including conditional formatting, format cells that the users must fill any type of color according to the need. The excel tool is bundled with numerous functions that enhance users excel knowledge and make proficient to resolve complicated problems. The wide variety of charts are available to visualize the data and reach to the conclusion. The users can use the Design mode to change the design for hiding the button when the users must ...
Read MoreHow to perform Fourier Analysis using Data Analysis tab in Excel?
When working with large datasets spread across multiple ranges and sheets, it becomes crucial to compute Fourier Analysis manually. It is essential to swiftly compute the discrete function and evaluate the Fourier transform quickly when working with enormous datasets dispersed across several ranges which is possible only through the Data Analysis tab. Analysts can spot patterns, trends, anomalies, and outcomes by using statistical methods presented in the Data Analysis Toolpak. In this article, we will learn how to compute the Fourier Analysis using the Data Analysis tab. To Conduct the Fourier Analysis Using the Data Analysis Tab in Excel Step ...
Read MoreHow to install the MSI file using PowerShell?
To install the MSI file with PowerShell, we can use cmdlet Start-Process.Let say we want to install the 7ZIP MSI file on the local computer and we have downloaded and stored the source file on the C:\temp location. Once we run the below command it will start the MSI installation.Start-Process C:\Temp\7z1900-x64.msiThe above command will open the GUI to install the MSI file but we use PowerShell to avoid GUI interaction so we can add the argument to install the file.If you check which arguments are available to run the MSI file, use the below command.C:\Temp\7z1900-x64.msi /?It will popup box like ...
Read MoreHow to add the user to the local Administrators group using PowerShell?
To add the AD user or the local user to the local Administrators group using PowerShell, we need to use the Add-LocalGroupMember command.To add the local user to the local Administrators group, Add-LocalGroupMember -Group Administrators -Member TestUser -VerboseThe above command will add TestUser to the local Administrators group. You can provide any local group name there and any local user name instead of TestUserYou can also add the Active Directory domain user to the Local Administrators group by providing the domain name if the computer is in the same domain.For example, we will add the Beta user from the AutomationLab ...
Read MoreHow to change Azure Subscription in PowerShell?
To change the azure subscription using PowerShell, we can use the Select-AZSubscription command. When you use this command, you can use either the subscription ID, Subscription Name, or the Tenant ID.ExampleWith Subscription Name,Select-AzSubscription -SubscriptionName 'Visual Studio'With TenantID,Select-AzSubscription -Tenant 'XXXX-XXXXX-XXXXXXX-XXXX'With Subscription ID,Select-AzSubscription -SubscriptionId 'XXXX-XXXXX-XXXXXXX-XXXX'Sometimes on console messages will appear that one or more subscriptions are active. In that case, you can switch the other subscription using the Set-AZContext command and you can use subscription ID or the Name for it.ExampleSet-AzContext -SubscriptionId "xxxx-xxxx-xxxx-xxxx" OrSet-AzContext -SubscriptionName "Visual Studio"
Read MoreHow to keep/stop random numbers from changing in Excel?
In the article, we’ll investigate two compelling strategies to stop or keep the random numbers that we have inserted randomly in the worksheet from changing the values that the users have to analyze the data or random numbers in Microsoft Excel. The users must keep or stop the random numbers by using the Ku-tools tab that must insert the numbers between the two random numbers. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Insert Random Data to change the numbers. Example 1: By using Calculation options Step 1 Deliberate the Excel worksheet. Open ...
Read MoreHow to generate QR codes with Excel in Microsoft 365 or Google Sheets?
Introduction In this article, we will learn how to generate QR codes with Excel in Microsoft 365 or in Google Sheets. With the help of the image function, which is available in Microsoft 365, users may quickly develop QR codes in worksheets. If you intend to use the image function in Excel 2019 or in an older version, then it is not available in them. However, users may develop VBA code in Excel versions to achieve this task. The simplest way for users is either to purchase Microsoft 365 software or sign up for a free one-month subscription online. Example ...
Read More