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
Titles in the series (12)
- Office 365: What's new?
3
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
- How to avoid mistakes: in Excel 365 and 2019
9
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
- The Digital Notebook: OneNote in Windows and Office, with introduction to Class Notebook
4
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
- Text Processing for Students: using Word 365
10
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
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
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
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 2021: as your personal assistant
17
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.
- Outlook 365: as your personal Assistant
15
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
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
- New ways to go!: Modern Excel features making your work easier
18
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
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
Blackbeard Legacy #2 Volume 2 Rating: 0 out of 5 stars0 ratingsViolet Rose #0 Rating: 0 out of 5 stars0 ratingsThe Blue Meteor Rating: 0 out of 5 stars0 ratingsLegend of Isis #6: Volume 2 Rating: 0 out of 5 stars0 ratingsPAYBACK: Opportunity. Greed. Betrayal. Rating: 0 out of 5 stars0 ratingsFAME: Psy Rating: 0 out of 5 stars0 ratingsFemale Force: Gabrielle Giffords Rating: 0 out of 5 stars0 ratingsSpace Women Beyond the Stratosphere #3 Rating: 0 out of 5 stars0 ratingsMy Sonoma - Valley of the Moon Rating: 0 out of 5 stars0 ratingsOrbit: Mark Zuckerberg, Creator of Facebook Rating: 0 out of 5 stars0 ratingsFabulous Beekman Boys Present: Polka Spot #3 Rating: 0 out of 5 stars0 ratingsTwiglet: The Little Christmas Tree Rating: 0 out of 5 stars0 ratingsStep By Step to Solve Word Problems Rating: 0 out of 5 stars0 ratingsHolding Forth the Word of Life Rating: 0 out of 5 stars0 ratingsNanny & Hank #3 Rating: 0 out of 5 stars0 ratingsOdyssey Presents: Anthology #2 Rating: 0 out of 5 stars0 ratingsWhat Squirt Teaches Me about Jesus: Kids Learning about Jesus while Playing with Fido Rating: 0 out of 5 stars0 ratingsGabriel: The Shattered Star Rating: 0 out of 5 stars0 ratingsBehind the Scenes at Sega: The Making of a Video Game Rating: 0 out of 5 stars0 ratingsOdyssey Presents: Anthology #1 Rating: 0 out of 5 stars0 ratingsVincent Price Presents: Gallery #4 Rating: 0 out of 5 stars0 ratingsDelightful Questions for Children Rating: 0 out of 5 stars0 ratings10 Things You Should Know About Rating: 0 out of 5 stars0 ratingsChildren's Ten Commandments Rating: 0 out of 5 stars0 ratingsTHE JOSHUA GENERATION Rating: 5 out of 5 stars5/5Legend of Isis: Darkness Falls Rating: 0 out of 5 stars0 ratingsAdventure Awaits: Around the World Rating: 0 out of 5 stars0 ratingsMessages from the Heart of Love - Spirituality Basics in 144 Empowering Quotes Rating: 0 out of 5 stars0 ratingsMonster’s Among Us: A War of Witches Rating: 0 out of 5 stars0 ratingsLegend of Isis: Image Introduces Rating: 0 out of 5 stars0 ratings
Enterprise Applications For You
QuickBooks 2024 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsExcel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsCreating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsSome Future Day: How AI Is Going to Change Everything Rating: 0 out of 5 stars0 ratingsExcel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5SharePoint For Dummies Rating: 0 out of 5 stars0 ratingsAccess 2019 For Dummies Rating: 0 out of 5 stars0 ratingsExcel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Excel Tips and Tricks Rating: 0 out of 5 stars0 ratingsExcel All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsBitcoin For Dummies Rating: 4 out of 5 stars4/5Enterprise AI For Dummies Rating: 3 out of 5 stars3/550 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5102 Useful Excel 365 Functions: Excel 365 Essentials, #3 Rating: 0 out of 5 stars0 ratingsQuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsLearning Microsoft Endpoint Manager: Unified Endpoint Management with Intune and the Enterprise Mobility + Security Suite Rating: 0 out of 5 stars0 ratingsExcel 2016 For Dummies Rating: 4 out of 5 stars4/5Code like a Pro in C# Rating: 4 out of 5 stars4/5Statistical Analysis with Excel For Dummies Rating: 3 out of 5 stars3/5CompTIA Project+ Study Guide: Exam PK0-005 Rating: 0 out of 5 stars0 ratings101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5QuickBooks Online For Dummies, 2025 Edition Rating: 5 out of 5 stars5/5Excel 2019 Bible Rating: 5 out of 5 stars5/5
Related categories
Reviews for Short & Spicy
0 ratings0 reviews