Discover millions of ebooks, audiobooks, and so much more with a free trial

Only $11.99/month after trial. Cancel anytime.

How to avoid mistakes: in Excel 365 and 2019
Office 365: What's new?
The Digital Notebook: OneNote in Windows and Office,  with introduction to Class Notebook
Ebook series11 titles

Short & Spicy Series

By Ina Koys and Koys

Rating: 0 out of 5 stars

()

About this series

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 a

LanguageEnglish
Release dateFeb 26, 2021
How to avoid mistakes: in Excel 365 and 2019
Office 365: What's new?
The Digital Notebook: OneNote in Windows and Office,  with introduction to Class Notebook

Titles in the series (12)

  • The Digital Notebook: OneNote in Windows and Office, with introduction to Class Notebook

    4

    The Digital Notebook: OneNote in Windows and Office,  with introduction to Class Notebook
    The Digital Notebook: OneNote in Windows and Office,  with introduction to Class 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 quickly - 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

  • How to avoid mistakes: in Excel 365 and 2019

    9

    How to avoid mistakes: in Excel 365 and 2019
    How to avoid mistakes: in Excel 365 and 2019

    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 r

  • Office 365: What's new?

    3

    Office 365: What's new?
    Office 365: What's new?

    The new office package is continuously changing. New features are supplied frequently and provide new possibilities to users 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 possibili

  • Text Processing for Students: using Word 365

    10

    Text Processing for Students: using Word 365
    Text Processing for Students: using Word 365

    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 conten

  • Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 and 2021

    11

    Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 and 2021
    Queries, VLookup, XLookup & Co.: Find information and match values in Excel 365 and 2021

    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,

  • How to create Explainer Videos: in PowerPoint 365 and 2021

    12

    How to create Explainer Videos: in PowerPoint 365 and 2021
    How to create Explainer Videos: in PowerPoint 365 and 2021

    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

  • Roll away the boring stuff!: in Excel 365 and 2021

    13

    Roll away the boring stuff!: in Excel 365 and 2021
    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,

  • Outlook 365: as your personal Assistant

    15

    Outlook 365: as your personal Assistant
    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.  

  • Pivot for office workers: Using Excel 365 and 2021

    16

    Pivot for office workers: Using Excel 365 and 2021
    Pivot for office workers: Using Excel 365 and 2021

    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 book

  • Outlook 2021: as your personal assistant

    17

    Outlook 2021: as your personal assistant
    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.  

  • New ways to go!: Modern Excel features making your work easier

    18

    New ways to go!: Modern Excel features making your work easier
    New ways to go!: Modern Excel features making your work easier

    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 a

Author

Ina Koys

Ina Koys is an experienced instructor for Microsoft Office. Many questions are frequently asked in trainings, but seldom covered in books. Now she answers some of them in her originally German "short & spicy" series. A little accent will add to the fun :-)

Related to Short & Spicy

Related ebooks

Enterprise Applications For You

View More

Related categories

Reviews for Short & Spicy

Rating: 0 out of 5 stars
0 ratings

0 ratings0 reviews

What did you think?

Tap to rate

Review must be at least 10 words