Excel tutorials, functions and advanced formula examples, page 8

MAX IF in Excel to get highest value with conditions

Almost every Excel user is familiar with the good old MAX function that is designed to return the largest value in a dataset. In some situations, however, you may need to drill down into your data further to find the max value based on certain criteria. Continue reading

Excel MAXIFS function - get largest value based on multiple criteria

Traditionally, when you needed to find the highest value with conditions in Excel, you had to build your own MAX IF formula. While not a big deal for experienced users, that might present certain difficulties for novices. Luckily, Microsoft has recently introduced a new function that lets us do conditional max an easy way! Continue reading

MAX function in Excel: formula examples to find and highlight highest value

MAX is one of the most straightforward and easy-to-use Excel functions. However, it does have a couple of tricks knowing which will give you a big advantage. Continue reading

How to create a table in Excel

At the surface, an Excel table just sounds like a way to organize data. In truth, this generic name covers a ton of useful features. Tables containing hundreds or even thousands of rows and columns can be instantly recalculated and totaled, sorted and filtered, updated with new information and reformatted, summarized with pivot tables and exported. Continue reading

How to insert Google Sheets checkmarks and cross marks

Lists help us put things in order. Stuff to buy, tasks to solve, places to visit, movies to watch, books to read, people to invite, video games to play - everything around us is practically filled with those lists. And if you use Google Sheets, chances are that it would be best to track your endeavours there. Let's see what instruments spreadsheets offer for the task. Continue reading

Sparklines in Excel: how to create, use and change

Looking for a way to visualize a large volume of data in a little space? Sparklines are a quick and elegant solution. These mini-charts are specially designed to show data trends inside a single cell. Continue reading

Useful Google Sheets functions that don't exist in Excel

This blog post brings the majority of those Google Sheets functions that Excel doesn't have to your attention. They are conveniently classified by Google based on their primary task. So just pick the group from the table of contents and you'll find their descriptions with the simplest examples. Continue reading

Schedule email sending and delay delivery in Outlook

Does it often happen to you that you send an email and a moment later you wish you hadn't? Perhaps you clicked Reply All instead of Reply, or accidentally sent sensitive information to a wrong person, or just realized that your angry response was a bad idea and you need to cool down. Continue reading

Handy tools to manage text in Google Sheets

Despite lots of perks offered by Google Sheets, it also has its drawbacks. A clear example of that is the shortage of simple tools to manage text. Are we bound to add or replace text in Google Sheets manually or with complex formulas? Not anymore. :) We've filled this gap with simple one-click tools. Allow me to introduce them to you in this blog post. Continue reading

How to recall email message in Outlook and Gmail

A hasty click of the mouse can happen to the best of us. So, the Send button is hit, your email is on its way to the recipient, and you are cringing at the thought of what it may cost you. Before you start weighing the consequences and composing an apology notice, why not try to retrieve the erroneous message? Continue reading

How to merge several Google sheets into one without copy-pasting

Every once in a while each Google Sheets user faces the inevitable: combining several sheets into one. Copy-pasting is tedious and time-consuming, so there has to be another way. And you're right - there are several ways, in fact. So get your tables ready and follow the steps from this article. Continue reading

Excel print area: how to set, change and clear

When you hit the Print button in Excel, the entire spreadsheet is printed by default. But what if you don't really need to print out all the content of a huge worksheet? Then set the print area that includes only your selection. Continue reading

How to print Excel spreadsheet: tips and guidelines for perfect printouts

Living in a digital world, we still need a printed copy every now and then. At first sight, printing Excel spreadsheets is super easy. Just click the Print button, right? In reality, a well-organized and beautifully formatted sheet that looks great on a monitor is often a mess on a printed page. Continue reading

How to change Google Sheets date format and convert dates to numbers and text

In this guide, you'll find out how Google stores dates and how you can format them for your better convenience. Some date formats are offered to you by spreadsheets while others should be created from scratch. There are even a couple of handy functions for the task. I also describe a couple of ways to convert your dates to numbers and text if necessary. Continue reading

How to calculate IRR in Excel with formulas, template and Goal Seek

When you know the internal rate of return of a project, you may think you have all you need to evaluate it - the bigger the IRR the better. In practice, it's not that simple. Continue reading

Google Sheets formulas for 12 most useful Google Sheets functions

This time we decided to provide you with the most simple Google Sheets functions that you definitely need to learn. They will not only help you with the plain calculations but also contribute to extending your knowledge of building Google Sheets formulas. Continue reading

How to use MIRR function in Excel to calculate modified internal rate of return

For many years, finance experts and textbooks have warned about the flaws and deficiencies of the internal rate of return, but many executives keep using it for assessing capital projects. Do they enjoy living on the edge or simply are not aware of the existence of MIRR? Continue reading

Excel XIRR function to find internal rate of return for non-periodic cash flows

Calculating IRR for periodic cash flows is easy. In real life situations, however, cash inflows and outflows often happen at irregular intervals. Thankfully, Microsoft Excel has a special function to find IRR in such cases, and this tutorial will teach you how to use it. Continue reading

CONCATENATE function: formulas to merge cells in Google Sheets

"Concatenate" usually means to link something together in a series or a chain. This operation is used in Google spreadsheets whenever you need to join records from multiple cells. This article collects the most popular and easy solutions to help you solve the concatenation puzzle. Continue reading

How to use Excel IRR function to calculate internal rate of return

IRR in Excel is one of the financial functions for calculating the internal rate of return, which is frequently used in capital budgeting to judge projected returns on investments. Continue reading