Book Image

Efficiency Best Practices for Microsoft 365

By : Dr. Nitin Paranjape
Book Image

Efficiency Best Practices for Microsoft 365

By: Dr. Nitin Paranjape

Overview of this book

Efficiency Best Practices for Microsoft 365 covers the entire range of over 25 desktop and mobile applications on the Microsoft 365 platform. This book will provide simple, immediately usable, and authoritative guidance to help you save at least 20 minutes every day, advance in your career, and achieve business growth. You'll start by covering components and tasks such as creating and storing files and then move on to data management and data analysis. As you progress through the chapters, you'll learn how to manage, monitor, and execute your tasks efficiently, focusing on creating a master task list, linking notes to meetings, and more. The book also guides you through handling projects involving many people and external contractors/agencies; you'll explore effective email communication, meeting management, and open collaboration across the organization. You'll also learn how to automate different repetitive tasks quickly and easily, even if you’re not a programmer, transforming the way you import, clean, and analyze data. By the end of this Microsoft 365 book, you'll have gained the skills you need to improve efficiency with the help of expert tips and techniques for using M365 apps.
Table of Contents (15 chapters)
1
Section 1: Efficient Content Creation
7
Section 2: Efficient Collaboration
10
Section 3: Integration

Which Excel functions to learn and how

We have only covered the analytics part of Excel. But what about the 650+ Excel functions? Before you say, "Oh, I do not need so many," just relax. You do not need to learn all the functions. However, it should not be the case that you need a function but do not know that it exists. That is inefficiency!

The only way to know the functions you need is to just look at all of them once and shortlist the ones that are useful to you. Just spend 20 minutes doing this exercise.

Shortlisting useful functions

Now let's explore and find the functions which appear to be useful and relevant for your work:

  1. Open a Word document (or better still, a OneNote page). You will add the names of useful functions to it.
  2. Add a table with two columns – Function Name and Where can I use it. Go to the Formulas menu and choose Insert Function. You will see a list of the most recently used functions. Let...