Imagine this: you receive raw data for analysis and find out that numbers are mixed with text in one column. In most cases, it will certainly be more convenient to have them in separate columns for closer examination. Continue reading
By default, Excel tables are equipped with a number of great features including predefined table styles. In some situations, however, you may want to remove formatting keeping all other functionality of a table. This tutorial will teach you how to quickly do that. Continue reading
This next bit of our operations with text in spreadsheets is devoted to extraction. Find out ways to extract various data – text, characters, numbers, URLs, email addresses, date & time, etc. – from various positions in multiple Google Sheets cells at once. Continue reading
Excel Conditional Formatting makes it possible to highlight duplicates in every possible way you can think of. But, as usual, there is a "but" - conditional formatting rules work on a cell level while you may want to highlight duplicate text rather than entire cells. This can only be done with macros. Continue reading
How do people usually search in Excel? Mostly, by using the Find & Replace tool, which works just fine for single values. But what if you have tens or even hundreds of items to replace? Luckily, there are a few more effective methods to perform mass replace in Excel, and we are going to look at each of them in detail. Continue reading
If a major part of your online communication is repetitive emails, it would be only natural that you strive to optimize that part of your work. Replying with template can be a great alternative to composing emails from scratch in a tedious keystroke-by-keystroke way. Continue reading
With the introduction of the LAMBDA function, recursive computations in Excel have become available to anyone, not just VBA programmers. To put it simply, you can now construct formulas that behave like a programming language and allow you to achieve so much, with so little, so fast :) Continue reading
Until recently, user-defined functions were the prerogative of programmers. The introduction of the LAMBDA function has made them available for everyone. With this wonderful addition to Excel's toolbox, we no longer need VBA skills to create our own custom functions. Continue reading
An engaging and informative invitation is an important part of running a successful meeting, and a well-crafted template can save you enormous time on the job. This article looks at how to quickly create meeting templates in Outlook, preset any fields, add input boxes, drop-down menus, and more! Continue reading
When doing the same things day in and day out, most irritating is the necessary do it from scratch every time. What would you say if instead of tedious multi-step processes you could accomplish your email routines with a button click? It is what Outlook Quick Steps are all about. Continue reading
It is sad enough when a brand-new feature refuses to work in your Excel. But even more frustrating is when a good old thing stops working all of a sudden, and you are receiving an error for a formula that worked perfectly for years. This tutorial will teach you how to fix a #SPILL error in some popular formulas. Continue reading
Want to create a dropdown list in your email template? Make it possible to select multiple items? Populate a dropdown from a database? You will find all the solutions in this tutorial. Continue reading
This manual will show you different ways to create nested Outlook templates. You’ll see how to use predefined templates and add dynamic fields to your emails. Continue reading
Is duplicate data in your worksheets causing you a headache? This tutorial will teach you how to quickly find, select, color or delete duplicate cells. Continue reading
In this manual you’ll see how to apply conditional formatting to Outlook tables in order to change their borders’ color, width or style. Continue reading
Learn formulas and formula-free ways for Google Sheets to trim whitespaces, remove special symbols (even the first/last N characters) and the same text strings before/after certain chars from multiple cells at once. Continue reading
The recent dynamic array update has bought a wealth of inspiring new capabilities. But all is centered around the core concept of "spilling". So, let's take a close look at this feature and how you can leverage it to improve your Excel experience. Continue reading
This manual will teach you to conditionally format your Outlook tables and change the color of their text and background in a blink of an eye. Continue reading
If replying to repetitive emails is part of your daily routine, then most likely you are using Outlook templates to automate this part of your work. But what if your template contains some variables that you need to change before an email goes off? Continue reading
This manual will teach you how to connect one or several datasets to an Outlook table and fill it in automatically. Continue reading
This tutorial will teach you to add text in Google Sheets cells at the same position of all cells at once: at the beginning, at the end, after the N-th character, before or after particular characters. Continue reading
When it concerns removing duplicate cells or rows, Microsoft Excel offers a number of different options. But when it comes to removing duplicate text within a given cell, Excel provides… nothing. Well, if there is no inbuilt function we need, let's go write our own one. Continue reading
In this article, you’ll see how to create, modify and fill Outlook tables and use them as templates for your emails. Continue reading
Spilling is one of the new features introduced in Excel 365 as part of the dynamic arrays functionality. Understanding the spill range concept is the focus of this tutorial. Continue reading
You have the feeling you know everything about your Excel workbooks, and then a @ character appears from nowhere in the beginning of your formulas. What does this mean? And how does it work precisely? Continue reading
Just imagine this: you upgraded to Microsoft Office 365 with the latest Excel updates and for some reason the tried and tested formulas you've been using for years have suddenly stopped working. Whatever you do, you are now getting a #SPILL error. Does anyone know what it means? Continue reading
When entering a long text in a cell, you may notice that sometimes it spills out into adjacent columns and at times gets hidden behind the neighboring cells. How does Excel determine what to do and how do you stop words from overflowing into next cells? Continue reading
When building corporate funds, financial analysts often wish to know how long it will take to reach the desired corpus. When applying for a loan, you may want to find out how many payments are required to repay it in full. For such tasks, Excel provides the NPER function. Continue reading
Weather you are thinking about buying an insurance annuity or putting some money in a saving account, you are wondering - is that a good deal? To know it for sure, you need to find the present value of an investment. For this, Microsoft Excel provides the PV function. Continue reading
If offered a choice to receive a certain sum of money right now or defer the payment into the future, which would you choose? For most of us, taking money now is a natural instinct. In the financial world, this is explained by the time value of money concept. Continue reading