PowerShell is built into Windows and automates files, folders, reports and scheduled jobs. Six lessons with tested scripts: cmdlets and help, files, the pipeline, variables and loops, CSV data and scheduled tasks.

1. 1PowerShell Lesson 1: Basics — Cmdlets and HelpOpen PowerShell, understand Verb-Noun cmdlets, find commands with Get-Command, read Get-Help, use tab completion and the execution policy for running scripts.
2. 2PowerShell Lesson 2: Files and FoldersCreate, list, copy, move, rename and delete files with PowerShell: New-Item, Get-ChildItem with filters, Rename-Item with patterns, -WhatIf for safety and paths…
3. 3PowerShell Lesson 3: The Pipeline — Filter, Sort, SelectChain commands with the pipeline: Where-Object to filter, Sort-Object, Select-Object for columns and top N, Group-Object and Measure-Object — objects, not text.
4. 4PowerShell Lesson 4: Variables, Loops and ConditionsStore values in $variables, use arrays and hashtables, if/elseif/else, foreach and while loops, and the -f format operator for neat output.
5. 5PowerShell Lesson 5: CSV and Excel DataImport CSV files, add calculated columns, summarise with Group-Object and Measure-Object, export results to CSV, and options for real Excel files (ImportExcel…
6. 6PowerShell Lesson 6: Scripts and Scheduled TasksTurn commands into reusable scripts with param() blocks and switches, log what happened, and run them automatically with Windows Task Scheduler.

Related: 10 PowerShell scripts for office work, bulk rename files.