Excel, SAP, Oracle & automation tips — plus wacky facts
Automate Windows files, folders and reports.
Automate Windows files, folders and reports.
📄 8 articles⬇️ 8 with practice files🕒 Updated 11 Nov 2026
🎓 Start here: Rust Course → 🎓 Start here: Java Course → 🎓 Start here: R Course →Practical PowerShell for non-programmers: rename hundreds of files, find duplicates, combine CSVs, clean old downloads, check disk space and more — each script explained…
Read article →Turn commands into reusable scripts with param() blocks and switches, log what happened, and run them automatically with Windows Task Scheduler.
Read article →Import CSV files, add calculated columns, summarise with Group-Object and Measure-Object, export results to CSV, and options for real Excel files (ImportExcel module).
Read article →Store values in $variables, use arrays and hashtables, if/elseif/else, foreach and while loops, and the -f format operator for neat output.
Read article →Chain 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.
Read article →Create, list, copy, move, rename and delete files with PowerShell: New-Item, Get-ChildItem with filters, Rename-Item with patterns, -WhatIf for safety and paths with Join-Path.
Read article →Open PowerShell, understand Verb-Noun cmdlets, find commands with Get-Command, read Get-Help, use tab completion and the execution policy for running scripts.
Read article →Bulk-rename files on Windows with PowerShell: add dates, replace text, number files and preview every change safely before it happens.
Read article →
