# Excel tutorials, functions and advanced formula examples, page 9

## How to use MINIFS function in Microsoft Excel

When it comes to finding the minimum based on conditions, there are several possible solutions. You’ll see different approaches to locate the lowest value and choose the one that suits best for you. Continue reading

## Excel MIN function - usage and formula examples

If you have a large range of data to find the lowest value in, the scrolling and looking for it manually is not an option. Please check different ways of locating a minimum number in Excel and choose the best one for your task. Continue reading

## How to share Outlook calendar

Want to let your colleagues, friends and family members know what's on your schedule so they can see your free times? The easiest way is to share your Outlook calendar with them. Depending on whether you use a locally installed desktop app or Outlook Online, an Exchange Server account within your organization or a private POP3 / IMAP account at home, different options will be available to you. Continue reading

## How to share and publish calendar in Outlook on the web and Outlook.com

If you have an Office 365 subscription or are subscribed to another Exchange-based mail service, you can use Outlook on the web to share your calendar with coworkers, friends and family members. Continue reading

## Video: how to merge 2 Google sheets

This video tutorial explains how to keep your Google Sheets tables up-to-date with the Merge Sheets add-on. The tool will scan two tables for matches and do a quick vlookup. It will update old records, add missing info, and pull new rows and columns to your main table. Continue reading

## 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