Linux Server Basics: 15 Commands Every Website Owner Needs
The Linux commands you actually need to look after a small website server: disk space, memory, logs, services, permissions, updates and safe file editing…
Read article →SAP Fiori Launchpad for Business Users: Spaces, Tiles and Search
SAP Fiori Launchpad for Business Users: Spaces, Tiles and Search
Find your way around the SAP Fiori launchpad: spaces and pages, tiles and KPIs, enterprise search, personalising your home page and when to fall…
Read article →SAP FICO for Finance Users: GL, AP, AR, Cost Centres and the Reports You Will Use
SAP FICO for Finance Users: GL, AP, AR, Cost Centres and the Reports You Will Use
A plain-English tour of SAP FI and CO for accountants: company codes, GL accounts, document types, vendor and customer processes, cost centres and profit…
Read article →HYPERLINK Function in Excel: Clickable Links From a Formula
HYPERLINK Function in Excel: Clickable Links From a Formula
HYPERLINK builds a clickable link — to websites, files, or other sheets in the same workbook.
Read article →NORMDIST Function in Excel: Normal Distribution (Older Name)
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 →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 →