Contents
Windows Microsoft Excel
Excel Functions
-
CANCATINATE() – Concatenate string
- Eg : if A2 contains Arun, B2 Contains Prakash, C2 Contains Maruthanayagam then A1=CONATINATE(A2,B2,C3) Result is “Arun Prakash Maruthanayagam
-
COUNTIF() – If you want to count the duplicates in the whole Column, use this formula =COUNTIF(A:A, A2)
- Example : =COUNTIF(A:A, A2)
Windows Power-shell
What is windows powershell?
- Windows PoweShell is tool from Microsoft.
- Used for task automation and configuration management framework.
Run Powershell.exe
- Method 1: Windows + R and type powershell and hit “enter”
- Method 2 : Click Start, type PowerShell, and then click Windows PowerShell.
- Method 3 : From the Start menu, click Start, click All Programs, click Accessories, click the Windows PowerShell folder, and then click Windows PowerShell.
Windows Command Prompt
- $PSVersionTable – Find out the version of powershell
- Network : arp -a – List out all IP connected LAN network.
- Network : ipconfig – View the default IP of system
- Network :
netsh wlan show profile “NETWORK NAME” key=clear – View Saved LAN Network Password
- Example : netsh wlan show profile "ArunEworld" Key=clear
- Question Pattern : How to view saved wifi password in windows 10?
- Help – get-Help – gelp menu
- Folder – MD – Create new folder, Eg : MD <Folder_Name>.
- File Rename :
Rename *.<Original_File_Type> *.<Feature_File_Type> – Rename the file type.
- Example : Rename *.txt *.log
- exit – Terminate the power-shell
- ASSOC Displays or modifies file extension associations.
- ATTRIB Displays or changes file attributes.
- BREAK Sets or clears extended CTRL+C checking.
- BCDEDIT Sets properties in boot database to control boot loading.
- CACLS Displays or modifies access control lists (ACLs) of files.
- CALL Calls one batch program from another.
- CD Displays the name of or changes the current directory.
- CHCP Displays or sets the active code page number.
- CHDIR Displays the name of or changes the current directory.
- CHKDSK Checks a disk and displays a status report.
- CHKNTFS Displays or modifies the checking of disk at boot time.
- CLS Clears the screen.
- CMD Starts a new instance of the Windows command interpreter.
- COLOR Sets the default console foreground and background colors.
- COMP Compares the contents of two files or sets of files.
- COMPACT Displays or alters the compression of files on NTFS partitions.
- CONVERT Converts FAT volumes to NTFS. You cannot convert the current drive.
- COPY Copies one or more files to another location.
- DATE Displays or sets the date.
- DEL Deletes one or more files.
- DIR Displays a list of files and subdirectories in a directory.
- DISKPART Displays or configures Disk Partition properties.
- DOSKEY Edits command lines, recalls Windows commands, and creates macros.
- DRIVERQUERY Displays current device driver status and properties.
- ECHO Displays messages, or turns command echoing on or off.
- ENDLOCAL Ends localization of environment changes in a batch file.
- ERASE Deletes one or more files.
- EXIT Quits the CMD.EXE program (command interpreter).
- FC Compares two files or sets of files, and displays the differences between them.
- FIND Searches for a text string in a file or files.
- FINDSTR Searches for strings in files.
- FOR Runs a specified command for each file in a set of files.
- FORMAT Formats a disk for use with Windows.
- FSUTIL Displays or configures the file system properties.
- FTYPE Displays or modifies file types used in file extension associations.
- GOTO Directs the Windows command interpreter to a labeled line in a batch program.
- GPRESULT Displays Group Policy information for machine or user.
- GRAFTABL Enables Windows to display an extended character set in graphics mode.
- HELP Provides Help information for Windows commands.
- ICACLS Display, modify, backup, or restore ACLs for files and directories.
- IF Performs conditional processing in batch programs.
- LABEL Creates, changes, or deletes the volume label of a disk.
- MD Creates a directory.
- MKDIR Creates a directory.
- MKLINK Creates Symbolic Links and Hard Links
- MODE Configures a system device.
- MORE Displays output one screen at a time.
- MOVE Moves one or more files from one directory to another directory.
- OPENFILES Displays files opened by remote users for a file share.
- PATH Displays or sets a search path for executable files.
- PAUSE Suspends processing of a batch file and displays a message.
- POPD Restores the previous value of the current directory saved by PUSHD.
- PRINT Prints a text file.
- PROMPT Changes the Windows command prompt.
- PUSHD Saves the current directory then changes it.
- RD Removes a directory.
- RECOVER Recovers readable information from a bad or defective disk.
- REM Records comments (remarks) in batch files or CONFIG.SYS.
- REN Renames a file or files.
- RENAME Renames a file or files.
- REPLACE Replaces files.
- RMDIR Removes a directory.
- ROBOCOPY Advanced utility to copy files and directory trees
- SET Displays, sets, or removes Windows environment variables.
- SETLOCAL Begins localization of environment changes in a batch file.
- SC Displays or configures services (background processes).
- SCHTASKS Schedules commands and programs to run on a computer.
- SHIFT Shifts the position of replaceable parameters in batch files.
- SHUTDOWN Allows proper local or remote shutdown of machine.
- SORT Sorts input.
- START Starts a separate window to run a specified program or command.
- SUBST Associates a path with a drive letter.
- SYSTEMINFO Displays machine specific properties and configuration.
- TASKLIST Displays all currently running tasks including services.
- TASKKILL Kill or stop a running process or application.
- TIME Displays or sets the system time.
- TITLE Sets the window title for a CMD.EXE session.
- TREE Graphically displays the directory structure of a drive or path.
- TYPE Displays the contents of a text file.
- VER Displays the Windows version.
- VERIFY Tells Windows whether to verify that your files are written correctly to a disk.
- VOL Displays a disk volume label and serial number.
- XCOPY Copies files and directory trees.
- WMIC Displays WMI information inside interactive command shell.
runas
- First Run C:\Users\HP>runas /user:localhost\administrator cmd .
- Then Asking these automatically Enter the password for localhost\administrator: .
- Reference :https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-xp/bb490994(v=technet.10)
- Video :
Reference
- https://www.techrepublic.com/blog/10-things/10-cool-things-you-can-do-with-windows-powershell/
- http://www.dailyfreecode.com/code/hello-world-powershell-334.aspx
Other FAQ
How to run ‘sudo’ command in windows?
How to easily track how long my laptop battery actually lasted?
- Focus Keywords
- battery monitor windows
- Reference
How Set DNS host in windows 10?
- C:\Windows\System32\drivers\etc (Edit the host file) . Note : this was tested with Windows 10 and its working fine.
How combine multiple hard drives into one volume in Windows 10
Can you password protect a folder in Windows 10?
- Answer will add soon.