Posts

Disk Management

Image
       Microsoft Disk Management   Format a hard drive using the Command Prompt (CMD) in Windows, follow these steps: Caution Formatting a disk erases all the data on it. Ensure you have backed up any important data before proceeding. Steps to Format a Hard Disk via CMD 1. Open Command Prompt as Administrator: Press Win + S to open the search bar, type cmd, right-click on Command Prompt, and choose Run as Administrator. 2. Launch Disk Partition Tool: Type the following command and press Enter: diskpart 3. List Available Disks: To see the available disks, type: list disk This will display all the disks connected to your computer. 4. Select the Disk to Format: Identify the disk you want to format (e.g., Disk 1). Select it by typing: select disk 1 Replace 1 with the appropriate disk number. 5. Clean the Disk (Optional): To remove all partitions and data, type: clean 6. Create a New Partition: Type the following to create a new primary partition: create partition pr...
Post a Comment
Read more

MS Office 365

Image
  TO Update Edited Date and Time Row by Row :-   To automatically update an Excel sheet with the current date and time whenever a specific row is updated, you can use a combination of VBA (Visual Basic for Applications) scripting within Excel. Here’s a step-by-step guide: 1. Open the Excel File Open the Excel file you are working on. 2. Open the VBA Editor Press  Alt + F11  to open the  VBA Editor . 3. Insert VBA Code In the VBA editor, on the left side, find the name of your workbook (usually called  VBAProject (YourWorkbookName.xlsx) ). Right-click on  ThisWorkbook  or the specific sheet name where you want the date and time to appear and select  View Code . 4. Add the Following VBA Code Copy and paste this code into the editor: Private Sub Worksheet_Change(ByVal Target As Range) Dim UpdateColumn As Integer UpdateColumn = 7 ' Column where date and time will be added (Adjust the number to the correct column number) If Target.Col...
Post a Comment
Read more

Windows Networking

Image
  Windows Networking Network Issues TroubleShooting :- ipconfig /release ipconfig /renew arp -d * nbtstat -R nbtstat -RR ipconfig /flushdns ipconfig /registerdns
Post a Comment
Read more

Windows Scripts

Image
Windows Scripts   Steps to Create and Run the Batch Script: 1. Create the Batch Script :-    - Open Notepad or any text editor.    - Copy and paste the script above.    - Save the file with a `.bat` extension, e.g., `config_laptops.bat`. 2. Run the Batch Script as Administrator :    - Right-click the saved `.bat` file.    - Select "Run as administrator". This should allow you to set the password without encountering issues when logging in.
Post a Comment
Read more

Windows Administration

Image
                                                 Windows Technical Information Fetch System Information Using PowerShell:- To Get System Information (Like WMIC csproduct) Run this in PowerShell: powershell Get-CimInstance -ClassName Win32_ComputerSystemProduct To Get CPU Information Get-CimInstance -ClassName Win32_Processor | Select-Object Name, MaxClockSpeed, NumberOfCores To Get RAM Information Get-CimInstance -ClassName Win32_PhysicalMemory | Select-Object Capacity, Manufacturer, Speed To Get Storage Information Get-CimInstance -ClassName Win32_LogicalDisk | Select-Object DeviceID, Size, FreeSpace Windows OS Version Checking :- Command :-  slmgr /xpr WINDOWS EFI -BOOT LOADER :- \EFI\Microsoft\Boot\bootmgfw.efi Windows Product Key := Windows product key access The Windows Product Key is embedded in the BIOS, and can be viewed...
Post a Comment
Read more