The short & spicy series deals with topics which are in the focus of office trainings the author gives since many years. Small booklets one can read in the commuter or as e-book. Originally published in German, they are translated by the author herself and therefore, some minor mistakes will add to the fun.

The first books are available at Amazon only. Beginning from vol 3, there are worldwide available in local stores and online through many distributors. If you live in the US, you can alternatively support independant bookshops by ordering from my website there.

For all books that come with sample data, find here a zip to download.

New ways to go!

You're working with Excel since long, but would like some fresh inspiration? You had an Excel training 15 years ago and wonder what all these new buttons could do for you? Then, this book is for you!
We'll be looking at all new topics from Excel 2007 onwards: Matrix operations, Flash Fill, Conditional Formatting, Sparklines, new formulas and much more. All explained using clear examples, suitable for normal users and insiders.
Printed and as e-book.
Soon at Amazon and printed already in selected shops worldwide.
Example data can be downloaded clicking here.

Outlook 2021 as your personal assistant

Nope, it won't make you a coffee right now. But Outlook can write, sort and tag your mail, find lost items, maybe throw away stuff instantly or re-present it at the time you find it suitable. More than that, Outlook can organize appointments, deliver route planning, present pictures of your contacts and much more.
Printed and as e-book.
At Amazon and in selected shops worldwide.
For this book, you only need your own Outlook.

Pivot for office workers

In today's offices, much time is spent finding and structuring information in given data. Pivot Tables and Charts are the tool of choice to get it done. Their result often looks impressive, making people think it takes tremendous skills setting them up. It doesn't! They're easy, if only you know what result you're looking for.
In this booklet you learn everything to transform a simple Excel list to a telling Pivot Table and Chart!
Printed and as e-book.
At Amazon and in selected shops worldwide.
Example data can be downloaded clicking here.

Outlook 365 As Your Personal Assistant

Nope, it won't make you a coffee right now. But Outlook can write, sort and tag your mail, find lost items, maybe throw away stuff instantly or re-present it at the time you find it suitable. More than that, Outlook can organize appointments, deliver route planning, present pictures of your contacts and much more.
Printed and as e-book.
Full colour print. At Amazon and in selected shops worldwide.
For this book, there is no example data.

How to get Instant Overview in Excel 365 and 2021

Often, Excel is used to evaluate given data. Which values are critical? Can I see at a glance what the development was like? Can I highlight a whole row if one column has important content? Or ask for the content of two cells, simultaneously? How do I get overview in a thick workbook? How do I get a clear and telling chart? Is there anything as clear, but not as large as a diagram? Can I ask Excel in natural language without any formula?
All these questions are answered here.
Printed and as e-book.
Full colour print. At Amazon and in selected shops worldwide.
Example data can be downloaded clicking here.

Roll away the boring stuff! in Excel 365 and 2021

Too often, users need to perform the same tasks again and again. It's not only boring, it takes up the time that could be used differently!
In this book, you will learn how to do less typing, how Excel can insert formattings and calculations for you, how to establish best relationships between cells, how to adjust table data, that is provided in a less than perfect way and how to arrange the Excel window in a way to find desired features quicker.
Printed and as e-book.
At Amazon and in selected shops worldwide.
Example data can be downloaded clicking here.

How to Create Explainer Videos

To explain complex context and relations, there is a tool already on each office workplace: PowerPoint. But many users are not aware of what it can really achieve: not only record anything of what one does on the screen - it also can do videos with intricate animations. Elements can be displayed or hidden, created step by step or morph one to another. The audience will focus on the subject, the message is clear and the larger context will be understood.
This booklet concentrates on creating videos for teaching and demonstration. No other hard- or software needed. The resulting videos can be stored or shared anywhere you like.
Printed and as e-book.
Full colour print. At Amazon and in selected shops worldwide.
Example data can be downloaded clicking here.

Queries, VLookup, XLookup & Co.

Excel can take large data sets. But getting hold of required data can be tricky. Here, different possibilities are explained: The filter and the VLOOKUP() which are often heard of, but not really mastered. But there are more options like the Advanced filter, IF(), Database functions and the new, cutting-edge ones like SWITCH() and the brand new, very convenient XLOOKUP().
All are explained with examples and their specific benefits and downsides in full colour print.
Printed and as e-book.
From £ 5,99 at Amazon and in selected shops worldwide.
Example data can be downloaded clicking here.

Text Processing for students

Long and structured texts can be tricky. Not only regarding the technical content, also regarding layout and usability. Still, everything can integrate smoothly and look professional, if everything is properly prepared.
Here, we are looking at all the parts required for technical and scientific texts: Styles, figures, tables of content, covers and oversized items to be printed crosswise. Additionally, ways to co-operate and meanwhile keep track of changes.
Now, every author can concentrate solely on the factual content!
Printed and as e-book.
From £ 3,99 at Amazon and in selected shops worldwide.
There is no example data for this book.

