Using PowerShell and Excel PivotTables to understand the files on your disk

  Introduction I am a big fan of two specific technologies that usually don’t get mentioned together: PowerShell and Excel PivotTables. It started when I was explaining PivotTables to someone and the main issue I had was finding a good set of example data that is familiar to everyone. That’s when it hit me. People…

7

PowerShell Examples – Random words and their popularity via Bing

This blog is part of a series that shows example PowerShell code for those learning the language. This time we’re using PowerShell to generate random words and check if they are popular by using a Bing search. The words are color-coded as white (not found on the web), green (between 1 and 1,000 hits on…

0

PowerShell Examples: Adventure House Game

This blog is part of a series that shows example PowerShell code for those learning the language. This time we’re using PowerShell create a text adventure game that requires to find your way out of a house using simple commands. There is a locked door and you need to find a key. This example explores…

4

PowerShell Examples: Guess the number

This blog is part of a series that shows example PowerShell code for those learning the language. This time we’re using PowerShell create a simple game where you need to guess a number. This example explores basic loops, logical operations (like –ne, –ge, –lt) and entering data with Read-Host.   ## Guess the number# [int]…

0

PowerShell Examples: Counting words in a text file

This blog is part of a series that shows example PowerShell code for those learning the language. This time we’re using PowerShell to count lines, count words, find the largest word and find the most frequently used words in a text file. To make it interesting, we’re using a plain text version of “Alice in…

1

PowerShell Examples: Generating Random Names

This blog is part of a series that shows example PowerShell code for those learning the language. This time we’re using PowerShell to generate random full names using common first names and common last names. It basically combines a random first name with a random letter for middle initial and a random last name. This…

0

PowerShell Examples: Calculating the value of Pi

This blog is part of a series that shows example PowerShell code for those learning the language. This time we’re using PowerShell to find the value of Pi. This is done using one of the many methods available, using a division between n! (factorial) and (n*2+1)! (factorial of odd numbers). This example explores loops and…

0

PowerShell Examples: Calculating Prime Numbers

This blog is part of a series that shows example PowerShell code for those learning the language. This time we’re using PowerShell to find prime numbers. This is not using any sophisticated method, just checking the remainder for all numbers between 2 and the square root of the number. This example explores loops and general…

1