Among the latest additions to the Excel family of dynamic array functions are two aggregation tools: GROUPBY and PIVOTBY. While useful in their basic form, they truly shine when paired with custom Lambda functions, enabling you to summarize data in ways not possible with predefined Eta lambdas. Continue reading
One of the most useful features of the classic Outlook app is the ability to perform multiple tasks in one quick step. Now, Quick Steps are also available in the new Outlook app and web version, letting you execute a series of email actions with a single click. Continue reading
When you are facing some unexpected issue in Outlook, such as email rules not working, a new account not adding, or your inbox not updating, the culprit could often be an outdated Outlook version. Keeping your application current is not just about accessing new features, it's also about safeguarding the stability and security of your email communication. Continue reading
With the introduction of the new Outlook app, many users are excited to see what it brings to the table. However, an immediate switch isn't always practical. Whether it's for feature comparison, functionality testing, or facilitating the transition, running both the old and new Outlook side by side can be incredibly useful. Continue reading
Tired of losing data when merging cells in Google Sheets? Explore all-time favorite methods, from built-in tools to a game-changing add-on. Continue reading
Learn how to turn your data into clear and colorful summary reports using GROUPBY and PIVOTBY formulas, enhanced with conditional formatting. Continue reading
Blank rows and cells in Google Sheets aren't just an eyesore – they can also cause calculation errors and data inconsistencies. In this guide, we'll explore several easy ways to delete empty rows and cells so you have accurate and reliable data. No coding or Apps Script, promise 😉 Continue reading
Embedding HTML into Outlook can enhance the visual appeal and functionality of your messages enormously. Imagine transforming your emails from plain text to visually stunning, professional communications that capture your audience's attention from the very first line. Continue reading
Once you've switched to the new Outlook app, the first thing you'll need to do is to familiarize yourself with the ribbon – again! This guide aims to provide you with a comprehensive overview of the ribbon's features, customization options, and enhancements that the new Outlook ribbon offers. Continue reading
For decades, Excel users have relied on pivot tables to transform rows and columns of information into meaningful reports. Now, there's something even better: the new PIVOTBY function. This handy tool lets you summarize and analyze data right within a formula without the need for separate pivot tables. Continue reading
Sorting data in Google Sheets doesn't have to be daunting. Especially since spreadsheets provide all the right techniques and tools for the task. And in this guide, I will prove just that. Continue reading
In classic Outlook, conditional formatting has been a staple for years, allowing users to customize the appearance of their emails based on specific criteria. Finally, this long-awaited feature is available in the new Outlook app and on the web, bringing a familiar sense of organization and personalization. Continue reading
Microsoft Excel has always been great for sorting through lots of data and making sense of it. But now, there's a simple way to do it all with just a formula. Introducing the GROUPBY function – a handy and efficient tool to group and aggregate data without leaving the comfort of your formula bar. Continue reading
The management of multiple email accounts in Outlook is a crucial feature for professional users. At the heart of this multi-account functionality lies the concept of the primary account. Understanding what a primary account is and its significance is essential for staying in control of your email communication. Continue reading
Struggling to add an account to the new Outlook? You're not alone! We've put together a handy guide to troubleshoot common issues and their solutions. Continue reading
As users make the switch to the new Outlook app, they're greeted with a refreshed interface that emphasizes modern design and ease of use. Whether you're adding a work account or consolidating personal emails, the new Outlook app caters to your needs with its intuitive and user-friendly approach. Continue reading
Ever stumbled upon an email in Outlook that's too good to just sit in your inbox? Maybe it's a crucial work contract, a cherished recipe from grandma, or a funny meme from a friend. Whatever it is, get ready to discover the super easy technique to convert that email into a PDF. Continue reading
Microsoft Outlook offers great convenience in organizing contacts digitally, but sometimes you might need a paper copy. This guide will walk through the simple steps to transform your virtual network into a neatly organized tangible list. Continue reading
First and foremost, Outlook is designed for managing schedules digitally. But sometimes it's necessary to have a hard copy of your planned events for those moments when you're away from the screen. Continue reading
Printing emails in Microsoft Outlook is a simple task once you know the steps. This comprehensive guide will help you navigate the Outlook interface with ease, select the right print settings and bring a message to life on paper. Continue reading
Time zones can be a source of confusion and frustration, especially when managing a busy schedule across different regions. Whether you're a frequent traveler or working with international teams, adjusting the time zone in Outlook is essential to keep your schedule in sync. Continue reading
Balancing multiple email accounts can often feel like juggling countless tasks simultaneously. But what if you could direct all your Outlook mail, perhaps to your trusty Gmail account? That's exactly what we're about to explore in this article. Continue reading
Picture this: you've created a perfect set of rules in Outlook to manage your emails, only to find they're not working as intended. It's like buying a watch only to realize it doesn't tell time - a frustrating experience. Continue reading
If you've become accustomed to using rules to manage your email flow in classic Outlook, you'll be pleased to know that the new Outlook also includes this feature. Despite some differences in the setup process and a slightly reduced set of options, you can still create rules to automate the sorting of your emails and keep a tidy inbox. Continue reading
Imagine your Outlook as a tidy room where important emails are prioritized, distractions are filtered out and everything is neatly sorted into its rightful place. That's what Outlook rules can do for you. Continue reading
As your inboxes are overflowing with never-ending streams of emails and calendars are packed with numerous appointments, it's easy to feel swamped. However, there's a helpful tool in Microsoft Outlook called conditional formatting. Continue reading
Imagine that you are working late at night, inspired by a brilliant idea, and you write the perfect email. But hold on, it's already past midnight, and sending it now might get lost in the morning rush. What if you could make sure the message lands in the recipient's inbox exactly when they are most receptive? This is the power of scheduled email sending. Continue reading
The new Outlook and its accompanying web version have made many tasks easier. They also provide a simpler way to create and use email templates. But, like many other cool features, this one is tucked away from immediate view. Continue reading
You've got your data organized in a pivot table and are ready to dig in, but there is a catch – it has a time element. Maybe it's sales figures over months or project deadlines scattered throughout the year. How do you make sense of it all without drowning in numbers? The answer is timelines! Continue reading
If you've ever felt overwhelmed by a large and cluttered spreadsheet, you're not alone. Fortunately, Excel pivot charts provide an easy way to create stunning visualizations of your data. Pivot charts are like magic: they let you summarize, analyze and explore your data with just a few clicks. Continue reading