How to avoid mistakes

Nobody intends to make mistakes. Still, they happen. Sometimes users may not be aware of requirements or make typos. What begins as a small error, later leads to unnecessary work that costs time, money, and nerves. Here, you'll learn how to guide users in a way that makes errors less likely or even impossible. Or to inform them on input what's required. In other cases, you may want to prepare data for decision making in a way that one does not need actual typing anymore.
And of course, there are the new cloud functionalities of Excel 365 opening new dimensions of co-operations. All of this is explained here.
Printed and as e-book.
From £ 3,99 at Amazon and in selected shops worldwide.
Example data can be downloaded clicking here.

Instant Overview

Often, Excel is used to evaluate given data. Which values are critical? Can I see at a glance what the development was like? Can I highlight a whole row if one column has important content? Or ask for the content of two cells, simultaneously? How do I get overview in a thick workbook? How do I get a clear and telling chart? Is there anything as clear, but not as large as a diagram? Can I ask Excel in natural language without any formula?
All these questions are answered here.
Printed and as e-book.
From £ 3,99 at Amazon and in selected shops worldwide.
Example data can be downloaded clicking here.

Roll away the boring stuff!

Too often, users need to perform the same tasks again and again. It's not only boring, it takes up the time that could be used differently!
In this book, you will learn how to do less typing, how Excel can insert formattings and calculations for you, how to establish best relationships between cells, how to adjust table data, that is provided in a less than perfect way and how to arrange the Excel window in a way to find desired features quicker.
Printed and as e-book.
From £ 3,99 at Amazon and in selected shops worldwide.
Example data can be downloaded clicking here.

How to Create Explainer Videos

To explain complex context and relations, there is a tool already on each office workplace: PowerPoint. But many users are not aware of what it can really achieve: not only record anything of what one does on the screen - it also can do videos with intricate animations. Elements can be displayed or hidden, created step by step or morph one to another. The audience will focus on the subject, the message is clear and the larger context will be understood. This booklet concentrates on creating videos for teaching and demonstration. No other hard- or software needed. The resulting videos can be stored or shared anywhere you like.
Printed and as e-book.
From £ 3,99 exclusively at Amazon and in selected shops worldwide.
Example data can be downloaded clicking here.

Outlook 365 As Your Personal Assistant

Nope, it won't make you a coffee right now. But it can sort and tag your mail, find lost items, maybe throw away stuff  instantly or re-present it at the time you find it suitable. More than that, Outlook can organize appointments, deliver route planning, present pictures of your contacts and much more.
This book contains everything that is new so far in Outlook 365 and will be updated when ever something new comes along.
Printed and as e-book.
From £ 3,99 at Amazon and in selected shops worldwide.

The Digital Notebook

To keep information snippets in a notebook that can't be lost, that always stays up to date, that does not get dog-ears, can reach any size and takes texts, pictures, videos and sounds, shares and finds them - that would be great! You have such a notebook in Windows 10, but only few use it. If you want to make it communicate with Outlook, take OneNote 2016 to unfold the whole potential of co-operation. There are only two types of people: the ones who love OneNote and the others who do not know it yet. It's easy to learn. In this booklet you'll find all important topics.
Printed and as e-book.
From £ 3,99 at Amazon and in selected shops worldwide.

Office 365 - What's new?

The new office package is continuously changing. New features are supplied frequently and provide novelties to useser and administrators alike. This booklet supplies all novelties in Word, Excel, Outlook and PowerPoint - and entirely the novelties. It makes it easy for you to make up your mind what's in for you and what new possibilities will be at your disposal. You will remain on top of the game!
Edition of February 2020!
For Office 365, printed and as e-book.
From £ 3,99 at Amazon and in selected shops worldwide.
No Example data. For a Zoom and Morph video click here.

Office 2019 - What's new?

The new Office 2019 package offers innovations in all it's parts: One now can use 3D objects and move them as desired or display one's geographical Excel data on a map. In Word and Outlook, you can have your texts read aloud and Outlook finally received handy text modules. This and much more is presented and explained here.
For Office 2019, printed and as e-book.
From £ 2,99 exclusively at Amazon.
Example data here, for the Zoom and Morph video click here.

Outlook as your personal assistant: for Outlook 2010, 2013 and 2016

Nope, it won't make you a coffee right now. But it can sort and tag your mail, find lost items, maybe throw stuff instantly away or re-present it at the time you find it suitable. More than that, Outlook can organize appointments, deliver route planning, present pictures of your contacts and much more.
Here, you get a range of ideas and suggestions on how to tell Outlook your wishes and how to fulfill them.
For Outlook 2010, 2013 and 2016, printed and as e-book.
From £ 2,99, printed and as ebook exclusively at Amazon.