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 →IMPORTCSV Function in Excel: Import a CSV File Into the Grid
IMPORTCSV Function in Excel: Import a CSV File Into the Grid
IMPORTCSV (2026) is the simple version of IMPORTTEXT for standard CSV files: one argument, a refreshable dynamic array.
Read article →SAP Transaction Codes Every Business User Should Know
SAP Transaction Codes Every Business User Should Know
A practical cheat sheet of SAP transaction codes for finance, purchasing, sales and reporting users — plus the navigation tricks that save time every…
Read article →PowerShell Lesson 1: Basics — Cmdlets, Discovery and Execution Policies
PowerShell Lesson 1: Basics — Cmdlets, Discovery and Execution Policies
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 →From GPT-1 to GPT-5: The Complete History of OpenAI’s GPT and ChatGPT
From GPT-1 to GPT-5: The Complete History of OpenAI’s GPT and ChatGPT
How OpenAI’s GPT models evolved — GPT-1, GPT-2, GPT-3, ChatGPT, GPT-4, GPT-4o, the o-series reasoning models, open-weight gpt-oss and GPT-5 — with what each…
Read article →NORMSINV Function in Excel: Inverse Standard Normal (Older Name)
NORMSINV Function in Excel: Inverse Standard Normal (Older Name)
NORMSINV returns z for a probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →TIMEVALUE Function in Excel: Text Time to Real Time
TIMEVALUE Function in Excel: Text Time to Real Time
DateLevel: IntermediateAvailable in: Excel 2007+TIMEVALUE turns text like "2:45 PM" into a real time you can add and.
Read article →BINOM.DIST Function in Excel: Chance of Exactly k Successes
BINOM.DIST Function in Excel: Chance of Exactly k Successes
BINOM.DIST handles yes/no events with a fixed chance — defects in a batch, customers who convert.
Read article →CONFIDENCE Function in Excel: Margin of Error (Older Name)
CONFIDENCE Function in Excel: Margin of Error (Older Name)
CONFIDENCE returns the normal margin of error for a mean. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →