May
4
How to dynamically change color, width, and style of cell borders in Outlook table
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
Tutorials for Excel, Outlook and Google Sheets, page 7
Apr
29
Google Sheets: remove the same text or certain characters from multiple cells at once
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
Apr
28
Spilling in Excel: what it means and how to use it
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
Apr
27
How to use conditional formatting in Outlook tables
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
Apr
21
How to make Outlook email template with fillable fields, variables and dropdowns
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
Apr
19
Auto-fill rows and tables in Outlook email templates
This manual will teach you how to connect one or several datasets to an Outlook table and fill it in automatically. Continue reading
Apr
15
Add text to multiple cells in Google Sheets at the same position
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
Apr
14
How to remove duplicates in Excel cell
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
Apr
13
How to create and format tables in Outlook email templates
In this article, you’ll see how to create, modify and fill Outlook tables and use them as templates for your emails. Continue reading
Apr
7
Excel spill range explained
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
Mar
31
Implicit intersection - meaning of @ sign in Excel formulas
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
Mar
24
Excel #SPILL! error - causes and fixes
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
Mar
18
Excel: prevent text from spilling over into next cells
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
Mar
10
Using NPER function in Excel with formula examples
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
Mar
3
How to use PV function in Excel to calculate present value
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
Feb
24
How to calculate present value of annuity in Excel: formula and calculator
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
Feb
23
How to change case in Google Sheets: UPPER, lower, Capitalize Each Word, Sentence case, tOGGLE
Changing text case in Google Sheets may seem an intricate task as there is no such option in the standard menu. Even so, the task is very much resolvable. In this blog post, I share different ways to capitalize your words or turn them into lowercase, uppercase, and sentence case. Continue reading
Feb
17
How to make and use Excel data entry form
When it comes to inputting information in Excel spreadsheets, most people do it the traditional way - cell by cell, row by row. To make the process more use-friendly and less time-consuming, you can use a special data entry form. Continue reading
Feb
10
Using LET function in Excel with formula examples
If you work with lengthy formulas in Excel, then you are certainly familiar with the idea of named ranges that make complex formulas easier to read. And now, Microsoft is making a step further and allows assigning names to calculations and values directly in a formula. Continue reading
Feb
3
How to find and fix broken links in Excel
Excel cells may often link to other workbooks to pull relevant information from there. When a source workbook gets deleted, relocated, or damaged, external references to that file break down and your formulas start returning errors. Obviously, to fix the formulas, you need to find broken links. Continue reading
Jan
27
How to find and remove external links in Excel
External links, or external references, are a very common practice in Excel. After completing a particular task, however, you may want to find and probably break those links. Continue reading
Jan
22
How to create Outlook drafts with attachments and use them as email templates
This guide shows one more handy method of sending attachments in Outlook on the basis of Shared Email Templates. Continue reading
Jan
20
Set up dependent drop-down list for multiple rows in Excel
The introduction of dynamic arrays has made our lives as Excel users a lot easier. Among many other things, they significantly simplify the creation of dynamic drop down lists that you can copy across multiple rows. Continue reading
Jan
15
How to use Outlook drafts as email templates
Learn how to create drafts in Outlook and remove or restore them if necessary. Also, you’ll see the way to turn your drafts into templates to ease and hasten your Outlook correspondence. Continue reading
Jan
13
Excel FV function to calculate future value
Building your personal and corporate finances requires thorough planning. One of the most important factors of success is understanding how much an investment made today will grow to in the future. That is called the future value of investment, and this tutorial will teach you how to calculate it in Excel. Continue reading
Dec
16
5 ways to do VLOOKUP in Excel - which is fastest?
If your tables have only a few dozen rows, then most likely any method will be fast enough, and you won't notice the difference. But if the number of rows in your tables is measured in thousands, the correct choice of the function is crucial - the difference in performance can be more than 10 times! Continue reading
Dec
9
Excel RATE function: formula examples to calculate interest rate
Financial decisions are important part of business strategy and planning. In everyday life, we also have quite a lot of financial decisions to make. For such scenarios, Excel provides the RATE function that will help you calculate an interest rate for a specific period. Continue reading
Dec
2
LARGE IF formula in Excel: find highest values with criteria
While working with numeric data in Excel, you may often need to get the highest numbers based on criteria. The bad news is that the LARGEIF function does not exist in Excel. The good news is that you can easily construct your own LARGE IF formula. Continue reading
Nov
25
How to highlight top or bottom 3, 5, 10 values in Excel
In case you want to bring focus to the highest or lowest N values in a dataset, the best way is to highlight them in different colors. This article will teach you how to do this with Excel's presets and create your own conditional formatting rule based on formula. Continue reading
Nov
19
How to find top or bottom N values in Excel
Want to identify the highest or lowest values in a column or row? Need to return not only the values themselves but their names too? With this tutorial, you will learn how to find top 3, 5, 10 or n values in a dataset and retrieve matching data. Continue reading
