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

Clean data checklist

Data can be text, numbers, dates, and so on. Just entering or importing the data into Excel (or any other spreadsheet) is not enough. The data must be CLEAN. Unfortunately, hitherto, there has not been any simple definition of what clean means. Here is a simple 11-item checklist.

If your data passes each item, then it is clean. Here is the checklist:

It is important to understand this concept. Watch this video to see examples of each item. The video shows each rule with sample data and explains why it is important to follow the rule. It shows the wrong format first. It explains why it is wrong and then shows the correct format.

hi.switchy.io/excd

You should compare these examples with your own data and learn how to apply these rules.

How to use this checklist

Look at your data – each column as well as overall. Check which items are not right and then clean them up or repair...