Skip to main content

SafeOffice HelpMe Portal

EN | DE

Go to Safeoffice Go to Project-Management

Secure Login

Excel Basics Basics Formulas & Functions Formulas Data Management & Solutions Data M&S Privacy & Compliance P&C Corporate Documentation Corp. Docs

← Back to Portal

Excel Basics

Volatile Functions in Excel — What They Are and When to Avoid Them
How to Work with Dates and Times in Excel
Boolean Logic - TRUE or FALSE
How to Enter and Edit Data Correctly in Excel
Excel 365 vs Older Excel — Why the Upgrade Actually Pays for Itself

Formulas & Functions

How to Use MAXIFS and MINIFS in Excel: Find the Highest and Lowest with Conditions
How to Use COUNTIFS and AVERAGEIFS in Excel: Count and Average with Multiple Criteria
How to Use SUMPRODUCT in Excel: Multiply, Sum, and Count with Conditions in One Cell
How to Use SUMIFS to Sum with Multiple Criteria in Excel
XLOOKUP explained — exact matches, banded lookups, returning whole rows, and the INDEX/MATCH fallback for older Excel versions
How to Parse and Combine Text with Formulas
How to Use the SWITCH Function Instead of Nested IF in Excel
How to Automate Reports with Dynamic Arrays and Tables
How to Use TEXTSPLIT, TEXTBEFORE, TEXTAFTER, and Combine Them Effectively
How to Filter Data with the FILTER Function Using One or More Criteria and Dropdown Lists
What Is a Recursive LAMBDA Function — and How to Use It Effectively
Budget vs Actual | (Part 04) Variance Report & Ledger
Formula Analysis
Budget vs Actual | (Part 03) Actual Cost Matrix
Budget vs Actual | (Part 02) Building the Cost Baseline
Budget vs Actual | (Part 01) The Architecture
LET Function: Faster Monthly Reports
Cell references in Excel: relative, absolute, mixed, and the special operators $, # and @
How to use LET: write cleaner and faster formulas
How to handle errors in Excel formulas — IFERROR, IFNA, ISERROR, ISERR, ISNA and when not to hide errors at all
Dynamic Arrays: Filter, Sort & Unique

list of articles

Data Management & Solutions

The Excel Name Manager: Named Ranges, Named Formulas and LAMBDA — Benefits and Pitfalls
Power Pivot and the Data Model in Excel: A Beginner's Guide
How to Combine Data from Multiple Sheets into One with Dynamic Arrays
Excel Data Validation & Dependent Lists
Data bars, colour scales and sparklines: data visualisation in Excel that doesn't use traditional charts.
Conditional formatting and custom cell formats in Excel — icons, colour rules, and data visualisation without charts
Workbook Analysis (FastExcel)
When VBA is too risky and every task needs not Excel but a working application
How to use Excel Tables: why every dataset should be in Table format
How to structure an Excel workbook. The four-layer architecture for maintainable spreadsheets.
How to clean messy data in Excel. Remove duplicates, trim spaces, fix formats

list of articles

Privacy & Compliance

Copilot in Excel and GDPR — what European businesses need to know

Corporate Documentation

Legal Notice
Privacy Policy
About SafeOffice

HOME / ARTICLE

Unauthorized Access

You must be signed in with corporate clearance to view this knowledge base article.

© 2026 SafeOffice. All rights reserved.

Go to SafeOffice DataTables | Legal Notice Privacy Policy

Secure Contact

Get in touch with me securely via my preferred channels. | Bitte kontaktieren Sie mich auf sicherem Wege. Nutzen Sie dazu meine bevorzugten Kanäle.

Email

[Secure Email]

Signal

[Scrambled]

Matrix

[Scrambled]

Cookie Notice SafeOffice explicitly rejects all marketing cookies and trackers out of deep respect for your fundamental right to digital privacy. We only utilize strict sessions necessary for portal authentication. Read my Security Policy.