NORMDIST Function in Excel: Normal Distribution (Older Name)
NORMDIST gives the normal distribution for a mean and SD. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →Atul Vij
PowerShell Lesson 6: Robust Scripts, Error Handling and Scheduled Tasks
PowerShell Lesson 6: Robust Scripts, Error Handling and Scheduled Tasks
Turn commands into reusable scripts with param() blocks and switches, log what happened, and run them automatically with Windows Task Scheduler.
Read article →SAP Basics Lesson 4: ALV Layouts and Exporting to Excel
SAP Basics Lesson 4: ALV Layouts and Exporting to Excel
Work with SAP ALV lists: choose and order columns, sort, filter, subtotal, save layouts and default layouts, and export to Excel correctly without broken…
Read article →PROB Function in Excel: Probability From a Table
PROB Function in Excel: Probability From a Table
PROB adds the probabilities of outcomes falling between two limits, from a simple value/probability table.
Read article →PowerShell Lesson 5: Working With CSV, JSON and Excel Files
PowerShell Lesson 5: Working With CSV, JSON and Excel Files
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 →Enable GUI Script Recording – SAP
Enable GUI Script Recording – SAP
This document describes how you can turn on GUI Script Recording. To use GUI Script Recording with Winshuttle Transaction, the scripting parameter must be…
Read article →PowerShell Lesson 4: Variables, Arrays, Hash Tables, Loops and Conditions
PowerShell Lesson 4: Variables, Arrays, Hash Tables, Loops and Conditions
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 →PowerShell Lesson 3: The Pipeline — Filtering, Sorting, Selecting and Custom Objects
PowerShell Lesson 3: The Pipeline — Filtering, Sorting, Selecting and Custom Objects
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 →ISNONTEXT Function in Excel: Anything But Text
ISNONTEXT Function in Excel: Anything But Text
ISNONTEXT is TRUE for numbers, blanks, errors and logicals. Handy in data validation to block text in amount columns.
Read article →SAP GUI Scripting Lesson 4: Running SAP From Excel VBA
SAP GUI Scripting Lesson 4: Running SAP From Excel VBA
Drive SAP from an Excel macro: attach to the running session, read selection values from cells, run the report, and handle the most common…
Read article →PowerShell Lesson 2: Files and Folders — Managing, Filtering and Bulk Renaming
PowerShell Lesson 2: Files and Folders — Managing, Filtering and Bulk Renaming
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 →BINOMDIST Function in Excel: Binomial Probability (Older Name)
BINOMDIST Function in Excel: Binomial Probability (Older Name)
BINOMDIST returns the binomial probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →