0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Efficiency Best Practices for Microsoft 365

You're reading from Efficiency Best Practices for Microsoft 365 Discover ways to improve your efficiency and save time using M365 applications

Product type Paperback

Published in Dec 2021

Publisher Packt

ISBN-13 9781801072267

Length 350 pages

Edition 1st Edition

Tools

Office 365

Concepts

Information Management

Author (1):

Dr. Nitin Paranjape

View More author details

Table of Contents (15) Chapters

Preface

1. Section 1: Efficient Content Creation

2. Chapter 1: Fortunately, You're Inefficient! FREE CHAPTER

3. Chapter 2: Components of Work

4. Chapter 3: Creating Content for Effective Communication

5. Chapter 4: Intelligent Data Analysis

6. Chapter 5: Managing Files Efficiently

7. Section 2: Efficient Collaboration

8. Chapter 6: Time and Task Management

9. Chapter 7: Efficient Teamwork and Meetings

10. Section 3: Integration

11. Chapter 8: Automating Work without Programming

12. Chapter 9: Putting It All Together

13. Chapter 10: Maximizing Efficiency across the Organization

14. Other Books You May Enjoy

Packt is searching for authors like you

Importing and cleaning up using Power Query

Power Query enables amazingly fast data cleanup – no manual work, no complex formulas, no macros, no programming. Introducing "Power Query" – your complete data cleanup toolkit!

If you have older versions of Excel, you can download and install the Power Query add-in: https://www.microsoft.com/en-in/download/details.aspx?id=39379. This will add a separate Power Query tab. In both cases, the features are similar.

With Excel 2016 upward, Power Query is available in the Data tab | Get & Transform Data. This replaces the old Get External Data option.

Figure 4.9 – Get & Transform Data

You can import from 40+ data sources – flat files, databases, PDFs, web pages, and more. Once you specify the source, the powerful cleanup tool – Power Query – opens.

There are numerous data cleanup requirements. We cannot cover all of them here. However, you can see...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Dr. Nitin Paranjape

Dr. Nitin Paranjape

Dr. Nitin Paranjape (Doc) completed his post-graduation in medicine – obstetrics and gynecology (he did complete it!) – in Mumbai, India. Technology was his hobby. Initially, he developed many medical applications, first on the Sinclair Spectrum and then on PCs. Soon he expanded to corporate IT. His organization (Mediline) was one of the earliest partners of Microsoft in India. For 15 years, he was considered to be the pioneer of the entire Microsoft platform, cutting across programming tools, databases, infrastructure, and Office. However, he noticed that most of the technologies were largely underutilized – due to which people were still inefficient. Therefore, he changed his focus to the most commonly used (and most underused) tool in the world – Microsoft Office. Now, he is known as the Productivity Guru and Dr. Productivity. He has coached over 400,000 professionals across 3,000+ customers in 18 countries. He even coaches Microsoft's own staff and partners about the effective utilization of the Microsoft 365 platform. Having authored 700+ articles in print and 1,000+ blogs, he is a prolific writer, a sought-after orator, and an accomplished speaker. He uses a simple, down-to-earth, humorous storytelling style enhanced with live demos to educate and empower his audience. Customers call his sessions a “magic show!”. He is also a PROSCI-certified change management consultant. Doc's passion is to improve the efficiency of every user of the Office platform. This book is the distillation of his knowledge and experience gained over 30 years of work.

See other products by Dr. Nitin Paranjape

Personalised recommendations for you

Based on your interests and search pattern

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Architecting Salesforce Success

Architecting Salesforce Success

This book provides you with a roadmap to becoming a successful Salesforce Architect. Covering common pitfalls and valuable insights, this book prepares you to transition to the role of a Salesforce Architect.

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design walks interior designers and architects through SketchUp Pro and Studio at an intermediate+ level, covering topics and tools specific to the world of design.

Jun 2024 19h 56m

Power Platform and the AI Revolution

Power Platform and the AI Revolution

Learn how to integrate cutting-edge AI technology into business operations and tap into AI services within Power Platform to enable automation and develop apps and chatbots to achieve heightened productivity and efficiency.

May 2024 11h 52m

Mastering Project Management with ClickUp for Work and Home Life Balance

Mastering Project Management with ClickUp for Work and Home Life Balance

This book will guide you in using ClickUp to become a power user of your life. You'll learn practical strategies for setup, project management, and AI integration to optimize workflow, boost productivity, and manage time effectively.

Jun 2024 10h 16m

Mastering UI Development with Unity

Mastering UI Development with Unity

With Unity's robust toolkit, you can create visually appealing UIs to give your games a professional look and feel. This book will help you realize the full potential of the UI systems provided by Unity, so you can create the best UI for your games.

Jun 2024 21h 16m

Autodesk Civil 3D 2025 Unleashed

Autodesk Civil 3D 2025 Unleashed

This book is a comprehensive guide to using Autodesk Civil 3D. You'll progress from design customization with extensions and information management to project extension, preparing you for a successful career in civil engineering.

Jul 2024 10h 28m

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud covers every facet of the platform, from technical reviews to implementation, business transformation, and long-term growth strategies. Learn to maximize the potential of Salesforce Experience Cloud.

Oct 2024 10h 56m

Mastering the Art of Sales Engineering

Mastering the Art of Sales Engineering

This book covers what a sales engineer is and does, and why this is a highly paid and coveted role. The authors share their vast experience to help you learn daily operations and skills to advance your sales career.

Sep 2024 10h 32m

Taking Tinkercad to the Next Level

Taking Tinkercad to the Next Level

Tinkercad users familiar with the basic functionality will learn to create complex shapes and multi-part designs with this book on advanced modeling. It covers strategies and techniques for modeling and designing for production with 3D printers.

Sep 2024 13h 56m