Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Microsoft 365 Fundamentals Guide

You're reading from  Microsoft 365 Fundamentals Guide

Product type Book
Published in May 2022
Publisher Packt
ISBN-13 9781801070195
Pages 278 pages
Edition 1st Edition
Languages
Authors (2):
Gustavo Moraes Gustavo Moraes
Profile icon Gustavo Moraes
Douglas Romao Douglas Romao
Profile icon Douglas Romao
View More author details

Table of Contents (18) Chapters

Preface 1. Chapter 1: Licensing Microsoft 365 2. Chapter 2: Organizing and Finding Information with Microsoft Delve 3. Chapter 3: Workplace and Personal Productivity with Microsoft MyAnalytics 4. Chapter 4: Staying on Top of Emails and Calendars with Microsoft Outlook 5. Chapter 5: Taking and Sharing Notes with Microsoft OneNote 6. Chapter 6: Working from Anywhere with Microsoft OneDrive 7. Chapter 7: Collaboration and Ideation with Microsoft Whiteboard 8. Chapter 8: Microsoft SharePoint Online (SPO) 9. Chapter 9: Working Together with Microsoft Teams 10. Chapter 10: Managing Projects and Tasks with Microsoft Planner and To-Do 11. Chapter 11: Doing More with Microsoft Power Automate 12. Chapter 12: Power Apps 13. Chapter 13: Getting Information with Microsoft Forms 14. Chapter 14: Visualizing Data with Microsoft Power BI 15. Chapter 15: QuickStart Excel, Word, and PowerPoint 16. Other Books You May Enjoy Appendix

Excel – using Flash Fill

Flash Fill is one of the most sensational features of Excel. Besides being very easy to use, it brings us incredible productivity. It is a relatively old feature (Excel 2013), but I only discovered it about 2 years ago, and since then, I have used it for several situations. It is possible that you don't know about it either, but after this topic, you will have a greater appreciation for Excel.

Let's imagine that I am publishing an article where I must fill in all the bibliographic references of books I used. The references have a pattern, and I only have the complete information, but they are not standardized. Normally, a referencing style pattern is LASTNAME, Name. Book Name (Year).

I have built a spreadsheet with a list of books, as shown in Figure 15.16. For brevity's sake, I have only used a few books in this example, but in a published article, numerous references would probably be used:

Figure 15...

lock icon 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
Renews at $15.99/month. Cancel anytime}